| Subject | Re: Automated DBF export to CSV |
| From | Mervyn Bick <invalid@invalid.invalid> |
| Date | Thu, 21 Sep 2017 22:16:55 +0200 |
| Newsgroups | dbase.getting-started |
On 2017-09-21 7:39 PM, Tom McDermott wrote: > Mervyn, > Thank you for this description of how to handle this request. > Based on your questions, I think the best approach for me would to keep this as simple as possible just to see if I can get something running every day that can be used. > > I would really like have the following: > -I will not append data; I want the full extract every day > -the date form yyyymmdd is acceptable in the .csv file > -pipe delimiter would be preferred if possible > -I am OK with the output file in the same folder as the input file > -I want the field names included as the first record > -I am not sure if the _dbaselock field is included; can we try this assuming it is not there? > > Thank you again. I really appreciate all your time. Delimiter is the character used to wrap the contents of character fields. The default is a double quote. 20170921,1.2,"this is text","and more text",23.6,450.99 When you say a pipe delimiter do you mean you want something like the following? 20170921,1.2,|this is text|,|and more text|,23.6,450.99 dBASe allows one to set the delimiter but it doesn't allow one to change the separator from a comma to something else. It can be done but it needs to be done programmatically and then, of course, it isn't really a .csv (comma separated values) file. :-) The built in ability to create .csv files doesn't include the field names so this is going to have to be a program but try the following from the Command panel. Type in the following with enter after each line. use whatever.dbf copy to whatever.csv delimited with '|' use modi comm whatever.csv This will open the .csv flle in the sourcecode editor so that you can inspect it. If everything you want is in the file except the field names the battle is virtually won. What is the name of the daily .dbf file? Mervyn. . | |