Export Field Seperator

[Richard D. Williams]

On 8/14/2012 12:15 PM, Brian K. White wrote:
> On 8/14/2012 3:31 AM, Brian K. White wrote:
>> On 8/13/2012 2:33 PM, Nancy Palmquist wrote:
>>> Scott,
>>> While I don't understand the need for 2 pipes between fields, it seems
>>> to me the easiest way would be to write every other field to the file.
>>>
>>> export ascii out=myfilename r=\n f=|
>>> out(1)=xx
>>> out(3)=xy
>>> out(5)=zz
>>>
>>> would make a file that has:  xx||xy||zz
>> That would just produce
>> xx|xy|xz
> *headsmack*
>
> Sorry Nancy!
> I completely missed the 1, 3, 5
>
> So slick!
>
When I initially replied to this post I resisted what has since been stated.

Why?

If this file will be used with Excel or anything other than some custom 
interface, just use "WORD".

export WORD out = myfilename

As Ken stated, this export technique will place quotes around the values.
Therefore protecting any data that would contain a comma.

Richard

P.S. Filepro is always much easier when you do not try to swim up stream.