G
Garry Hall
Guest
I just test it in 11.7, and it worked for me. DEFINE VARIABLE c1 AS CHARACTER NO-UNDO. DEFINE VARIABLE c2 AS CHARACTER NO-UNDO. DEFINE VARIABLE c3 AS CHARACTER NO-UNDO. DEFINE VARIABLE c4 AS CHARACTER NO-UNDO. INPUT FROM "csv.txt". REPEAT: IMPORT DELIMITER "," c1 c2 c3 c4. DISPLAY c3 FORMAT "x(50)". END. INPUT CLOSE. c3 -------------------------------------------------- description He loves apple pie, but is allergic to apples IMPORT is the statement used for dictionary dump and load. It has to handle delimiters in quoted character data, even if the delimiter is embedded in the quoted data. The default delimiter is " " (space), so IMPORT must be able to handle embedded spaces. As long as your quote starts after your delimiter, it should work.
Continue reading...
Continue reading...