I have some text files that look like this:
"Smith","Tom","1234 Main Street"
"Jones","Robert L","9876 Elm Street"
"Williams","John Quincy","123 USA Street"
etc,etc
They are already in comma-delimmited, which is what I want.
But I need to import them into a database whose fields are slightly different.
The database has fields like this:
Last Name
First Name
Middle Initial (Initial only, not full middle name)
so, with the above examples, I need my delimmited file to look like this:
"Smith","Tom",,"1234 Main Street" (has extra ',' for blank)
"Jones","Robert","L","9876 Elm Street" (delimits mid init)
"Williams","John","Q","123 USA Street" (takes first letter of "Quincy" and delimits it as just "Q"
I also have Perl available, which will probably work better but I'm unsure how to accomplish this??
ideas? suggestions? help? hints? tips?
thanks in advance
Scott Ullmann
TelespectrumFX
"Smith","Tom","1234 Main Street"
"Jones","Robert L","9876 Elm Street"
"Williams","John Quincy","123 USA Street"
etc,etc
They are already in comma-delimmited, which is what I want.
But I need to import them into a database whose fields are slightly different.
The database has fields like this:
Last Name
First Name
Middle Initial (Initial only, not full middle name)
so, with the above examples, I need my delimmited file to look like this:
"Smith","Tom",,"1234 Main Street" (has extra ',' for blank)
"Jones","Robert","L","9876 Elm Street" (delimits mid init)
"Williams","John","Q","123 USA Street" (takes first letter of "Quincy" and delimits it as just "Q"
I also have Perl available, which will probably work better but I'm unsure how to accomplish this??
ideas? suggestions? help? hints? tips?
thanks in advance
Scott Ullmann
TelespectrumFX