Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Chrtran and carriage returns
Message
From
11/03/2002 16:27:36
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00631191
Message ID:
00631198
Views:
64
Carmel,
This should work. You're probably confused because you don't see the result on the screen with the ? command. Try the following:
CREATE CURSOR test (mTest M)
INSERT INTO Test VALUES("1|2|3|4")
lcCrLf = CHR(13)+CHR(10)
REPLACE mTest WITH CHRTRAN(mTest, "|", lcCrLf)
HTH
>Hi,
>
>I am trying to remove the | symbol from an address and insert
>a carriage return instead to make the address 2 lines instead of 1.
>The carriage return is not getting inserted.
>Instead line 1 gets overwritten with line 2
>This is my code
>
>lf=+chr(13)+chr(10)
>? chrtran(ad1street,"|",+lf)
>
>where ad1street is a memo field.
>
>Thanks in advance
>Carmel
Daniel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform