using regex tool how to split the data

chinnaupendra07

Hi hope all doing great so i have query regarding regex tool

Started running \Users\vamsikur\Downloads\Batch Input\Batch Macro Workflow.yxmd

so i want to split the only last \ line in output example \Batch Macro Workflow.yxmd

how to split the data what expression should be given in regex or should i use any other tool.

Topic of Interest

Community

Alteryx Practice

Thursday Thought

Accepted answers

Yoshiro_Fujimori

Hi @chinnaupendra07 ,

I think this should work.

Formula tool : Expression

Output = REGEX_Replace([Data], ".+(\\.+)", "$1")

Output

Please let me know if you find any problem.

You can test your RegEx on this site.

https://regex101.com/

Highly recommended.

Good luck!

Yoshiro_Fujimori

Hi @chinnaupendra07 ,

As there are multiple jobs in one Log file, you need to differentiate each job.

RegEx in Formula tool is modified

to deal with a module name such as [D:\UseCases\Test\test_del.yxmd]

to remove unnecessary strings such as "00:00:00.031 - " before an error message.

Multi-Row Formula tool is added to set a new column [MessageID].

Cross Tab tool is modified to group data by [MessageID].

Workflow

Output

All comments

Yoshiro_Fujimori

Hi @chinnaupendra07 ,

I think this should work.

Formula tool : Expression

Output = REGEX_Replace([Data], ".+(\\.+)", "$1")

Output

Please let me know if you find any problem.

You can test your RegEx on this site.

https://regex101.com/

Highly recommended.

Good luck!

chinnaupendra07

@Yoshiro_FujimoriThank you for the reply i have solved my issues the answer was correct it helped me

chinnaupendra07

Hi @Yoshiro_Fujimori given data i need split the data in different column like started running should be one column and error should be in one column

Started running [Unnamed Module] at Thu Jan 5 22:04:53 2023
00:00:00.000 - RunId - Alteryx: 4c1cfd79-afa0-4578-804a-a95162ad3608
00:00:00.000 - Workflow-id - Alteryx: 3b3152be-e421-445a-90d8-4b54f17eb739
00:00:00.000 - Error - ToolId 1: No Tests are configured.
Finished in 00:00:00.015 with 1 error

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703