Leakyradiator
Technical User
I have a list with the following items in it:
147,101,102,145,134,135,147117,134109
Here's what I want to do:
if the first 3 numbers of the 6 digit items equals any of the three digit numbers, (they always will,) I want to prepend to the 6 digit number a 3 digit number (arbitrarily, 555) and delete the three digit number that matches the first 3 digits of the 6 digit number.
for example: the lists shows 147117. I want the final output to be 555147117. And because 147117 starts with 147, I want to delete the 3 digit 147 from the list.
the after all the corresponding 3 digit numbers are deleted, I want to prepend the remaining 3 digit numbrers with 555 and append the number 999 to each of the 3 digit numbers
the final list would look like 555147117,555134109,555101999,555102999,555145999,555135999
Thanks
147,101,102,145,134,135,147117,134109
Here's what I want to do:
if the first 3 numbers of the 6 digit items equals any of the three digit numbers, (they always will,) I want to prepend to the 6 digit number a 3 digit number (arbitrarily, 555) and delete the three digit number that matches the first 3 digits of the 6 digit number.
for example: the lists shows 147117. I want the final output to be 555147117. And because 147117 starts with 147, I want to delete the 3 digit 147 from the list.
the after all the corresponding 3 digit numbers are deleted, I want to prepend the remaining 3 digit numbrers with 555 and append the number 999 to each of the 3 digit numbers
the final list would look like 555147117,555134109,555101999,555102999,555145999,555135999
Thanks