General Discussions

Discuss any topics that are not product-specific here.
SOLVED

Parsing a list of Notes

tyhoffman
5 - Atom

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!

1 REPLY 1
griffinwelsh
12 - Quasar

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

Labels