How to get particular number of text/characters from a paragraph?
SQAFORUMS MEMBER DETAILS ARE:
I have to retrieve the value after color (":") and upto 4 characters.
The retrieved value should be ANON only (consider that there is no space between colon and ANONYMOUS)
Thanks and regards,
use INSTR to find the position of ":" in the string and then use this position in MID
pos = instr(string, ":")
x = mid(string, pos+1, 4)
WEll if your question is that you want to get the four characters after the colon
then do the following I hope this will solve you problem
String1 = "SQAFORUMS MEMBER DETAILS ARE:
splittedstring = split(string1,":")
Requiredstring = left(splittedstring(1),4)
I am sure this was what you required