Trimming Characters

[alan04]

My students reg numbers are written as 01/2007, 101/07 and 1/07. How to trim the numbers to get the numbers left to the sign / only.

 

[Bodisathva]

My students reg numbers are written as 01/2007, 101/07 and 1/07. How to trim the numbers to get the numbers left to the sign / only.

tgtNum = Left(regNum, 1, InStr(regNum,"/"))

 

[rainman89]

Search for Parsing on the forum! you should be able to find an answer there

Edit: Or someone will tell you!

 

[GregVB]

tgtNum = Left(regNum, 1, InStr(regNum,"/"))

This almost works for me as well. I had to change it to tgtNum=left(regnum, instr(regnum,"/")) but it returns the "/" as well. is there a way to omit that?

 

[raskew]

from the debug (immediate) window:

regnum = "101/07"
tgtNum=left(regnum, instr(regnum,"/")-1)
? tgtNum
101

 

[RoyVidar]

For the fun of it, here's another one

MsgBox Split("01/2007", "/")(0)

Is there any possibility that there is no "/" in the string?