Re: .csv file imports to VFP

2023-04-17 Thread Ted Roche
On Mon, Apr 17, 2023 at 12:04 PM Joe Yoder wrote: > I thought I could simply preprocess the file and change each occurrence of > a single line feed with a comma but when I look at functions available I > suspect it will be painfully slow. > > Any ideas appreciated, > You ought to try it before

Re: .csv file imports to VFP

2023-04-17 Thread Richard Quilhot
You can use notepad ++ find and replace to preprocess the file. Rick Q quilh...@gmail.com On Mon, Apr 17, 2023 at 12:04 PM Joe Yoder wrote: > Alan and all, > I have researched the problem records and find that they have line feed > characters without a leading carriage return. This results

Re: .csv file imports to VFP

2023-04-17 Thread Joe Yoder
Alan and all, I have researched the problem records and find that they have line feed characters without a leading carriage return. This results from the operator hitting a return in a notes field of the accounting package I am using. Apparently Excel import insists on a combination of carriage

Re: .csv file imports to VFP

2023-04-17 Thread Srikanth Bhandari
This challenge may arise if the delimiter is also a value in the field content such as a comma. Ideally it would be good to use a delimiter which isn't ever used in the content such as the pipe symbol. Trust this should solve your challenge. -- Cheers!!! *Srikanth Bhandari* Email:

Re: .csv file imports to VFP

2023-04-16 Thread Philip Borkholder
Hi Joe, Some things you can check for in your character fields before you append are: CHR(10) CHR(13) CHR(2) CHR(3) CHR(4) Replace those with a blank if they exist. Also see if some of the character fields (like addresses) have a comma in them that might be separating it into a column before you

Re: .csv file imports to VFP

2023-04-16 Thread Alan Bourke
'Append from' has always been bombproof in my experience, as long as what you're giving it is correct. Do those problem rows have any weird non ASCII characters ir anything? -- Alan Bourke alanpbourke (at) fastmail (dot) fm On Sun, 16 Apr 2023, at 3:35 AM, Joe Yoder wrote: > I have an

Re: .csv file imports to VFP

2023-04-16 Thread António Tavares Lopes
Joe, you may consider using the CSVProcessor class at https://github.com/atlopes/csv. On Sun, Apr 16, 2023 at 3:36 AM Joe Yoder wrote: > I have an accounting system data dump that I export each year at tax time, > I think I have always had a few records that got mangled but this year I > would