So I have a property table that has addresses like below.
12 Andrews CL, Pxxx 1/12 Andrews CL, Pxxx 2/31 Macrossan ST, Pxxx 2/7-11 Barrier ST, Pxxx
I need to only show
12 1/12 2/31 2/7-11
Can this be done within the expression builder in Mapinfo 12?
In python it would be something like address[:address.find(' ')]