Dear All,
I would like to swap two blocks of characters if their order is not correct:
c38198_600_luc is the correct order
c38198_luc_600 is incorrect
the 3 digit code varies only its first digit, I will always have either 400, 600, or 700
the 3-letter code can have many combinations of only letters and only ever 3 characters
the cxxxxx part at the beginning should always stay there, and the c should always be sentence case, it can happen sometimes that it is capital
sometimes I can have dashes - instead of underscores _, I want to make sure they are all changed to underscores
sometimes I can have some more text/digits/symbols after these three blocks, such as c38198_600_luc_mtp2, I want to keep these extra characters as they are
I could fix most of these requirements with the basic functions of the software but the swap with the IF condition got me pretty stuck, it would be great if you could help me with this