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!
Solved! Go to Solution.
@pchong can you upload the input file separately?
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!