Discussion Board for collaboration regarding Qlik DataMarket.
I am trying to extract specific address information from an address field where the field begins with a number.
Row 1: 123 Address1
Row 2: Address2
I would like it to return the following
Go to Solution.
If( Isnum(Subfield(FieldName,' ',1)), Mid( FieldName, Index( FieldName,' ')+1, Len(FieldName) ), FieldName)
May be like this:
SubField(FieldName, ' ', 2)
Subfield(FieldName, ' ', SubstringCount(FieldName,' ')+1)
U can use the right() function
For additional clarity.
I need all the characters after the numbers, there could be more than 1 space and various field lengths.
Maybe something like
=Mid( FieldName, Index( FieldName,' ')+1, Len(FieldName) )
Ok, this won't return second row again...
SubField(FieldName, ' ', -1)
Fantastic, this one works perfectly. Thanks swuehl