lcBuffer = FILETOSTR(lcFileName) lcBuffer = STRTRAN(lcBuffer, CHR(13) + CHR(10), "##CR##LF##") DIMENSION laLines[1] FOR i=1 TO ALINES(laLines, lcBuffer) * Parse line here and convert "##CR##LF##" back to CHR(13) + CHR(10) for the memo INSERT INTO ... ENDFOR>I am trying to code an import of a non standard CSV file.
>"AA0001","AA0001 has the following classes, <CR><LF>1. Class1<CR><LF>2. Classes 2, 3 & 4<CR><LF>Blah Blah","600.00",60,,"AA001"<CR> >"AA0002","AA0002 has the following class, <CR><LF>1. Class1<CR><LF>Blah Blah","700.00",50,,"AA002"<CR> >>