Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remove carriage returns in memos
Message
 
 
À
12/06/2001 22:12:06
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00518280
Message ID:
00518702
Vues:
20
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform