Subject Re: separator for CSV file to be imported into dBase From jean R. from Paris <jrsp@sovenibe.fr> Date Mon, 28 Sep 2020 12:00:01 -0400 Newsgroups dbase.getting-started Thank you so much Buza Vasile It will take me a few days to test because I will be out of work but I let you know asap. Thank you Buză Vasile Wrote: > > Hi Jean, > > In attachment is a test program for your file. > let me know  if it is helps > > Vasile > > "Jean R. from Paris"  a scris în mesaj news:xghACKckWHA.3264@ip-AC1E04A7... > > Mervyn Bick Wrote: > > > On 2020/09/23 15:54, Jean R. from Paris wrote: > > > Hi > > > > > > I have some large CSV files to get imported into dBase. > > > the fields separators being ";" dBase does not like that > > > Since I cannot change the fields separators. How could i go around the > > > limitation and find a way to import the CSV file into dBase > > > > Importdata.wfm in the dUFLP can handle files where a separator other > > than a comma has been used.  This basically requires a fair bit of input > > from the user so it is OK for an occasional file but it becomes a > > nuisance if you have many files to deal with. > > > > The alternative is, as Akshat has said, to write code to do this your > > self. > > > > If you give more details we may be able to help. > > > > What version of dBASE are you using? > > > > Are character fields in the .csv file delimited with single or double > > quotes.  (The only need to be delimited if commas are included in the > > text but many programs add delimiters even if they are not needed.) > > > > If there are dates in the .csv file which will be imported into date > > fields in the dBASE table what format are they in? > > > > Mervyn. > > Thank you Mervyn > > I am using the latest dBase 2019-1 > > At this moment dates are not a concern because I am mostly dealing with > names and numerical values which can be kg or parices with "," as a > separator. > > fields are separated by the ";" only without double quotes which I use here > for the sake Clarity only. > > as an example one line of the CSV file can be as follows: > > 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 > > This file can be thousands of lines > > Other similar files to be processed can be 500 or more successive fields > which DBIMPORT cannot handle either. > > Thank you for your thoughts > > Jean R. from Paris > > > > > >