Alteryx Designer Desktop Discussions

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

How to trim anything left of a specific character?

aeulusan
7 - Meteor

Hi Community,

 

I have a column in my data set that looks like below and I want to keep only the characters right to the "-". I wanted to use formula tool and the trim function to do this, but I do not have enough experience to apply my logic. Can anyone help? Thanks in advance!

 

Somekind of ID
ARC-22
BABAHSBB-231
CAP-12b

 

I would want my end result to look like this:

 

Somekind of ID
22
231
12b

 

11 REPLIES 11
ArturoJGarciaJmz
6 - Meteoroid

Find the easy weay

 

Left([Field], ToNumber(FindString([Field], "-")))

 

where "-" is the reference from where you want retrieve the values to the left

tiorio
5 - Atom

What is the meaning of +1? I assume to the right of "-".

 

Thank you

Labels