Split Keywords column into string

Hi all, currently I am required to split the column Keywords in the Excel, and split each individual words in the row, E.G. DeathBed as one word, Fly as another word? Is anyone able to help? example.xlsx (8.9 KB)

@Kian,

This should help:

Hi @Kian,

By looking at your excel sheet It looks like you want to split the value in key words column by a “,” delimiter
First step is to read the excel and than use this query

Split(row("Key words").ToString,“,”)

If you want split by a space and a “,” character than you can use

Split(row("Key words").ToString,“, ”)

If you always want the first word after splitting the string than you can use

Split(row("Key words").ToString,“, ”)(0).ToString