Export Field Seperator

[Ian Wood]

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
> > > 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/feb7d6f4/attachment.html