import

[Joe Chasan]

On Tue, Jan 10, 2006 at 07:49:21AM -0800, Steven Waters wrote:
> 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

the commas within data are not a problem, as if data is enclosed 
with quotes then with import word fp can handle it.

i have not tried how fp handles quotes within quoted data with import
word.  you can give it a shot if you want or maybe ken or someone else
will chime in and save you the trouble.

you will also notice that excel has a tab-delimited option in the save-as
dialog box - would that work for you, or are there tabs in the data as
well.

-joe
 
> 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
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
--- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ---
-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