RegEx Parse

[Ashley]

Hi, pls refer to the screenshot attached, I am trying to use RegEx parse to separate the dates xx/xx from the words, (\d{2}/\d{2})(.*?) is my expression, but I only managed to split out the date and not the words, not sure where I went wrong. Hope to get some help. :)

 

[MRod]

An unescaped delimiter (/) must be escaped with a backslash (\). Additionally, the (?) is a lazy quantifier and matches as little text as possible while still allowing the overall pattern to match. Thus, you should remove. You can test/verify your regex at https://regex101.com/. 

The following should work:
(\d{2}\/\d{2})(.*)

[caltang · Accepted solution]

Not sure what exactly you want, but I made two RegEx for you:

If you just want the dates parsed out:

(\d{2}/\d{2})

If you want two columns to split the date and the text that ensues, use this:

^(\d{2}/\d{2})?\s*(.*)

Hope this helps @Ashley 

If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/

[caltang]

Did my solution help? @Ashley