Re: determining WHICH caused E46 on CSV file

[ Follow Ups ] [ Post Followup ] [ Signature.net Forum ]

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.

Follow Ups:


Post a Followup

Name:
E-Mail:

Subject:

What is the name of the main Signature System's Product?  

Comments:

Optional Link URL:
Link Title:
Optional Image URL:

You may attach up to 5 files to your followup (see below):





Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.

[ Follow Ups ] [ Post Followup ] [ Signature.net Forum ]