community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Removing the first character of the column

Asteroid

Hi all, I am quite new to Alteryx. I am trying to remove the first character of one column, it is currently a string now.

So ex. 

111a

112b

113c

 

I want to make it so that it'll be

RowID

11a

12b

13c

Highlighted
Asteroid

Hi fangyi189,

 

You can use a formula tool with the built-in string functions in Alteryx to do this. There are a few ways you can achieve this, one way would be to use the formula,

Right([RowID],Length([RowID]) - 1), the minus one will strp off one character from the left of the string, I've attached an example workflow below.

 

Thanks,

 

Michael

Pulsar

Hey @fangyi189! RegEx could also be super helpful here. This expression could be added to a Formula tool and get you what you're looking for:

REGEX_Replace([Field1], ".(.*)", "$1")

Basically, this says keep everything after the first character in Field1.

Asteroid

Thank you for the solution!

Labels