I have the list of numbers below and am trying to reformat them to be the 6 digit number, then the four digit number, then the 1 or 2 digit number. Also where there is only a single last digit I would like ot add a 0 in front it. I provided two numbers below as an example, the source being the series on the left and the right is the desired output. I thought maybe split and shift lists but then i cent get them back together and figured there had to be an easier way.
i have the data tree below with 23 branches thats reading an excel file. what would be the best way to pull out all the indicies with values of either xxxx-xxxxxx-x or xxxx-xxxxxx-xx
- 0001-275319-0 = 275319-0001-00
- 0002-085000-1 = 085000-0002-01