topic Re: Extracting the Last Word in Discussions

Extracting the Last Word

dn610 — Fri, 09 Jun 2023 16:05:45 GMT

Hi - If I want to extract the last word in the Name column below, what would be the best way to so?

jthi — Wed, 08 Feb 2023 15:13:53 GMT

Right click on the column header you wish to get the value from and create new formula column with Last Word

then you can take a look at the formula if needed

You can also do the extraction with Recode for example

Jeff_Perkinson — Wed, 08 Feb 2023 15:31:17 GMT

The Word() function is perfect for this. Use "-1" to get the last word.

dn610 — Wed, 08 Feb 2023 15:45:05 GMT

Thank you!