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 21:23:20
Ed Rauh
Trumbull, Connecticut, United States
 
 
To
20/08/1999 16:29:14
Brian Bolton
KEANE
Albany, New York, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Getting rid of carriage returns in memo fields
Miscellaneous
Thread ID:
00256063
Message ID:
00256156
Views:
27
>does anyone know how to get rid of carriage returns in a memo field?
>This doesnt work.
>lcmemoval=table1.memofld
>lcnewval=strtran(lcmemoval,Chr(13))
>

You need to replace both the CHR(13) and CHR(10) characters:

REPLACE Table1.Memo WITH STRTRAN(STRTRAN(table1.memo,CHR(13),''),CHR(10),'')
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater

NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform