Trim

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

i have a table and want to trim some data off
for example

1. John Jones
2. Frank Smith

i want to get rid of everything to the left the 1. and 2.
 
Maybe this is too complicated, but it will work:

Mid([NAME],InStr([NAME]," ")+1)

InStr looks for first blank space in the string and then uses the position +
1 (to eliminate the blank space) in Mid function (no length needed).

Hope this helps.

Luke
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Multiple Records from Single Delimited Field 1
trim 3
query to combine columns 2
DISTINCT or GROUP BY? 4
SQL for specific pattern of output? 2
Multiple records in table to display single records 7
HAVING clause 2
Select with Conditions 4

Back
Top