Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting rid of carriage returns in memo fields
Message
From
20/08/1999 23:17:52
 
 
To
20/08/1999 21:26:10
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00256063
Message ID:
00256190
Views:
28
You're right. What I don't understand is the "I don't know for sure"... because I'm sure you've tested it! :))

Here's an alternative solution (if it is acceptable):

REPLACE Table1.Memo WITH CHRTRAN(table1.memo,CHR(13)+CHR(10),' ')

The trick is to replace (not remove) the chr(13) and chr(10) with spaces. This is MUUUUUUCH faster. Sometimes it makes THE difference.

Vlad

>>REPLACE Table1.Memo WITH STRTRAN(STRTRAN(table1.memo,CHR(13),''),CHR(10),'')
>
>I don't know for sure, thats why I'm asking you, how 'bout:
>
>REPLACE Table1.Memo WITH CHRTRAN(table1.memo,CHR(13)+CHR(10),'')
>?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform