Select word
Returns nth word from text of specified column, replacing the text in the column.
Returns nth word from text of specified column, replacing the text in the column.
Index refers to the word position in the sentence. If you type 1, the tool returns the first word in the sentence. If you type 2, the tool returns the second, and so on. Separator refers to what is used to separate each word. Usually, this is a space.
With the Output column(s) option, you can add new columns or replace existing selected columns in your data set. The columns append to your data set, with the naming convention of (column)_extracted, for example: Monthly Sales_extracted.
When to use this tool
Use when you want to extract a specific word part of the sentence. If you just want to return part of a sentence irrespective of the word count, use the Text part tool.