Extracting parts from a series of underscores like 448_2021_2_2021_3_1_56

Options
HarunT
HarunT Member, ALL USERS, Certified Model Builder Posts: 4 Occasional Contributor
in Planning & Modeling

Hello All, 

 

I am having trouble extracting certain parts from the code like 217_2021_2_2021_3_1_56, that first three digits is the phase code, then year, then month, then another year, another month, version, and location code. Month and version numbers could be one or two digits depending on the date, so not sure about the best and easiest to extract each information in a separate line item. Any help is extremely appreciated. 

Tagged:

Comments

  • HarunT
    HarunT Member, ALL USERS, Certified Model Builder Posts: 4 Occasional Contributor
    Thank you Mark. Although the number of characters are not fixed, I believe I figured out the solution. Thanks.

Categories