Skip to Content
0
Former Member
Jul 20, 2007 at 03:10 PM

Comma-delimited values

27 Views

I need to load a flat file with lane and average cost which look slike below

"AKRON, OH-ALSIP, IL",623.00

"AKRON, OH-BENTON HARBOR, MI",877.00

"AKRON, OH-FOGELSVILLE, PA",1187.00

"AKRON, OH-GRAND PRAIRIE, TX",2335.00

The lane value itself has comma in it. How to load such a csv file if one value has comma in it.