Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trimming blanks on a memo field
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00625134
Message ID:
00625189
Views:
13
Hello Vlad and Eric,

Vlad suggested:
>Does following command works for you?
>alltrim(strtran(MyMemoField,chr(13),''))
>You can use also
>alltrim(strtran(MyMemoField,chr(13)+chr(10),''))
>in case 2 characters used (CR and LF) as a new line.


I think that either of these will remove intentional new lines embedded in the memo field. My take on Eric's request is that excess trailing CR / LF / spaces need to be trimmed off. I've seen code that does this, but sorry to say don't have it handy right now.
Randy Bosma
VFP - Because life is too short to code in something else...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform