topic Re: Regex Parsing with no Delimiter in Alteryx Designer Desktop Discussions

Regex Parsing with no Delimiter

Peddsairam — Mon, 28 Jul 2025 11:42:59 GMT

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.

Re: Regex Parsing with no Delimiter

binu_acs — Mon, 28 Jul 2025 12:09:23 GMT

@Peddsairam one way of doing this with regex formula

Re: Regex Parsing with no Delimiter

Peddsairam — Mon, 28 Jul 2025 17:52:01 GMT

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 ?

Re: Regex Parsing with no Delimiter

binu_acs — Mon, 28 Jul 2025 21:12:19 GMT

@Peddsairam

Re: Regex Parsing with no Delimiter

Peddsairam — Tue, 29 Jul 2025 16:39:46 GMT

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.

Re: Regex Parsing with no Delimiter

binu_acs — Wed, 30 Jul 2025 08:36:18 GMT

@Peddsairam check this one