Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy to delimited
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00795350
Message ID:
00795584
Views:
30
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform