Truncate characters and preceding zero

[#1]

Hi,

Am new to QlikView and have the below requirement and seeking help from gurus.

I have a Field as per below and need help on desired output. Please advice.

Field is a combination of Name & ID -> ID starts with '(' and ends with ')' I need to truncate the first 2 chars and if there is a preceding zero that needs to be removed as well.

Field - XXX YYY ZZZ (AA0123054)

Output - 123054

Field - A BB CCCC (XX0985050)

Output - 985050

Thanks,

Rai

[sunny_talwar · Accepted solution]

May be this:

KeepChar(TextBetween(FieldName, '(', ')'), '0123456789) * 1 as Output

[#3]

Thank you Sunny.