Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Parsing log text

8 - Asteroid
Hi Team,
I have a error log text like this:
File Name:xyzkey.csv
----Some texts----
record accepted :1
---some texts---
now i need to parse following
1(text accepted after record accepted)

Any idea.

Thanks in advance.

16 - Nebula
16 - Nebula

I expect this could be done using a multi-row formula combined with some RegEx functions.


Could you provide a couple more example files just to make it clear on the transform you need


8 - Asteroid

Sample Log:

File Name is: \\Client\Apps\Loaders\Latest LOADER\Test Files\test145.csv
Records Read: 1
Records Added: 1
Records Rejected: 0
Errors Reported: 0
Warnings Reported:


From "File Name is: \\Client\Apps\Loaders\Latest LOADER\Test Files\test145.csv"  I want test045 alone.
Also from "Records Added:1 " , I need 1 alone




16 - Nebula
16 - Nebula

The attached workflow should do what you need.


Select the Output file name as field option on the Input Data tool to include the file name. I chose to use a CSV mode with separator set to \0 and with field names set to 0, but there are various ways to read it in.


A filter expression filtering out all but the Records added row via a regular expression. And then a RegEx tool in replace mode to extract just the number


If you expect things other than numbers then you will need to edit the (\d+) part of the expression.


 Hopefully enough to get you started.

8 - Asteroid

Thanks.This Approach helped me to find the solution .