Separating text

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hi, I have a field which has effectively two addresslines in it, separated
by a comma followed by apscae. is there anyway I can extract the text after
the comman and space and place it into the next field which is empty

Thanks

Alex
 
You can do this in an update query by putting the following
in the UpdateTo line of your empty field. Of course, since
you didn't supply any field names to work with, you will
have to substitute mine with yours.

Mid([Address],Instr([Address],", ")+2)

Of course, this will still leave your old address intact. If
you want to strip the comma space and the line you just put
in the other field, you will now want to do this to the
Address field to get everything to the left of the comma

Left([Address], Instr([Address],", ")-1)

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
You're welcome!

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top