String Character Trim and conversion to date
All, I am currently working with a table that contains a column with character strings like 'MQC_030817_1_Pb' or'Cond_060917_1'. I am trying to extract the string in between the first 2 delimeters '_ 030817_'and convert it into a date formatin order to sort the column by this date. I appreciate any inputs on how to express a jsl formula to achieve this. Thank you for your support in advance.
msharp