I have a total of 5 unique uuid values. Each uuid value has a total of 32 characters.
example (8-4-4-4-12):
7e6cf267-abbd-41ac-9566-23028c47c0cc
eb6f600f-f8c9-4d54-963a-963962984ca6
e1b2cc37-14fc-40e4-8ebe-bc6e13816155
d766b0c7-3e84-4953-b4a9-5526300ea022
733a86c5-1f03-42fd-b5b5-3571fd18f7ca
The goal I am trying to accomplish is to fetch everything up to the second to last character (30 characters) and have the scenario automatically generate the final two characters based on the order of the sequence.
7e6cf267-abbd-41ac-9566-23028c47c001
eb6f600f-f8c9-4d54-963a-963962984c02
e1b2cc37-14fc-40e4-8ebe-bc6e13816103
d766b0c7-3e84-4953-b4a9-5526300ea004
733a86c5-1f03-42fd-b5b5-3571fd18f705
the last two initial characters are replaced by 01, 02, 03, 04, 05, etc.
I’ve used the substring function to fetch the first 30 characters but don’t know how to generate the last two.