Hi all! I need to move characters from the beginning of a string to the end.
I have a list of Exact stings that are allowed. I need to move this allowed string to the end of a PN.
JAN
JANS
JANTX
JANTXV
One step further. If "TR" or "T/R" are at the end of the PN, then I need that removed completely.
i.e.
JANTX1N4624UR-1TR
JANTX1N4625-1
JANTX1N4625-1T/R
PN vs. Desired result
JANTX1N4624UR-1TR = 1N4624UR-1JANTX
JANTX1N4625-1TR = 1N4625-1JANTX
JANS2N1711T/R = 2N1711JANS
JANTXV1N4148UR-1 = 1N4148UR-1JANTXV
Bookmarks