Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Chrtran() applied selectively
Message
From
07/06/2016 02:58:33
 
 
To
03/06/2016 19:14:31
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01636985
Message ID:
01637042
Views:
122
>I am searching for the most expedient way to change a character in a specific area of a string.
>
>mstr='1st-title: ANAME-HER : 3520931 place[21-22]'
>in this string the hyphen between 21 and 22 should be a dot.
>if I applied chrtran() I would end up changing all the hyphens which I do not want to do.
>
>right now all I've been able to accomplish is to locate the error in a portion of the string, but putting it back together is starting to get a bit unwieldy.
>Is there a simpler more direct route of directing the chrtran() to the area beyond '['
>
>thanks
>k

Hi Karen:

Another solution here :D

Considering that there are always three "parts" separated by ":" symbol, this will do it in pure VFP:
mstr='1st-title: ANAME-HER : 3520931 place[21-22]'
? GETWORDNUM(mstr, 1, ':') + ':' + GETWORDNUM(mstr, 2, ':') + ':' + CHRTRAN(GETWORDNUM(mstr, 3, ':'), '-', '.')
Fernando D. Bozzo
Madrid / Spain
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform