GetPart to extract items from the end of a delimited list

[terry10]

Here's a tip:

Another Alteryx user asked me how to find the next to last (penultimate) item in a delimited list that could have a variable number of items in the list. She didn't find an answer on the Community, so I am sharing my answer here. 

GetPart([Field1], ",", REGEX_CountMatches([Field1], '\,')-1)

This works well, but I am curious how others do this.

BTW, this technique can also be use to identify file names within path strings using '\\' instead of '\,'  .

[binuacs]

@terry10 another method using regex