Posted by Marc Shevick on November 09, 2017 at 10:23:44:
In Reply to: Re: determining WHICH caused E46 on CSV file posted by Grant Foraker on November 09, 2017 at 08:41:05:
I do a lot of work with .csv files. I've gotten into the habit of never using a numeric variable in a .csv format statement. Each field is defined as a string. I have created a 'use' / 'include' file that takes a field called data$, removes '$', ',','"', deals with leading negative signs, parenthesis, etc. and then moves the result back to the original string field. I then convert that string field to a numeric. So I make data$ = numeric.string$, gosub convert, numeric.string$ = strip(data$), print (#) numeric.string$, input (#) numeric.variable.
Post a Followup
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.