topic Re: Substring in QlikView

Substring

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

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

Re: Substring

tamilarasu — Wed, 09 Nov 2016 06:10:39 GMT

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)

Re: Substring

tresB — Wed, 09 Nov 2016 06:15:13 GMT

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.

Re: Substring

Anonymous — Wed, 09 Nov 2016 06:26:10 GMT

Thanks buddy

Re: Substring

Anonymous — Wed, 09 Nov 2016 06:26:33 GMT

thank you

Re: Substring

avinashelite — Wed, 09 Nov 2016 07:25:19 GMT

check this link too

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

Re: Substring

antoniotiman — Wed, 09 Nov 2016 08:18:21 GMT

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.htm

Re: Substring

oknotsen — Wed, 09 Nov 2016 10:50:50 GMT

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 .