Trimming issue

[Harsha_01]

Hello Everyone,

I have facing Issue with trim. I want to remove only the bracket in the end. Please see the Following Text. Any help would be very help to me.... Thanks

I have used Pad right, R trim, Replace but no Luck.

Source text :

BANK OF India, NA)

BAO DO Russia S.D.)

National BANK, NA)

Required result :

BANK OF India, NA

BAO DO Russia S.D.

National BANK, NA

Thanks in advance,

Sriharsha

[Qiu · Accepted solution]

@Harsha_01 
We can do with Reg Replace.

[MarqueeCrew · Accepted solution]

@Harsha_01 

Please use this string function:

trim([text],")")

 cheers

 mark

[Harsha_01]

Hi Qiu,

Thanks for the Help your solutions is working like a star, Thanks alot

[Harsha_01]

Hi Mark,

Thanks for the Help your solutions is working like a Charme, Thanks alot

[Aguisande]

Let me add that Regex adds a little overhead in workflow processing. If you can avoid using it, avoid it.