Split Text to Columns

[katonyaj]

I am trying to split the following text in the columns as such with the before split into multiple columns so I can later group by columns B and D

I have also attached the excel file for reference

[Luke_C · Accepted solution]

 Hi @katonyaj 

We can do this with regex parsing:

(.*)\.(.*)\.{3}(.*)\s(.*)

1. (.*)\. - anything before a period
2. (.*)\.{3} - anything between the first item and 3 periods
3. (.*)\s - anything between the 2nd item and a space
4. (.*) - any remaining characters

[mpennington · Accepted solution]

See attached.

(.*?)\.(.*?)\.{3}(.*?)\s(.*)

[katonyaj]

Thanks a bunch!!