Problem with Type conversion- String to Int

[meen2525]

Hiii all,
I have a requiremnt where I need to convert an expression in string into Integer. I used CInt function but its givin error. Pleaseeee help .Not able to solve the issue


I have to extract each DIGIT ( for further calculations) after combining the values in 4 different columns.Used the MID function fr that and the MID function can accept only strings.
( Here have shown extraction of only 3 digits to avoid complication)

How to cnvert string to integer in this code without any error or Type MisMatch? Pleaaase help.

Please Login or Register  to view this content.

[romperstomper]

You should have no problem if all the characters are numeric.

[meen2525]

Nope it is highlighin the followin part in yellow color.

Please Login or Register  to view this content.

[Kyle123]

You need to look in the values of

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

they probably contain text or characters that cannot be converted to integers