Hello
Ive got a data dump from a system for a database. It is comma delimited with a text qualifier of (chr(34), double quote).
Problem:
The name fields have commas! The name fields are qualified with double quotes so the comma throws off my import. Plus there is null values i.e.:
data,20050101,,,more data,,,
which I am having problems with for my perl
So I need to:
* count and display the fields I have that have embedded comma(s) between double quotes (chr(34))
* then Ill need to do a substitution to replace said embedded comma with a space.
* then Ill use the counter to verify I fixed them all!
Make sense!?
NOTE: There will be NO non printable characters in my name field, there could be slashes, dots, spaces for sure, numbers, or parenthesis. Basically what a user would type in the name field for your average input system, if there is such a thing
EXAMPLES FOR CLARIFICATION
Count and display stuff like this
,"YUMA WORC CENTER, INC.",
,"CANON U.S.A., INC.",
,"ORION, PLANET SOLUTIONS, LLC",
But not:
,,,,, Which represent NULL values for certain fields.
So a full line might be:
DATA,20050101,"YUMA WORC CENTER, INC.",20050601,CO,,,145
.25
And all I want is:
,"YUMA WORC CENTER, INC.",
I would after properly identifying make a change like this (substitute , with a space):
,"YUMA WORC CENTER, INC.", BECOMES:
,"YUMA WORC CENTER INC.",
and
,"CANON U.S.A., INC.", BECOMES:
,"CANON U.S.A. INC.",
Ive tried but it pulls in my null values
perl -ne "print $1 . \"\n\" if /\"(.*,.*)\"/g" c.txt
Thanks for your help!
\M
Start Free Trial
