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 ^<br><br>declare local delim(1,*) <br><br>delim=chr("94")<br>
<br>export ascii out = (filename) r=\n f=\t<br><br>out(1)=field(1){delim{field(2){delim{field(3){delim{field(4)............<br><br>write out<br><br>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.<br>
<br>Ian<br><br><div class="gmail_quote">On Mon, Aug 13, 2012 at 11:28 AM, Scott Walker <span dir="ltr"><<a href="mailto:ScottWalker@ramsystemscorp.com" target="_blank">ScottWalker@ramsystemscorp.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Brian,<br>
<br>
Thanks. You know what. I just tested excel and it does not let you specify<br>
(2) characters as a field separator so I guess I'm stuck using one.<br>
<br>
Regards,<br>
<br>
Scott<br>
<div><br>
<br>
> -----Original Message-----<br>
> From: filepro-list-<br>
> bounces+scottwalker=<a href="mailto:ramsystemscorp.com@lists.celestial.com" target="_blank">ramsystemscorp.com@lists.celestial.com</a><br>
> [mailto:<a href="mailto:filepro-list-" target="_blank">filepro-list-</a><br>
> bounces+scottwalker=<a href="mailto:ramsystemscorp.com@lists.celestial.com" target="_blank">ramsystemscorp.com@lists.celestial.com</a>] On Behalf Of<br>
> Brian K. White<br>
> Sent: Monday, August 13, 2012 11:20 AM<br>
> To: <a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.celestial.com</a><br>
> Subject: Re: Export Field Seperator<br>
><br>
</div><div><div>> This should work:<br>
><br>
> export ascii alias = name r=\n o=| c=|<br>
><br>
> But I haven't tried it.<br>
><br>
> --<br>
> bkw<br>
><br>
><br>
> On 8/12/2012 6:35 PM, Scott Walker wrote:<br>
> > I'm doing an export ascii.<br>
> ><br>
> > Is there an easy way to use two characters as the field separator.<br>
> ><br>
> > Specifically I'm trying to use two pipe symbols as the field separator.<br>
> ><br>
> > Regards,<br>
> ><br>
> > Scott<br>
> ><br>
> ><br>
> > Scott Walker<br>
> > RAM Systems Corp<br>
> > <a href="tel:%28704%29%20896-6549" value="+17048966549" target="_blank">(704) 896-6549</a><br>
> > Scott.Walker@RAMSystemsCorp.com<br>
> ><br>
> > <a href="http://www.RAMSystemsCorp.com" target="_blank">www.RAMSystemsCorp.com</a><br>
> ><br>
> ><br>
> ><br>
> ><br>
> > _______________________________________________<br>
> > Filepro-list mailing list<br>
> > <a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.celestial.com</a><br>
> > Subscribe/Unsubscribe/Subscription Changes<br>
> > <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
> ><br>
><br>
> _______________________________________________<br>
> Filepro-list mailing list<br>
> <a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.celestial.com</a><br>
> Subscribe/Unsubscribe/Subscription Changes<br>
> <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
<br>
<br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</div></div></blockquote></div><br>