Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Retrieve value from comma delimited by priority
Message
 
 
To
24/11/2009 08:21:00
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01436294
Message ID:
01436298
Views:
98
This message has been marked as the solution to the initial question of the thread.
You can use ALINES() in combination with ASORT()
lcStr = "UG-1542,UB-8473,UY-9115,UB-2121"
= ALINES(laList, lcStr,1, ",")
= ASORT(laList, -1,-1,0)
? laList[1]
>
>
>I have comma delimited string variable and I have to retrieve only one value by ABC Sequential Order priority (each value start with U, so I have to see ignore the U).
>
>For example:
>
>1. UR-6542,UG-4586,UA-5585,UF-8522 = UA-5585
>2. UG-1542,UB-8473,UY-9115,UT-7741 = UB-8473
>3. UG-1542,UB-8473,UY-9115,UB-2121 = UB-2121 (I have two B so order by digits).
>
>Tnx
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform