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.
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
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
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
Thank you for the solutions. I had a similar case too
👍
Good solution.
Nice trick
@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.