How to generate new columns containing parts of a string
What is the best way to create new columns, containing substrings from an existing column? In case the order of the sub strings is always the same, the Word function would be the way to go.What would be the solution in case the sub strings sequence is not always the same? The attached file shows examples.