Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Perfect, thanks @PrashantSangle it is working as expected 👍
If it works for you then like the solution also