I am attempting to create a code which will split a naming tag in different columns. I have been trying to use excel commands however I thing VBA might be the better option. I am attempting to input naming tags into a PI and I need to make the value of one character variable dependent on a PI command which I have working. Examples include BF_VYT1058, BF_TT1028A, and BF_TT1028B. What makes this difficult is I need to remove that "1" and each tag has a variable quantity on characters (as seen from the names) I need to extract the BF_TT or BF_VYT and the 058, 028A, or 028B from the tags. What commands could I use to extract this or what VBA code could I use?
PS: I can't just remove 1s specifically because there might be number code with another 1 (example: 1051). My final code is supposed to look like BF_VYT%@Selector%058 (when it is in PI).
Any and all help would be greatly appreciated.
PS: I can't just remove 1s specifically because there might be number code with another 1 (example: 1051). My final code is supposed to look like BF_VYT%@Selector%058 (when it is in PI).
Any and all help would be greatly appreciated.