Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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