J
Joseph Kreifels
Guest
If I have a CSV file that doesn't use double quotation marks except for items with commas. Sample Data name,age,description,state Johnson,43,"He loves apple pie, but is allergic to apples",PA I can't use the standard entry() method because it will split the description into 2 parts. "He loves apple pie" " but is allergic to apples" I've noticed software like Excel knows that when a item is wrapped in double quotation marks, it should ignore delimiters. Is there a way to parse a CSV file into a temp table following the CSV standards? I am using Progress 10.2B on RHEL. If Progress can't parse the file, there may be a outside option through batch or Python that can be invoked to make changes to the CSV during runtime
Continue reading...
Continue reading...