RegEx or Substring

Help
1

Hello,

I’m using ‘Get Full Text’ to extract words and dates. My goal is to read the below comments and make decisions based on how many emails have been sent, as well as isolate the date to see if an email has been sent in the previous 3 days.

image

I can isolate the date using the following RegEx ----> \[.*?\]

My next challenge is getting the comment to be matched with the date. I’m not sure if RegEx or Substring would be a more effective method. I’m open to other ideas as well. Below is a sample of the text in a collection. I’m trying to isolate the bold text.

“\n\n\n\n\n\nSterlin…\n\n\n\n\n\n\n[Tuesday, May 28, 2019 at 9:13 AM]\n\n\n\n\n\n\n\n\n\n\nEdit\n\n\n\n\nDelete\n\n\n\n\n\n\n\n\n\n\n\n\n\nEmail sent\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nSterlin…\n\n\n\n\n\n\n[Tuesday, May 28, 2019 at 9:13 AM]\n\n\n\n\n\n\n\n\n\n\nEdit\n\n\n\n\nDelete\n\n\n\n\n\n\n\n\n\n\n\n\n\n2nd email\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nSterlin…\n\n\n\n\n\n\n[Tuesday, May 28, 2019 at 9:13 AM]\n\n\n\n\n\n\n\n\n\n\nEdit\n\n\n\n\nDelete\n\n\n\n\n\n\n\n\n\n\n\n\n\n3rd email\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nSterlin…\n\n\n\n\n\n\n[Tuesday, May 28, 2019 at 9:14 AM]\n\n\n\n\n\n\n\n\n\n\nEdit\n\n\n\n\nDelete\n\n\n\n\n\n\n\n\n\n\n\n\n\n4th email\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n”

Any help is appreciated.

Thanks,
Brad

2

Something like this?

image
image696×425 23 KB