returning chars right of a certain char 2

[smuthcrmnl777]

Left([line-sample],InStr([line-sample],'-')-1)

This code returns values left of the '-'. I need to return the values right of the '-'.

I tried to change it from left to righht and I modified the -1, but it is not working for me. Any advice?

 

[alvechurchdata]

Use Mid() rather than Right(). Right(myString, n) will give you the last n characters in the string. Mid(myString, n) will give you the characters after the nth character.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[smuthcrmnl777]

I am now using the Mid() with my code. It works fine, thanks for your help.

I now need to be able to take the results I get from the mid and eliminate the letters that fall to the immediate right of the numbers. I can not gurantee there are letters for every record or which letters they will be. I just need them eliminated.

For Example:

115R
115
11A
A
300
305


Some have letters some don't. What can I do to eliminate them?

 

[PHV]

The final answer is here:

http://www.tek-tips.com/viewthread.cfm?qid=1184829

Val(Mid([line-sample],InStr([line-sample],'-')+1))