How to remove word mentioned in a bracket from field in Qlikview Load Script

[vikasshana]

Hi,

I've below data in my app.

ID

123 AND(Test)

426 AND1

789 AND2(Test1)

I'm looking for a load scrip to removed characters in brackets, would like to see output like below.

ID

123 AND

426 AND1

789 AND2

Regards,

V

@PrashantSangle , @tresesco , @sunny_talwar , @marcus_sommer 

[PrashantSangle · Accepted solution]

Hi,

try below code,

Load
ID,
Trim(Replace(ID,mid(ID,Index(ID,'('),Index(ID,')')),'')) as ID1
Inline [
ID
123 AND(Test)
426 AND1
789 AND2(Test1)
];

Regards,

Prashant Sangle

[vikasshana]

Perfect, thanks @PrashantSangle  it is working as expected 👍

[PrashantSangle]

If it works for you then like the solution also