Export csv
Jeff Harrison
jeffaharrison at yahoo.com
Fri Aug 19 07:25:00 PDT 2005
--- GCC <gccconsulting at comcast.net> wrote:
> Created an export to a csv file as I have done many
> times.
>
[snip]
> Can anyone tell me why the 72"(inch) caused this
> problem? How would one avoid
> the problem if the " was a necessary part of the
> text field?
>
> Richard Kreiss
> GCC Consulting
>
>
The problem appears to be with Excel. Since you are
exporting to a csv file that uses a quote character as
an opening and closing field delimiter it looks like
excel is getting confused when it sees that character
in the data.
The best way to solve this I think is to use another
format - one that uses delimiters that could not
possibly be in the data would work.
Ok, I just tried it myself with the "export dif"
command to make a .dif file and it did not read my
data with a quote properly. However, when I used the
"export multi" command to create a .slk file, it did
give me the proper result.
So that looks like one way to handle this. The
advantage of the .slk file over the other delimited
files is that Excel will automatically read them
without going into the wizard - just like it
automatically reads .csv files.
Jeff Harrison
jeffaharrison at yahoo.com
Author of JHExport and JHImport. The easiest and
fastest ways to generate code for filePro exports and imports.
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
More information about the Filepro-list
mailing list