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.
Solved! Go to Solution.
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 : )
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 ..
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!