Substring

[Anonymous]

Hi All,

How to search a substring is present or not in a given string besides using wildmatch function.

[tamilarasu]

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)

[tresesco]

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.

[Anonymous]

Thanks buddy

[Anonymous]

thank you

[avinashelite]

check this link too

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/StringFunctions/SubStr...

[antoniotiman]

Or

Index(String1,String2,)

e.g.

Index('abcdefg','cdefg')   -> 3

see

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/StringFunctions/Index....

[oknotsen]

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 .