Remove ";" from end of email string

[wonka1234]

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.

[Felipe_Ribeir0]

Hi @wonka1234 

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

[ShankerV]

Hi @wonka1234 

There are many ways to achieve the solution.

One way is 

Solution 1:

(.+);$

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]

Hi @wonka1234 

Solution 2:

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]

Hi @wonka1234 

Solution 3: 

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]

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

[Adamyde]

👍

[Dr_Hammann_619]

Good solution.

[Mincridible]

Nice trick

[grazitti_sapna]

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