import fails to get a comma

John Esak john at valar.com
Sun Oct 2 17:46:22 PDT 2005


Incidentally, I don't KNOW that IMPORT has a problme with commas... I just
showed you how to get rid of a comma and substitue something else (the colon
in s this case, because there was one in all your other filenames and it
didn't seem to bother things...)  Ken's note prompted me to wonder why you
actually nedd this code... but that is another matter. The XLATE will work
whether you do or not. :-)

JOhn

> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com
> [mailto:filepro-list-bounces at lists.celestial.com]On Behalf Of John Esak
> Sent: Sunday, October 02, 2005 8:30 PM
> To: root at ynotdemo.com
> Cc: Fplist (E-mail)
> Subject: RE: import fails to get a comma
>
>
> Tony,
> All you need to do is this:
>
>      if:
>    then: filename = xlate(filename,",",":")
>
> Just before you use it in the IMPORT command.
>
> John Esak
>
> P.S. - Note: the variable "filename" represents a declared variable that
> holds your original filename with the comma in it. This could also be a
> regular 2 character variable like AA.
>
>
>
>
> > -----Original Message-----
> > From: filepro-list-bounces at lists.celestial.com
> > [mailto:filepro-list-bounces at lists.celestial.com]On Behalf Of
> > root at ynotdemo.com
> > Sent: Sunday, October 02, 2005 7:38 PM
> > To: filepro-list at lists.celestial.com; tony at ynotsoftware.com
> > Subject: import fails to get a comma
> >
> >
> > hi experts,
> > i am importing in a list of files names (from ls -Q) and then
> > using filepro
> > import for each file name  obtained to read in the data & post to
> > filepro files.
> >   it's working great & the result is parsing emails for automatic
> > followup.
> >
> > The problem i have is the name list, see below, includes a comma
> > and filepro import ignores the comma. I have a typical tony 100
> > line work around, but i am hoping someone has a suggestion as to
> > a better way to obtain the file names with the comma.
> >
> > any help is appreciated.
> > ( even a way to globally rename the files without the comma)
> > old tony freehauf
> > (the system is filepro 5.0 linux)
> >
> > sample of file names below:
> > "1128123527.3782831321.gmcmotors:2,T"
> > "1128123709.0554931446.gmcmotors:2,T"
> > "1128125574.0300732003.gmcmotors:2,T"
> > "1128126100.7334532283.gmcmotors:2,T"
> > "1128126130.1069832440.gmcmotors:2,S"
> > "1128126136.5080332462.gmcmotors:2,T"
> > "1128126256.0462432496.gmcmotors:2,S"
> > "1128126374.1713732569.gmcmotors:2,RST"
> > "1128126510.8973932698.gmcmotors:2,T"
> > "1128126657.9106190467.gmcmotors:2,S"
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
>
> _______________________________________________
> 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