not farmost left character

  • Thread starter Jean-Paul De Winter
  • Start date
J

Jean-Paul De Winter

Hi,
from a string I want everything except from the most left string....
I don't know in advance how long the string will be...

ex: personname="Joe Jackson - Randy Crawford -"
I want to get:
"Joe Jackson - Randy Crawford"

Thanks for your kind help
JP
 
R

Rick Brandt

Jean-Paul De Winter said:
Hi,
from a string I want everything except from the most left string....
I don't know in advance how long the string will be...

ex: personname="Joe Jackson - Randy Crawford -"
I want to get:
"Joe Jackson - Randy Crawford"

Thanks for your kind help
JP
Click to expand...

Um, that would be everything except the *right-most* character wouldn't it?

Try...

=Mid([FieldName], 1, Len([FieldName])-1)
 
J

Jean-Paul De Winter

great... perfect help
Thanks
JP

Rick Brandt schreef:
Jean-Paul De Winter said:
Hi,
from a string I want everything except from the most left string....
I don't know in advance how long the string will be...

ex: personname="Joe Jackson - Randy Crawford -"
I want to get:
"Joe Jackson - Randy Crawford"

Thanks for your kind help
JP
Click to expand...

Um, that would be everything except the *right-most* character wouldn't it?

Try...

=Mid([FieldName], 1, Len([FieldName])-1)
Click to expand...
 
Top