Well,
The quotes did not come out very well in my post -- I put a single quote, a double quote and a single quote to get the quote.
Hey, how did you guys get the white background on your posts?
Thanks for everyones help.
>Hello,
>
>One final refinement -- I added "quotes" around the fields and trimmed the fields:
>
>
>
>SET TEXTMERGE TO yourfile.txt
>SET TEXTMERGE ON
>SCAN ALL
> \\<<'"'+ALLT(field1)+'"'>>,<<'"'+ALLT(field2)+'"'>>,<<'"'+ALLT(memofield)+'"'>>,<<'"'+ALLT(field4)+'"'>>
> \
>ENDSCAN
>SET TEXTMERGE OFF
>SET TEXTMERGE TO
>
>
>
>>Hi David,
>>
>>Thank-you.
>>
>>>Terry,
>>>
>>>One minor correction to Fred's code to avoid an empty first line in the file:
>>>
>>>
SET TEXTMERGE TO yourfile.txt
>>>SET TEXTMERGE ON
>>>SCAN ALL
>>> \\<<field1>>,<<field2>>,<<memofield>>,<<field4>>
>>> \
>>>ENDSCAN
>>>SET TEXTMERGE OFF
>>>SET TEXTMERGE TO
>>>
>>>You can also make a generic function using afields to process any cursor/table that you throw at it.
>>>
>>>>>You'll have to build a comma delimited file yourself using SET TEXTMERGE.
>>>>>
>>>>>
SET TEXTMERGE TO yourfile.txt
>>>>>SET TEXTMERGE ON
>>>>>SCAN ALL
>>>>> \<<field1>>,<<field2>>,<<memofield>>,<<field4>>
>>>>>ENDSCAN
>>>>>SET TEXTMERGE OFF
>>>>>SET TEXTMERGE TO
Thanks,
TFISHER