import
GCC Consulting
gccconsulting at comcast.net
Tue Jan 10 08:03:36 PST 2006
CONVERT TO DBF, AND USE DBCOPY.
THIS WILL AVOID THIS PROBLEM
Richard Kreiss
GCC Consulting
-----Original Message-----
From: filepro-list-bounces at lists.celestial.com
[mailto:filepro-list-bounces at lists.celestial.com] On Behalf Of Steven Waters
Sent: Tuesday, January 10, 2006 10:49 AM
To: Filepro List
Subject: RE: import
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
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list
More information about the Filepro-list
mailing list