Extracting a string from a column heading and adding to another
Hello,I have an import script which I use to import results into JMP from excel. The template excel is used by lots of people and is locked for editing. We have two results columns in the excel which are both called "Results - XXX" where XXX is replaced using an excel marco to what is being studied so changes in each file. We also have columns called JMP Result 1 and JMP Result 2 which are equal t...