RegEx Parse

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.

Screenshot 2023-10-15 012837.png

Regex

Accepted answers

caltang

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/

For Ashley.yxmd

All comments

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

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

For Ashley.yxmd

caltang

Did my solution help? @Ashley

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335