Trimming issue

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

Developer

Text Mining

Accepted answers

Qiu

@Harsha_01
We can do with Reg Replace.

1021-Harsha_01.yxmd

MarqueeCrew

@Harsha_01

Please use this string function:

trim([text],")")

cheers

mark

All comments

Qiu

@Harsha_01
We can do with Reg Replace.

1021-Harsha_01.yxmd

MarqueeCrew

@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.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280