inout output

[hi2019]

Hi

2025 NY CARO 500008 Working File Input.xlsx

how can I get this in output utlizing the YEAR and STATE from input for each file I will use in my workflow -yes they will be in the same format 

Formula?

thanks

[apathetichell · Accepted solution]

left([field],4) - should give you year.

right(left(field,7),2) should give you state.

regex version - regex_replace([field],'^(\d{4}).*','$1')

regex_replace([field],'^\d{4} (\w{2}).*','$1')