I'm trying to use RegEx to tokenize a cell into multiple columns, however, I can seem to get the expressions to work as needed due to the varying possible outcome;
Column to Parse:Q4A
Column Data: Accounting information;Default consignment details (pces, wgt, dims, pkg);OSI;SSR;Shipper & Consignee;Special Handling Information: IATA Required Declarations;
I've attached an example file, could someone help me with the solution? In the highlighted columns, I've shown the preferred outcome.
Many thanks, Stuart