Index of a specific character

1
I'm trying to copy words using substring. Copy name and surname from a field I called fullname. Question is, there a way to get the index of a space so i can copy name without knowing the integer index of space.
asked
1 answers
2

You can use the find function on this page String function calls

For example, find('John Smith', ' ')

answered