Removing the first four characters from a field.

[kharder]

Hello,

I want to remove the first four characters from a field in a query.

The data are not always the same length, but it will always be the first four.

Example.

vmc_ml120e21/p -> ml120e21/p

Is that possible and how??

Thanks in advance.

 

[stephen81]

right([field],len([field])-4) should do the trick I think.

 

[kharder]

Nope, that didn't do the trick. Any other ideas??
I tryed to use it like this: right([MODEL],len([MODEL])-4) is that right??

Thanks,

 

[kharder]

I solved the problem with this Mid([MODEL];5;50).
There isn't any strings there are over 12 char. long.
But I am still interestet in a better solution, because I have to use it later in the same database.

 

[stephen81]

Nope, that didn't do the trick. Any other ideas??
I tryed to use it like this: right([MODEL],len([MODEL])-4) is that right??

Thanks,

That should work. Have a look at the attached database. It demonstrates what I've posted.

 

[kharder]

Ok, now I see whats wrong. Thank you.

 

[Jon K]

I solved the problem with this Mid([MODEL];5;50).
.............
But I am still interestet in a better solution,

Mid([MODEL];5)

which is the best solution.
.