Hi Neil,
First, select all records that contain a space:
Select * From [table name] Where [field name] like "% %" Into updateTable
Update updateTable Set [field name] = Mid$([field name], instr(1,[field name]," ")+1, len([field name])-instr(1,[field name]," ")+1)
Then check the results in case you need to repeat to cater for "Mia Mia Road" for example.
------------------------------
James Nolet
Dooley Mitchell & Morrison Pty Ltd
Mentone, VIC, Australia
------------------------------
Original Message:
Sent: 03-24-2020 22:31
From: Neil Adamson
Subject: Delete characters before a space
Hi All,
I have a list of roads eg. Smith Street.
I want to remove all the characters before the blank and end up with the street type.
I can use the update column command
Right$(field_name, ????)
But I can't work out the exact syntax.
If there is already a thread on this please direct me to it.
regards,
Neil
------------------------------
Neil Adamson
GIS Officer
Mitchell Shire Council
Broadford VIC
------------------------------