excel / import
Jeff Harrison
jeffaharrison at yahoo.com
Wed Mar 16 20:20:42 PST 2005
--- "Lerebours, Jose" <Jose.Lerebours at EagleGL.com>
wrote:
[snip]
> I believe that it should work even if he uses
>
> import ascii ifile = [_SOURCE_FILE_] f=, r=\n o="
> c="
>
> The fact the f=, tells filePro to split fields based
> on
> the existence of a comma, it will just fine in the
> absence of the quotes.
>
> And you are right, excel does exactly that (even
> with
> text fields).
>
> Of course, you are likely to run into problem if
> your
> data contains quote within
>
> SAMPLE: 30' 6" PVC Pipe
Right, if you are going to use delimited files it is
of course best to choose something that could not
appear in your data. A tab delimited file should
usually fit the bill.
>
> Then your options change and some more programming
> work
> or data editing might be required.
>
> I think there is a way to tell excel to use a
> special
> character as the field separator (I know my
> colleagues in
> South America have it set to use a semicolon in lieu
> of
> a comma - Then again, commas are used in lieu of
> period
> for $$$ and numeric fields).
>
[snip]
There is a save option for a tab delimited file in
Excel.
Jeff Harrison
jeffaharrison at yahoo.com
Author of JHExport and JHImport. The easiest and
fastest way to generate code for filePro exports and imports.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
More information about the Filepro-list
mailing list