Extracting data from semi-structured text files

[faran_ahmed]

Hi team,

I wanted to ask if there is a possibility with Regex or any other tool, to have a semi-structured data from the attached text file converted into what we have in the attached excel file?

I have maximum reports available in such structured text files so it will greatly reduce the effort in the workflow.

Cheers!

[mceleavey]

Hi @faran_ahmed ,

Yes, that's right. You would use a combination of Text to Columns and Regex.

That would be an entire project though, so to get you started you might want to look at the following community resources:

Regex:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/RegEx-Examples-12-Handy-Use-Cases/td-p...

https://help.alteryx.com/20213/designer/regex-tool

https://community.alteryx.com/t5/Interactive-Lessons/Using-RegEx-in-Expressions/ta-p/424427

Text to Columns:

https://help.alteryx.com/20213/designer/text-columns-tool

https://help.alteryx.com/2019.1/TextToColumns.htm

https://community.alteryx.com/t5/Interactive-Lessons/Separating-Data-into-Columns-and-Rows/ta-p/8018...

Hope this helps,

M.

[faran_ahmed]

Hi @mceleavey ,

Appreciate for prompt response. I'd certainly go through the links and will see if I can get it done. Much Thanks. Cheers !

[mceleavey]

[faran_ahmed]

Hi Dear,

I have figured a way out for this by using Regex and multiline formula tool. This has got me to solve a load of my work in simplest manner.

I have attached the workflow for reference.

Best Regards.

[binuacs]

@faran_ahmed 

Spoiler