Complex Regex Assistance Needed

[sevans]

Hi, 

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

[Greg_Murray]

@sevans,

Is the goal to keep only the values 'Accounting information' and 'Shipper & Consignee'?

Greg

[morr-co · Accepted solution]

Hi @sevans - I'm not sure of the exact output you are expecting. However, here is a sample that splits the data on semicolons.

[phottovy]

I have a feeling my solution is similar to @morr-co but I'm also not sure I know exactly what you are looking for.

Also, I found this website super helpful for testing ReGex expressions: https://regex101.com/ 

[sevans]

Thank you @morr-co of the two solutions posted this works better for my workflow. Many thanks for your help!

[sevans]

Thanks @phottovy This solution also works but the other solution works better for my workflow. Essentially, the responses in 4A are the result from the users selecting multiple choices from a survey and so, when I analyze the data I need to know how many countries (globally) have selected a particular response. Hope this helps. Many Thanks