topic Re: Identify character in a string in QlikView

Identify character in a string

qvqfqlik — Wed, 28 Dec 2016 20:50:24 GMT

I am trying to to identify a character in a string

eg: SXOWERF, STOFGHJK

for the example strings, I am trying to identify if the 2nd character in them is/is not 'X' or 'T'.

Please help me with this

sunny_talwar — Wed, 28 Dec 2016 20:52:09 GMT

May be like this:

If(Match(Mid(FieldName, 2, 1), 'X', 'T'), 'Matched X or T', 'Did not Match X or T')

sunny_talwar — Wed, 28 Dec 2016 20:53:27 GMT

Here is a screenshot

You can replace True and False statements based on your requirement.

Best,

Sunny

qvqfqlik — Wed, 28 Dec 2016 21:00:03 GMT

I am trying to exclude all such strings with 2nd charater 'X','T' from the Field values. How to achieve this?

sunny_talwar — Wed, 28 Dec 2016 21:01:42 GMT

In the script, you can do this:

LOAD *

FROM ...

WHERE Match(Mid(FieldName, 2, 1), 'X', 'T') = 0;

saimahasan — Mon, 02 Jan 2017 09:28:08 GMT

You can use

if(Match(Mid(FieldName, 2, 1), 'X', 'T'),null(),FieldName)