M
Mark Taylor
Hello all -
I have a problem here that I think can be solved using regular
expressions, but not knowing enough about them, I wanted to ask.
I'm pulling data from a database that we're provided that has all data
unformated, all names, addresses, whatever are all in capital letters,
zip codes, phone numbers, social security numbers are all run
together.
For example, we're getting zip code in the form '999999999', and last
name 'TAYLOR'.
What I'd like to do it use a regular expression to change the output
to '99999-9999' for zip codes, '999-99-9999' for social security
numbers and 'Taylor' for 'TAYLOR' and so on...
I've searched through google trying to find a solution. Can this even
be done? If so, could someone point me in the direction of a site
for a solution or provide a short code sample?
Thanks!!
Mark
I have a problem here that I think can be solved using regular
expressions, but not knowing enough about them, I wanted to ask.
I'm pulling data from a database that we're provided that has all data
unformated, all names, addresses, whatever are all in capital letters,
zip codes, phone numbers, social security numbers are all run
together.
For example, we're getting zip code in the form '999999999', and last
name 'TAYLOR'.
What I'd like to do it use a regular expression to change the output
to '99999-9999' for zip codes, '999-99-9999' for social security
numbers and 'Taylor' for 'TAYLOR' and so on...
I've searched through google trying to find a solution. Can this even
be done? If so, could someone point me in the direction of a site
for a solution or provide a short code sample?
Thanks!!
Mark