need to remove a specific word from a field

[basilyos]

I hope that i can explain my problem
I have a column named "stuffno" that i should enter the id of my stuff
I should enter "no 111"
I did this because some stuff dont have id's so if i make a calculated field
"No " & [stuffno]
I will get in the field of stuffno1 "no " for the stuff without id

Ok now i want to make another column that contains just the id of the stuff
Is there anyway to take just the id numbet the contents of "stuffno" field without "no " so the "stuffno1" will be empty or it will contain just the id

Thanks in advance

 

[Gasman]

Use the MID function newfield = MID(suffno1,3,20)
Make sure 20 is large enough for your needs, or increase/decrease as you need

 

[Brianwarnock]

If the length is omitted then the rest of the field is returned following after the starting point.

Be aware that Mid returns a string not a numeric number.

Brian

 

[jpaokx]

Create another field with the same data and use the replace function in your query e.g. =replace(table!field,"stuffno ","")