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
Solved! Go to 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.
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.