question: String from dataset

xspunky

Hi, I am trying to grab several strings from a dataset, however, I am not sure which tool does that. Would I use the formula tool to grab the string from the dataset? For example in one column, I have 9 words in the string, I would like to grab the first 7 words in the string, how would I go about doing that? Please advise, thank you.

Felipe_Ribeir0

Hi @xspunky 

unfortunately Alteryx does not have a built in function that could easily extract the first n words of a sentence, so the usual way to do this using Alteryx is by using regex or spliting the phrases based on spaces to delimit words. Both approachs can be seem on the attached example

String from dataset.yxmd