Another trim problem

  • Thread starter Thread starter Golfinray
  • Start date Start date
G

Golfinray

I have 250 school districts in my district field. All of them say Jones
School District or Smith School District. I want to return just the Jones or
Smith and not the school district. Thanks, so much!!!
 
Use Instr to find the space then Left to get the name string

InStr([DistName], " ") finds the space so

Left([DistName, InStr([DistName], " ")-1)
Evi
 
If the name is William F. Smith School District then you need something
different.
What about Replace([YourFieldName], " School District", "")
--
KARL DEWEY
Build a little - Test a little


Evi said:
Use Instr to find the space then Left to get the name string

InStr([DistName], " ") finds the space so

Left([DistName, InStr([DistName], " ")-1)
Evi
Golfinray said:
I have 250 school districts in my district field. All of them say Jones
School District or Smith School District. I want to return just the Jones or
Smith and not the school district. Thanks, so much!!!
Click to expand...
Click to expand...
 
Back
Top