Parsing a list of Notes

[tyhoffman]

Hello All,

Somewhat brand new to Alteryx and hoping someone may be able to provide some support.

I have list of notes that where I need to pull the most recent note from the list.  I am trying to use the RegEx tool, but I am still learning the ropes.

Example:

5. John updated the dashboard  4. Abby created the dashboard 3. Michael approved the creation of a dashboard 2. Data profile was selected 1. Need for visualization tool outlined.

This example includes all the notes in one row under one field, In my case I would need to pull the "John updated the dashboard" note.

Appreciate any help!

[griffinwelsh · Accepted solution]

Assuming the newest comment is always in the beginning of the string you can use the attached solution