11-13-2013 03:37 PM
Solved! Go to Solution.
11-14-2013 01:03 AM
Hi LVdummies,
Please try this:
dim sText, sTextArray, iLoop sText = "Apple=2,bananas=4,monkey=3,blue=8" sTextArray = split(sText, ",") for iLoop = 0 to uBound(sTextArray) msgbox sTextArray(iLoop) next
Greetings
Walter
11-14-2013 01:33 AM
Hello,
If i want to pick out for example" monkey" from the string.
How will the code look like then ?
11-14-2013 01:41 AM
dim sText, sTextArray, iLoop sText = "Apple=2,bananas=4,monkey=3,blue=8" sTextArray = split(sText, ",") for iLoop = 0 to uBound(sTextArray) msgbox sTextArray(iLoop) msgbox left(sTextArray(iLoop), inStr(sTextArray(iLoop), "=") - 1) next
Greetings
Walter