Data and Text extraction

[bnari12]

Hi All,

In the attached file, there are 2 columns. 

The first column has the raw data and in the second column i have mentioned the required output.

Can anyone please help me with the workflow or formulas to get the output.

Regards

bnari12

[Qiu · Accepted solution]

@bnari12 
Hope this will work.

[pedrodrfaria · Accepted solution]

Hi @bnari12 

I wanted to provide you with a workflow that does not require complicated skills and would allow you to update it in case you need for future workflows. Ideally we would try to use a regex, but since I do not know if you are familiar with it, I think the logic below that only uses basic alteryx knowledge would be a better fit for you.

The workflow will look at each data row and look for the first instance where we have a "(" and assign this as the correct data piece. For this workflow you can have thousands of data rows as well as large data strings that it will not matter if the data size changes.

Please let me know if you have any questions.

Pedro.

[bnari12]

Thank you so much !

This is very helpful..

Regards

bnari12

[bnari12]

Thank you so much !

This is very helpful and looks easy to manage as well.

Thank you again.

Regards

bnari12

[Qiu]

@bnari12 

Glad to help and thank you for the accept mark.