Question on Parsing Int

[ghtill]

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

[Kinga · Accepted solution]

hi ghtill,

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

of course data type need to be string :)

[Desmond]

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