Regex Parsing with no Delimiter

[Peddsairam]

Hi SME,

I have "Concat data" in the attached Excel; the concatenated data doesn't have any delimiter to parse into different columns. I wanted to know if the data can be separated or not. Here, we have a thing where the data can be separated based on "Q", where each line ends and the next line is to start, but I don't know how to use any tool to differentiate these values. I would like to know if it's possible to use the RegEx tool to parse or any other tools to parse the data into different columns, for example, u can check the Excel output sheet. I want to know if any tools will be helpful to parse this.

Thanks, 

SR.

[binu_acs · Accepted solution]

@Peddsairam one way of doing this with regex formula

[Peddsairam]

 Hello Binuacs,

Thanks for the help, 

Can you also help me with one other thing "State: CALIFORNIA (25)Total Employees:2" i want to parse this into two parts where State: CALIFORNIA (25) is one and Total Employees:2 is one ?

[binu_acs · Accepted solution]

@Peddsairam 

[Peddsairam]

Thank you for the help, Binuacs. I am sorry to ask this can also help me parse this Excel Concat data. You can find the output in the Output sheet in the Excel. Please and sorry for the repeated asking.

[binu_acs]

@Peddsairam check this one