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:20:58
 
 
To
20/08/1999 23:17:52
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00256063
Message ID:
00256192
Views:
28
I want to clarify a little bit my previous message: whenever possible, try to use the same strings of the same length for CHRTRAN() and STRTRAN(). It's much faster because, internally, VFP doesn't have to copy any strings. It only replaces chars in existing strings. Whenever a char must be removed or added, VFP has to copy the string, so, memory allocations/deallocations, etc, etc.

Vlad

>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
Previous
Reply
Map
View

Click here to load this message in the networking platform