import

[Steven Waters]

Because the data has "," in the description fields
some data is surrounded by quotes or commas for example
a description might be like this,

"valve",for ,"A/C 100-8" 

my data runs all over the place. That's why I was wondering if you can
get excel to export not csv but tsv as in "~"
thanks for the mid advice
-

On Tue, Jan 10, 2006 at 07:18:19AM -0800, Steven Waters wrote:
> here is my code
> 
> 
> loop   
 If:
> 

>        Then: import ascii imp = /f/appl/fpmerge/tgicaps.txt r=\n f=255 
> 

>   3  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
-
>        
 If: not imp
> 

>        Then: close imp;end
> 

>   4  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
-
>        
 If:
> 

>        Then: lookup pnsFL = tgicaps  r=free  -n 

>   5  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
-
>        
 If:
> 

>        Then: pnsFL(1)=imp(1)
> 

>   6  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
-
>        
 If:
> 

>        Then: pnsFL(2)=imp(2)
> 
> ----{Repeat code for field 3 through 8]----
>              
> 13  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
-
>        
 If:
> 

>        Then: goto loop        

with f=255 there is no imp(2) - you chose 255 as FIELD separator simply
because it was unlikely to be used and you'd then have everything stuffed
into field 1 - the idea that i think jeff was implying was that you'd then
have to pick apart imp(1) via mid to put it into proper fields.

what i don't understand is that if you can get it into excel, why don't you
just use the csv export from excel (see save-as dialog box)?

--- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ---
-Joe Chasan-                      Magnatech Business Systems, Inc.
joe at magnatechonline.com           Hicksville, NY - USA
http://www.MagnatechOnline.com    Tel.(516) 931-4444/Fax.(516) 931-1264