Qlik Scripting Issue

[#1]

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

[sunny_talwar · Accepted solution]

May be like this:

If(Index(string, '(') and Index(string, ')'), TextBetween(String, '(', ')'), Left(String, 4)) as NewValue

Update: Missed a parenthesis

[vishsaggi]

Can you post some sample data and expected output if possible??