Export Field Seperator

[Kenneth Brody]

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.

As already noted, filePro only allows a single separator.  However, I see no 
reason why Nancy's suggestion of "skipping" fields in the export to get 
filePro to place two separators wouldn't work.  (Assuming, of course, that 
you want the same character twice, and not two different characters.)

You also noted that Excel, which is apparently your file's destination, 
doesn't allow you to specify two character, either, so it sounds as if the 
point is moot.

Does Excel allow you to specify control characters as a separator?  If so, 
why not try something like "f=3", which will put a control-C as the separator.

=====

Ian Wood said:

> out(1)=1{chr("124"); out(2)=2{chr("124")....

and in another post:

> delim=chr("94")

Why the obfuscation?  Why not just:

     out(1) = 1{"|" ; out(2) = 2{"|" ...

or

     delim = "^"


-- 
Kenneth Brody