Alteryx formula help

[SCK]

Hi all,

I need help to eliminate the sign '-' only from the end of the string and not between. I have the following dataset.

Input

01-1000-2000-

02-200-3000

01-10003-689-

Desired output

01-1000-2000

02-200-3000

01-10003-689

Please help.

[atcodedog05 · Accepted solution]

Hi @SCK 

The formula you need is

TrimRight([Field1],"-")

Output:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[TheOC · Accepted solution]

hi @SCK 

a perfect usecase for the TrimRight function:

hope this helps!

[SCK]

Both solutions worked. Thank you so much.

[atcodedog05]

Happy to help 🙂 @SCK 

Cheers and Happy Analyzing 😀