Split string based on N number of spaces

[Elcarabanchel]

Hi there,

I have an address string in the following format:
14 Smith Road Sydney NSW 2000

and want to split it to be: "14 Smith Road" in one field and "Sydney NSW 2000" in another.
I thought I could split the string after the 3rd space but couldn't find a way to do it.
Does anyone know of a formula to separate a string based on an n number of spaces? Or any other way to achive that?
Thanks

 

[IanWaterman]

You can join the splits back together

@Road
split(yourfield, ' ')[1] &" "&split(yourfield, ' ')[2] &" "&split(yourfield, ' ')[3]

Ian