Convert txt data to excel

[Ar13f]

Dear All,

Another question I have is how to convert text data into excel data using specific data (the data I take is only data related to "excess"). I also attach an example of text data and the results of the report.

[atcodedog05]

Hi @Ar13f 

Here is how you can do it. Go through it reach out to me if you have any doubts.

Read the input file with below config:

Workflow:

Hope this helps : )

[Ar13f · Accepted solution]

Dear @atcodedog05

Amazing, thank you for your quick response.

I'm learning the steps you gave... although it's a little confusing. There is a slight revision, I added 2 data to the text file and then to retrieve the data below, how do I do it?

[atcodedog05 · Accepted solution]

Hi @Ar13f 

Try this

Hope this helps : )

[Ar13f · Accepted solution]

Dear @atcodedog05 ,

amazing .... done ...

When should I use the regex function with a formula like this "([\w\s\-]+\w)\s.*\s([\d\.]+)\s\*\*"? and When to utilize different formulas for different problems? 

Can you explain the formulas, or do you know of a place where I can learn the formulas with simple explanations?

I'm grateful for your assistance thus far ..

[atcodedog05 · Accepted solution]

Happy to help : ) @Ar13f 

You can learn more on Regex in the below links

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

You can type your regex here and it will give you the explanation https://regexr.com/

Cheers and have a nice day!