N
noob
Guest
Good day.
i have a previous question in this link
https://stackoverflow.com/questions/45828926/how-to-export-fields-to-csv-in-openedge/45829432?noredirect=1#comment78621400_45829432
on the exported csv, i put on the first line the TABLE NAME. i wish to import this CSV to my system.
my current code is this:
DEF VAR ic as INT.
DEF VAR cTable as CHAR.
INPUT FROM VALUE(SESSION:TEMP-DIRECTORY + "temp.csv").
ic = 0.
REPEAT:
ic = ic + 1.
IF ic > 1 THEN DO:
CREATE cTable.
IMPORT DELIMITER "," cTable.
END.
IMPORT cTable.
END.
INPUT CLOSE.
i know that the code is wrong in CREATE part. How do i do this? 2. When i EXPORT, there is an additional BLANK line after the last record. how do i remove this without opening the CSV file?
Continue reading...
i have a previous question in this link
https://stackoverflow.com/questions/45828926/how-to-export-fields-to-csv-in-openedge/45829432?noredirect=1#comment78621400_45829432
on the exported csv, i put on the first line the TABLE NAME. i wish to import this CSV to my system.
my current code is this:
DEF VAR ic as INT.
DEF VAR cTable as CHAR.
INPUT FROM VALUE(SESSION:TEMP-DIRECTORY + "temp.csv").
ic = 0.
REPEAT:
ic = ic + 1.
IF ic > 1 THEN DO:
CREATE cTable.
IMPORT DELIMITER "," cTable.
END.
IMPORT cTable.
END.
INPUT CLOSE.
i know that the code is wrong in CREATE part. How do i do this? 2. When i EXPORT, there is an additional BLANK line after the last record. how do i remove this without opening the CSV file?
Continue reading...