Alteryx formula help

Question

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 Answer

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 Answer

hi @SCK

a perfect usecase for the TrimRight function:

hope this helps!