Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove carriage returns in memos
Message
From
12/06/2001 08:27:49
 
 
To
12/06/2001 08:08:01
Denis Filer
University of Oxford
United Kingdom
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00518280
Message ID:
00518293
Views:
12
Denis,
Bret gave you a solution. If you have more than 1 trailing carriage return, you could do something like this:
lcMemo = RTRIM(< MemoField >)

DO WHILE RIGHT(lcMemo,1)=CHR(13)
	lcMemo=LEFT(lcMemo, LEN(lcMemo)-1)
ENDDO
REPLACE < MemoField > WITH lcMemo
>Is there an obvious way to remove trailing carriage returns at the end of memo field - nasty in reports that display alltrimed memos. I have tried a substr() command replacing chr(13) with "" but this not working. Thank you in advance if someone knows the best way.
Daniel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform