Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I feel this is an easy question, but cannot seem to figure out the answer. How would you get rid of all the characters after the second space?
[Field Name]
JP Smith (Micheals) Market
T Warner Market
A Phillips (Hounds) Farms
Kelley Williams Tower
So it would look like this
[Field Name]
JP Smith
T Warner
A Phillips
Kelley Williams
Thanks
Hi Matt. Try this
Left([Field Name], Index([Field Name], ' ', 2))
Try this.
If you want at the script level, try the below expression.
=Left('FieldName',Index('FieldName',' ',2))