Regex Help

[pchong]

Hi community,

I am not an expert in regex, learning some parsing techniques.

I have attached a workflow with a sample text to parse.

(Edit : re-uploaded workflow to replace xlsx input to text input)

This is what I have on the regex tool.

(\w+), (\d+\/\d+\/\d{4}), (\d+)(?:\*(\d+\.\d+))?(\*(\d+))?\[(\d+)\]$

However, the rows of my output are all null.

Kindly provide assistance to achieve the desired output.

Thanks!

[binuacs]

@pchong can you upload the input file separately?

[pchong]

Sure, here is the sample input.

[aatalai]

Try this

(\w+)\, (\d+\/\d+\/\d{4})\, (\d+)(?:\*(\d+\.\d+))?(\*(\d+))?\[(\d+)\]$

[pchong · Accepted solution]

I was able to fix it with (\w+),(\d{1,2}/\d{1,2}/\d{4})(\d+)[*](\d+\.\d+)[*](\d+)[[](\d+)

Thanks!