Regex Help

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!

Regex

Parse

Accepted answers

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

Thanks!

@pchong can you upload the input file separately?

Sure, here is the sample input.

Try this

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

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

Thanks!