Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Trimming issue

Harsha_01
6 - Meteoroid

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

5 REPLIES 5
Qiu
20 - Arcturus
20 - Arcturus

@Harsha_01 
We can do with Reg Replace.

1021-Harsha_01.PNG

MarqueeCrew
20 - Arcturus
20 - Arcturus

@Harsha_01 

 

Please use this string function:

 

trim([text],")")

 

 cheers

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Harsha_01
6 - Meteoroid

Hi Qiu,

 

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

Harsha_01
6 - Meteoroid

Hi Mark,

 

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

Aguisande
15 - Aurora
15 - Aurora

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

Labels