Export Field Seperator

[Scott Walker]

Ian,
 
Yup I am trying to avoid a problem just in case the data ever contains the
"|" (which it NEVER has, but if they can type it...).
 
I've been fiddling with it.tried to use tab as field separator (figured they
could never be a tab character in fp data..is that correct?).  Anyhow could
never get past the syntax checker.  
 
Then according to Stewart Werners manual, you can use multiple characters at
the -f flag in the export command.could not get that to work.
 
But as I said in  a subsequent post,  Excel does not let you specify (2)
characters as the field separator so I guess I will just stick with "|" for
now .
 
Regards,
 
Scott
 
 
From: Ian Wood [mailto:iwood51 at gmail.com] 
Sent: Monday, August 13, 2012 11:45 AM
To: Scott Walker
Cc: filepro-list at lists.celestial.com
Subject: Re: Export Field Seperator
 
Scott, is the need for a double pipe because your data may contain a pipe?
If so, you can export all as one field and use a more obscure character,
like a caret ^

declare local delim(1,*) 

delim=chr("94")

export ascii out = (filename) r=\n f=\t

out(1)=field(1){delim{field(2){delim{field(3){delim{field(4)............

write out

This will make filePro see it as one exported field per record but you tell
your import program, Excel in your case to use the ^ as the delimiter.

Ian
On Mon, Aug 13, 2012 at 11:28 AM, Scott Walker
<ScottWalker at ramsystemscorp.com> wrote:
Brian,

Thanks.  You know what.  I just tested excel and it does not let you specify
(2) characters as a field separator so I guess I'm stuck using one.

Regards,

Scott


> -----Original Message-----
> From: filepro-list-
> bounces+scottwalker=ramsystemscorp.com at lists.celestial.com
> [mailto:filepro-list-
> bounces+scottwalker=ramsystemscorp.com at lists.celestial.com] On Behalf Of
> Brian K. White
> Sent: Monday, August 13, 2012 11:20 AM
> To: filepro-list at lists.celestial.com
> Subject: Re: Export Field Seperator
>
> This should work:
>
> export ascii alias = name r=\n o=| c=|
>
> But I haven't tried it.
>
> --
> bkw
>
>
> On 8/12/2012 6:35 PM, Scott Walker wrote:
> > I'm doing an export ascii.
> >
> > Is there an easy way to use two characters as the field separator.
> >
> > Specifically I'm trying to use two pipe symbols as the field separator.
> >
> > Regards,
> >
> > Scott
> >
> >
> > Scott Walker
> > RAM Systems Corp
> > (704) 896-6549 <tel:%28704%29%20896-6549> 
> > Scott.Walker at RAMSystemsCorp.com
> >
> > www.RAMSystemsCorp.com
> >
> >
> >
> >
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > Subscribe/Unsubscribe/Subscription Changes
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> >
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list


_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20120813/c16c52cd/attachment.html