SOLVED
inout output
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
hi2019
8 - Asteroid
‎08-22-2024
09:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Reporting
1 REPLY 1
apathetichell
19 - Altair
‎08-22-2024
09:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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')