Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How to search a substring is present or not in a given string besides using wildmatch function.
Hi Satej,
You can use Like function as an alternate.
If( Field Like '*Substring*',1,0)
You can also use Index function.
If(Index( Field, 'Substring' ),1,0)
Or,
Substringcount() , like:
substringcount( text , substring)
Returns the number of times the string substring appears within the string text. The result is an integer. If there is no match, 0 is returned
Example:
substringcount ( 'abcdefgcdxyz', 'cd' ) returns 2
I.e. - if the function returns value>0, then the substring is present else not.
Thanks buddy
thank you
Or
Index(String1,String2,
e.g.
Index('abcdefg','cdefg') -> 3
see
If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).
If not, please make clear what part of this topic you still need help with .