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