import

[Jeff Harrison]

--- Steven Waters <steven at triumphinstruments.com>
wrote:

>  
> 
> Quoting Jeff Harrison (Mon, 9 Jan 2006 14:34:03
> -0800 (PST)):
> [...]
> > Sorry, I thought that I had done that in the past,
> but I guess I was 
> > confusing it with export ascii.  At any rate you
> should be able to 
> > specify "r=\n f=~" (or something else for the
> field separator that you 
> > know is not in the data)
> 
> I believe that "f=255" works "best" for this.
> 
> 
> I did f=255 and still only get the first record
> imported.
> Is there a way to tell excel when saving as csv not
> to use commas
> but to use "~"? Or when in the txt file add the ~
> separator?
> Here is one line of my data. I am still trying the
> alien file suggestion.
> 
> 30210                        300 Cu-in. Brake Sys
> Accumulator
> 32     32-40-01   Landing Gear                      
>                     737
> EFS Aerospace, Inc.
> 
> Thanks for all of the help,
> Steve
> 
> 

There is a way to create a tilde separated file in
excel but I don't think that is what you need here. 
When you use f=255 what you are doing is using a field
separator that will not appear in the data - basically
you are tricking filepro into not using a field
separator - which is what you want.

My guess is that you are not looping back to the
import line, and that is why you are only getting the
first line.  Perhaps if you posted your code we could
spot the problem.

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The easiest and
fastest ways to generate code for filePro exports and
imports. 


		
__________________________________________ 
Yahoo! DSL – Something to write home about. 
Just $16.99/mo. or less. 
dsl.yahoo.com