Subject Re: separator for CSV file to be imported into dBase From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Wed, 23 Sep 2020 22:22:15 +0530 Newsgroups dbase.getting-started Good Evening Jean, This is my last post for the day, before I go to bed. > 2014;INTOS;INTOS;S&P;CANDE;SP 75 - S25;SP 75;25;16,40;USD;IT;ETE;0;0;0;0;0;0;50;0;100;0;25;0;175;CC > the end of the line will be "CR LF" standing for carriage return - line feed > > another line can look like : > > 2014;CHEL;CHEL COMPIGE;NOF-OC;WBRID;DE S-753 - F200;DE S 753;200;21,95;EUR;FR;CRA;0;0;0;0;0;0;600;0;600;0;800;0;2000;CC > the end of the line will be "CR LF" Standing for carriage return - line feed CR LF is an advantage not an issue. You will have to opt in for the DIY route but it will take a bit more coding. Convert the above line to "2014","CHEL","CHEL COMPIGE","NOF-OC","WBRID","DE S-753 - F200","DE S 753","200","21,95","EUR","FR","CRA","0","0","0","0","0","0","600","0","600","0","800","0","2000","CC" > This file can be thousands of lines > It will have to be processed line by line into a new csv file and then imported into dbase. The comma , will be treated as part of string enclosed in double quotes "21,95" and not as a separator. You will have to be creative with string functions. Regards Akshat