CSV Import Value Shift - How to stop

%3CLINGO-SUB%20id%3D%22lingo-sub-2393473%22%20slang%3D%22en-US%22%3ECSV%20Import%20Value%20Shift%20-%20How%20to%20stop%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2393473%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20bring%20a%20CSV%20into%20ADF.%20The%20CSV%20has%20a%20field%20that%20is%20a%20relatively%20long%20free%20text%20field%20that%20also%20contains%20commas%20between%20string.%20I%20think%20this%20is%20causing%20the%20values%20to%20shift%20when%20I%20attempt%20to%20import.%20Has%20anyone%20else%20experienced%20this%3F%20If%20so%2C%20is%20there%20a%20way%20to%20solve%2Fescape%20these%20commas%20so%20the%20shifting%20stops%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3EBwash%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2393473%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Data%20Factory%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi all,

 

I am trying to bring a CSV into ADF. The CSV has a field that is a relatively long free text field that also contains commas between string. I think this is causing the values to shift when I attempt to import. Has anyone else experienced this? If so, is there a way to solve/escape these commas so the shifting stops?

 

Thanks!

Bwash

0 Replies