String Loop Help Using VBA in Access or Excel - Need Ideas!

[wareagle1984]

I am stuck..the bottom line is I have a string:

String ="01/01/2014 I did this 02/05/2015 I just did this as well 05/06/2017"

Essentially I need to build the string as such:
NewString = "01/01/2014 I did this
02/05/2015 I just did this as well
05/06/2017"

I have been trying to write a loop in the string (and recordset) using a number of techniques, such as using INSTRREV to find character positions of the years (Note the years span over a decade) and inserting a chr(10) after the position but have not had much luck. I can do this in vba using access or excel - I really just need someone to help bounce some ideas off.

Thanks for any help or ideas, I am new to this forum but have a few years experience of VBA, Access and Excel.

 

[xenou]

Regex is da bomb!

Note: this site is good overall regex explanation and syntax: http://www.regular-expressions.info/
They also have pages on the specific flavors of regex such as perl/java/vbscript, with vbscript here: http://www.regular-expressions.info/vbscript.html
And this is the site I usually use for a quick refresher: https://msdn.microsoft.com/en-us/library/ms974570.aspx

 

[Micron]

thanks, I definitely will check them out in spite of the risk that I might lose something important (like how to find my home).