suppose im having a string wipro123xyz i need to get the value 123 only from th

suppose im having a string wipro123xyz i need to get the
value 123 only from the string today 123 will be in the
middle from tommorow it will be changing to front or back
how to get the no if it changes continously?

Question Posted / mohammad

2 Answers
6351 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

suppose im having a string wipro123xyz i need to get the value 123 only from the string today 123 w..

Answer / sailaja

txt="123wiproxyz"
mypos=instr (1,txt,"123")
msgbox mypos

k=mid ( txt,mypos,3)
msgbox k

Is This Answer Correct ?

7 Yes

1 No

suppose im having a string wipro123xyz i need to get the value 123 only from the string today 123 w..

Answer / aiswaryan

Function RegExpTest(patrn, strng)
Dim regEx, Match, Matches ' Create variable.
Set regEx = New RegExp ' Create a regular expression.
regEx.Pattern = patrn ' Set pattern.
regEx.Global = True ' Set global applicability.
Set Matches = regEx.Execute(strng) ' Execute search.
For Each Match in Matches ' Iterate Matches collection.
RetStr = RetStr & Match.Value' & vbCRLF
Next
RegExpTest = RetStr
End Function
a=(RegExpTest("[0-9]", "1234_Today"))
msgbox(a)
"a" contains the numbers in the given string from 1st to
last position.
If anybody know smarter way to achieve above task, please
post the answer.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer