import

[Joe Chasan]

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