FiveTech Software tech support forums

Rao: 1. Not working === not importing the text file into the dbf 2. 200% sure the delimiter is CRLF First 10 data lines: "1679576722","1","","","","WIEBE","DAVID","A","","","M.D.","","","","","","","","","","PO ...

1. "Does not work" means what is happening?
2. Are you sure the line delimiter is CRLF?
3. First let us concentrate on making sure the main logic works and later we can add frills like meters, menus,etc.

Please post dbf structure as array
and
Post 10 lines of csv file.

Mr Nages,

Now I have another file but with no ";" delimiter and I not Know how I can make to converte this txt into dbf

the file can be download from http://sys.sistemiwinforlife.it/estrazi ... bzh1n.txtv

Hola, a ver si te sirve
http://forums.fivetechsupport.com/viewtopic.php?f=3&t=18285&start=0&hilit=append+from+delimiter

Update 1.2

Download :
http://www.pflegeplus.com/fw_downloads/dbfcsv2.zip

new :
1. delimiter added
2. save / load Job to / from a INI



Best Regards
Uwe

Not bad,

Missing option to choose separator (delimiter)
Comma is default separator but most used separator in practice is "|" especially if you use SQL
Probably need to control not to be a binary character.

Best regards,

How can I use functions of Harbour OR Fivewin to stores pages delimited by any page delimiter(FormFeed,string) into a Memo field . Each page is identified by a unique key in certain page of a file(eg : Account number) certain line ,certain position ,fixed length of ...

Format: TYPE SDF | DELIMITED [WITH <delimiter>|BLANK] If the desired FROM <file> is not a database, the TYPE clause may be used to specify SDF or DELIMITED <file> formats. The default extension for these formats is "TXT". ...

... = Provides a space for you to specify an additional compiler options. User Defines = Shows the switches the tool will use to build. Use ';' as delimiter. Linker Options = Provides a space for you to specify an additional linker options. Excluded Files = This will exclude the file(s) included ...

... = Provides a space for you to specify an additional compiler options. User Defines = Shows the switches the tool will use to build. Use ';' as delimiter. Linker Options = Provides a space for you to specify an additional linker options. Excluded Files = This will exclude the file(s) included ...

Hi Aljoscha A CSV file is separated by commas not semi colons as in your data. I know that you set the DELIMITED option to a semi colon but the delimiter character is the character that encloses character fields. The character fields in your data are enclosed with double quotation marks which ...

... hStrg:=  'EMAIL;ANREDE;NAME;VORNAME;ZUSATZ;STRASSE;LKZ;PLZ;ORT;BRIEFANRED;TITEL;FIRMA1;FIRMA2' The merge fields and data fields are separated by a delimiter. 2) insert data and I check that there is no delimiter inside the data. do while .not. eof()hStrg:= ;(STRTRAN(ALLTRIM(kunden->email ...

... = Provides a space for you to specify an additional compiler options. User Defines = Shows the switches the tool will use to build. Use ';' as delimiter. Linker Options = Provides a space for you to specify an additional linker options. Excluded Files = This will exclude the file(s) included ...

... = Provides a space for you to specify an additional compiler options. User Defines = Shows the switches the tool will use to build. Use ';' as delimiter. Linker Options = Provides a space for you to specify an additional linker options. Excluded Files = This will exclude the file(s) included ...

... = Provides a space for you to specify an additional compiler options. User Defines = Shows the switches the tool will use to build. Use ';' as delimiter. Excluded Files = This will exclude the file(s) included in this UE project group from the build. [SettingsReps] User Defines = @[;|-D%s] ...