Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, so I was wondering if anyone could provide an idea of how to implement the following in qlikview?
IF brackets in value string, then create a subfield of string within the brackets AS newValue
ELSE create a subfield of 1st 4 characters in value string AS newValue
Thanks, Ben
May be like this:
If(Index(string, '(') and Index(string, ')'), TextBetween(String, '(', ')'), Left(String, 4)) as NewValue
Update: Missed a parenthesis
May be like this:
If(Index(string, '(') and Index(string, ')'), TextBetween(String, '(', ')'), Left(String, 4)) as NewValue
Update: Missed a parenthesis
Can you post some sample data and expected output if possible??