Instring function using vbscript
how to extract the comma till the last and display only the last value suppose if i insert 100000 rows it should show 100000 not like from 1,2,3, till 100000 it should extract till last comma please help me
Software/Hardware used:
Software/Hardware used:
ASKED:
June 15, 2012 2:30 PM
UPDATED:
June 15, 2012 3:38 PM
Answer Wiki:
You could use a combination of the InStrRev, Len and Right functions.
Try something like this:
<pre>test = "1,2,3,4,5,100,300,1995"
msgbox right(test,len(test)-InstrRev(test,","))</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
