Parse String with no Delimiter
Hi, I have 3 columns: A, B, and C. Each column contains a string like "A121A5*6". I would like to parse each alphabet or the * symbol and subsequent number into separate columns. With the example string, there will be 3 columns with A121, A5, and *6. I want to do that for Columan A, B, and C, except when the value of the column is NA. How do I do this? Thank you!