Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting Tabs in Memo Fields to spaces
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00017909
Message ID:
00017910
Views:
66
>I working with a web based VFP 3.0 application and need a way to get rid of the tabs people are entering from time to time whle placing info into a large memo field.
>
>I pull the Memo field into a RTF document for downloading, and the tabs throw the RTF code all out of whack. Any one have an easy, or not so easy suggestion on how to go about flattening the Tabs?
>
>Much Thanks
>
>-Preston
Hi preston, you can use STRTRAN() on memo fields, I have done it
before and it works fine, it will be something like :

REPLACE my_memo WITH STRTRAN(my_memo,CHR(10),SPACE(1))

this will replace every tab with a single space,

P.S. I don't remember right now if 'TAB' is CHR(10), check that.
But let me know if it is not and I'll check it in my notes.

=THIS.good_luck()
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform