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

[johnyli168 · Accepted solution]

Find the solution here, in Alteryx you can be a bit creative about how you achieve this outcome.

I have also attached the workflow!

[DataNath · Accepted solution]

When you say R Trim, do you mean TrimRight() @Harsha_01? Can’t see why that wouldn’t work here and will only remove the bracket from the end of the string.

[Emmanuel_G]

@Harsha_01 

Find in attachement two ways of doing that with both functions you mentionned.

Let me know if this answer is ok for you or not.