Data Extraction Issue

[skunal]

I have the file in which i have the entries as "abc","bbb","kkk,ggg,ttt","uuu" . As per the entries i have shown i am using "," as delimiter for extraction data from file.BUT the value kkk,ggg,ttt is one string itself not sperate and this type of string may be in other entries in file also. So in this case howz its possible to extract the data in the correct way so that i get kkk,ggg,ttt as one string itslef and not seperate.Can anyone suggest the solution

 

[MaximMonin]

chnage separator to |

 

[skunal]

I cannot change the file

 

[MaximMonin]

then you have to analize even parity of " symbol

 

[Stefan]

The static IMPORT statement with DELIMITER option automatically handles this.

 

[Dawn M]

Progress has a solution for this in their KBase. It's ID P112126 "How to import a CSV file which contains commas in the data?".