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.

Remove ";" from end of email string

wonka1234
10 - Fireball

Hi,

 

How can I remove ";" at the end of an email string

 

ie

 

Louis.Stevens@hotmail.com;  becomes Louis.Stevens@hotmail.com

LouisStevens@hotmail.com;Ren.Stevents@hotmail.com;  becomes  LouisStevens@hotmail.com;Ren.Stevents@hotmail.com

 

 

Essentially removing ; at the end of each string only.

10 REPLIES 10
Felipe_Ribeir0
16 - Nebula

Hi @wonka1234 

 

You can use the trimright([Email], ";") function

 

Felipe_Ribeir0_0-1673033114359.png

 

ShankerV
17 - Castor

Hi @wonka1234 

 

There are many ways to achieve the solution.

One way is 

 

Solution 1:

 

ShankerV_0-1673094012888.png

 

(.+);$

 

ShankerV_1-1673094055044.png

 

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

 

Many thanks

Shanker V

 

 

ShankerV
17 - Castor

Hi @wonka1234 

 

Solution 2:

ShankerV_0-1673094553310.png

 

ShankerV_1-1673094565185.png

 

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

 

Many thanks

Shanker V

 

 

ShankerV
17 - Castor

Hi @wonka1234 

 

Solution 3: 

 

ShankerV_0-1673094738574.png

 

ShankerV_1-1673094765050.png

 

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

 

Many thanks

Shanker V

 

AfifHazmie
5 - Atom

Thank you for the solutions. I had a similar case too

Adamyde
6 - Meteoroid

👍

Dr_Hammann_619
6 - Meteoroid

Good solution.

Mincridible
6 - Meteoroid

Nice trick

grazitti_sapna
17 - Castor

@wonka1234 , You can use the trim function whenever you want to Trim function when you want to trim out any character.

 

In this case TrimRight can be used as below: TrimRight([Field],";")

In case you want to Trim from Left you can use TrimLeft and Trim in case of trimming from left and right both sides.

Sapna Gupta
Labels