Discussion board where members can get started with Qlik Sense.
Hi I have a column with strings in it.
The format of the strings are following
1.01.01.02 CAPITAL LETTERS
1.01.01.02-01 First letter capital the rest is lower case
1.01.01.03 CAPITAL LETTERS
1.01.01.02-01 The first letter will be capital again, sometimes there might be a capital within aswell
1.01.02.01 CAPITAL LETTERS SOMETIMES HAS-A DASH
What I want to do is to collect all strings that has capital letters in a new field, same for the others
One way to filter would be that if #-# would exist the save to new field
This if statement is close but won't do because it will map on HAS-A DASH aswell:
If(WildMatch(Field, '*-*') = 1, [Field]) AS [NewField],
I tried this aswell but it doesn't work
If(WildMatch(Field, '*#-#*') = 1, [Field]) AS [NewField],
Is there a way to catch number-number but not letter-letter?
Go to Solution.
Are you looking for this?
May be this:
If(Len(Trim(KeepChar(Field, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'))) > 1, Field) as Field1,
If(Len(Trim(KeepChar(Field, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'))) < 2, Field) as Field2;
LOAD * Inline [
Hi Sunny T,
I got the same result doing it like this:
But thanks alot for your help!