VFP9 CSV Parse Against Cursor Values
Posted on 2010-11-11
Hi all. I have a csv file which contains about 18,000 lines (records), 30 fields in each.
I also have a cursor with names of states, 'Alabama', 'Alaska', 'Arizona', etc.
Not all states are in the cursor.
What I need to do is process the csv file so that any records in the csv containing a state that is not in the cursor are removed, and speed is important.
The format of the csv is:
"Arthur","Florida", (+28 more fields)
"Phillips","Alaska", (+28 more fields)
I'm assuming CHR(13) + CHR(10) for line feed.