Seperate a imported field from Outlook

[rnutts]

Hi

I have imported data from Outlook. The field I am interested in is the
'Subject' Field. This contains 3 effective segments,
1 employee name
2 description
3 job and sub job number

example of text in field is

M.Heywood Completed Job No.1708 8
N.Curry Completed Job No.1477

I wish to move the employee name into another field and also the job and sub
job number. I have tried the following Right() Function but it is not quite
working as I want

Right$([Subject],InStr([Subject],"Completed Job No.")-1)

For the records above the results are as follows

No.1708 8
No.1477

What I really want is to only get the text after the .

Any help please as this is my first time with this function

Thanks

Richard

 

[namliam]

Ugh

Instr returns a value that indicates where the searched value STARTS not ends...

It just so happens this matches in both cases, but it is not the way i works.
If you substitute Left for Right in your statement you will get the name...

Now try to do something with the Mid function to get the remainder of the string after Completed Job No.

Maybe you alse want to look into the function InStrRev if you are allways looking for the last "."
Use the help to find out more about the functions mentioned