Maximum Aardvark

« Thanks for the tip | The Reg Strikes Again »

Ahh, Regular Expressions

I've been having a hard time at work the past few days, as I try to massage data provided by the likes of Qwest (among others) into a format that I can use. The problem has been that no one company seems to approach the distribution of this data the same way, and I thought for awhile that I'd need to manually enter 2000+ records into a database.

Perl and regular expressions to the rescue!

Making use of two regular expressions has simplified my life greatly. I've written two perl scripts (each slightly unique) and have imported all of the data with a minimum of fuss.