Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Question on Parsing Int

ghtill
7 - Meteor

Hello I am new to Alteryx and unfamiliar to Regex (If this is what I would need). I was looking to complete the example below. The first digit has no purpose, the middle two represents year, and the last digits have three meanings 6 = Summer, 3 = Fall, 7 = Spring. Any help or direction would be appreciated. Thank you.

 

Current:

3176
4183
7207
8216

 

Expected outcome:

Summer 2017
Fall 2018
Spring 2020
Summer 2021
2 REPLIES 2
Kinga
8 - Asteroid

hi ghtill,

 

I think simple right and left in formula tool will be enough:

Kinga_0-1660237512999.png

of course data type need to be string :)

Desmond
8 - Asteroid

I came up with a very similar solution, left and right statements are the key

Labels