String selection (1 Viewer)

[deanvilar]

Hello Gurus ...

txt = CS000001

I selected a part of the string by RIGHT (me.txt, 6) "returns 000001"... but what I really need is to take the strings before these 6 digits "CS" .... I cannot use LEFT(me.txt, #) because the the letters before these 6 digits can be 1, 2, 3 or more letters .. for example CS000001, CSC000003, MBMMS000005, etc...

thanks in advance ... =)

 

[JHB]

Try Left(Me.txt, len(Me.Txt)-6)

 

[deanvilar]

thanks for your reply ... let me try

 

[deanvilar]

it did the trick! thanks ...

 

[JHB]

You're welcome.