Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove carriage returns in memos
Message
 
 
To
12/06/2001 22:12:06
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00518280
Message ID:
00518702
Views:
18
>>ROFL.
>>Amazing what users sometimes do :)
>>
>>>I encountered a problem similar to this, one of my users had managed to insert 1000's of CR's on the end of a memo field
>>>
>>>They went to lunch with a book resting on the keyboard
>>>But at the end of the CR's they had carried on typing into the memo field and then hit save.
>
>
>lcMemo={your memo field}
>lcMemo=strtran(lcMemo, chr(13)+chr(13), '  ')
>do while '  '$lcMemo
>    lcMemo=strtran(lcMemo, '  ', ' ')
>enddo
>This should save the regular single CRs and replace double or multiple CRs with a single space. Maybe not the most elegant way out, but should at least cut your problem down to manageable size.

What about FoxTools Reduce? Are you still in FoxTools club? :)
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform