Remove excess characters

[MDRiddle]

I currently import data from a main frame into access and one of the fields has a number ranging from 1-9999 followed by 10 other charachters which includes a space. eg '123_00.00:000'. I would like to remove/delete the ten characters from the right. Does anyone have any ideas?

Thanks MDRiddle

 

[pkailas]

You could try this:

left(strVariable, len(strVariable) - 10)

 

[MDRiddle]

Thank you it worked... I also found another way too by trial and error. (Val(strVariable))/100. In the original question I used an under score to represent a space so by using Val iI got a number with two extra 0s. So dividing by 100 would get the same results.

Thanks again for your support.

Mike

 

[pkailas]

oh, well, I didn't know that! In that case you could also use the split command

arString = split(strVariable, " ")

strNumber = arString(0)