cancel
Showing results for 
Search instead for 
Did you mean: 

Comma-delimited values

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Sachin,

You cannot load this data "," as Data Separator, Try to replace this in Flat File with anything else like ";" ...in flatfile Use Edit --> Replace ..

Hope this helps,

Sudhakar.

Former Member
0 Kudos

Sudhakar

I found the solution. The escape sign has to be defined as the double quote ("). It ignores any comma in the value between escape sign.

Your solution will also work though. Thanks.

Answers (0)