Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting a memory variable with character and numeric
Message
From
24/12/2014 00:44:35
 
 
To
23/12/2014 04:18:38
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01612566
Message ID:
01612691
Views:
56
>>>Is there more concise way of converting a memory variable from A15 to A14
>>>Here's what i have - seems a tad convoluted to me. Maybe i should just be grateful i got it on one line.
>>>
>>>n1="A15"
>>>n2="A"+LTRIM(STR(VAL(SUBSTR(n1,2,2))-1))  &&& gives me n2=A14
>>>
>>>tnx
>>>k
>>Don't know if you need this or not..........taking Borislav's solution and making it generic so that it isn't for just two characters

>>n2 = "A" + TRANSFORM(VAL(SUBSTR(n1,2)))
>
>And this keeps working below 10. The trouble with transform() without picture parameter sometimes gives you unexpected result - with decimals etc. If two-digit result is desirable, then I'd rather have
>
>n2 = "A" + TRANSFORM(VAL(SUBSTR(n1,2)), "@L 99")

I don't see how I can change n2 to A14 with this solution.
Borislav's solution enabled me to change the numeric portion of the variable.
k
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform