How do I split a string using " " as separator?

I am not able to split a text based on " " as a separator.
Any help here?

(I tried using quotes, I tried copy pasting blank space from somewhere else and pasting)

You can use space for this.

4 Likes

Thanks, this worked!!

@Runcorn Another question - From an array, how do I choose first and second (if present) values?

You can either use first() or get(array;1) or get(array;2)

2 Likes