By using regular expression
Instead of digit, If only string is required the use regular expression as [^\d]
By using mid function
-x-
2. Extract certain string from a string
using regular expression also this fleet can be achieved, but it will be very complex.
3. Extract all matching string from main string
prints delhi 4 times.
to get the count, use colmatch.value here value = 4.
Another way to handle the same
No comments:
Post a Comment