Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLUCIONADO

Alteryx formula help

SCK
Asteroide

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.

4 RESPOSTAS 4
atcodedog05
22 - Nova
22 - Nova

Hi @SCK 

 

The formula you need is

TrimRight([Field1],"-")

 

Output:

atcodedog05_0-1603275784765.png

 

Hope this helps 🙂


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

TheOC
15 - Aurora
15 - Aurora

hi @SCK 

a perfect usecase for the TrimRight function:

TheOC_0-1603275726315.png



hope this helps!


Bulien
SCK
Asteroide

Both solutions worked. Thank you so much.

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @SCK 

 

Cheers and Happy Analyzing 😀

Enquetes
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Rótulos