Export Field Seperator
Brian K. White
brian at aljex.com
Wed Aug 15 11:18:36 PDT 2012
On 8/15/2012 11:44 AM, Richard D. Williams wrote:
> 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.
As BKW stated. Ken must have stated it 5 zillion other times, allow me
this one. ;)
>
> Richard
>
> P.S. Filepro is always much easier when you do not try to swim up stream.
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
More information about the Filepro-list
mailing list