I'm attempting to copy just the numeric portion of a street address into a new table using the Field Calculator in QGIS. The expression I'm trying to use is:
left( "SITE_ADDR", strpos( "SITE_ADDR", " " ) -1)
strpos is giving an invalid expression error- column " " not found.
Is there another way to format this expression to actually work?