Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replacing Text
Message
From
24/02/2014 04:21:07
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01595033
Message ID:
01595036
Views:
48
Sir These values may Change 20.699 184.238 MV. So I need to change the text Inside () only and the rest should be as per the original


>Have you tried
>
>
>replace all;
>   detail with  "20.699 184.238 MV (XXXXXXXXXX)SH "
>   FOR ALLTRIM(DETAIL)='20.699 184.238 MV (. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .)SH'  
>
>
>
>>I need to replace
>>
>>'20.699 184.238 MV (. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .)SH'
>>
>>with
>>
>>20.699 184.238 MV (XXXXXXXXXX)SH inside a Cursor
>>
>>Using LOCATE FOR ALLTRIM(DETAIL)='20.699 184.238 MV (. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .)SH'
>>
>>I can reach the record, now I need to Replace Detail with 20.699 184.238 MV (XXXXXXXXXX)SH
>>
>>What is the easiest Way to do it.
>>
>
>
>>
Harsh
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform