Alteryx Designer Desktop Discussions

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

Removing the 1st 3 characters from a field

timothysmith_NYFRB
7 - Meteor

I added a MM_ to the month field (added 01_ to January, etc.) so when I used the crosstab tool, it sorted in the right month order by month.  Is there a way to remove the 1st 3 characters now that I have the months in the right order

3 REPLIES 3
rzdodson
12 - Quasar

@timothysmith_NYFRB here is one way to do it with a Dynamic Rename tool.

Regex_Replace([_CurrentField_],"\d{2}_","")

 

 

01. Solution.png

timothysmith_NYFRB
7 - Meteor

Thank you very much, I used the dynamic rename tool, but thought I had to use 12 tools, the Regex_Replace really made it simple with 1 tool

rzdodson
12 - Quasar

@timothysmith_NYFRB  Glad to help! When able, please mark it as a solution to help out future Alteryx users in their search. :)

Labels