Help with Right(Me.ListStoreIP.Column(0), 2)
 

I think there is a way to find # and use the value to the right of the number
sign
Any help would be great
Tobacco Rd Outlet #02
Right(Me.ListStoreIP.Column(0), 2) = 2 Right
Tobacco Road Outlet #02
Right(Me.ListStoreIP.Column(0), 2) = 2 Right
Tobacco Road Outlet #112
Right(Me.ListStoreIP.Column(0), 2) = 12 Wrong

Help with Right(Me.ListStoreIP.Column(0), 2)
 

mid(mystring,instr(mystring,"#") + 1)

"Mike" wrote:

I think there is a way to find # and use the value to the right of the number
sign
Any help would be great
Tobacco Rd Outlet #02
Right(Me.ListStoreIP.Column(0), 2) = 2 Right
Tobacco Road Outlet #02
Right(Me.ListStoreIP.Column(0), 2) = 2 Right
Tobacco Road Outlet #112
Right(Me.ListStoreIP.Column(0), 2) = 12 Wrong

Help with Right(Me.ListStoreIP.Column(0), 2)
 

Thanks Joel
Can I ask whats the +1 do

"Joel" wrote:

mid(mystring,instr(mystring,"#") + 1)

"Mike" wrote:

I think there is a way to find # and use the value to the right of the number
sign
Any help would be great
Tobacco Rd Outlet #02
Right(Me.ListStoreIP.Column(0), 2) = 2 Right
Tobacco Road Outlet #02
Right(Me.ListStoreIP.Column(0), 2) = 2 Right
Tobacco Road Outlet #112
Right(Me.ListStoreIP.Column(0), 2) = 12 Wrong

Help with Right(Me.ListStoreIP.Column(0), 2)
 

Looks like it moves the start position one space to the right of the # so it
should return everything to the right of the # sign. Does it?

"Mike" wrote:

Thanks Joel
Can I ask whats the +1 do

"Joel" wrote:

mid(mystring,instr(mystring,"#") + 1)

"Mike" wrote:

I think there is a way to find # and use the value to the right of the number
sign
Any help would be great
Tobacco Rd Outlet #02
Right(Me.ListStoreIP.Column(0), 2) = 2 Right
Tobacco Road Outlet #02
Right(Me.ListStoreIP.Column(0), 2) = 2 Right
Tobacco Road Outlet #112
Right(Me.ListStoreIP.Column(0), 2) = 12 Wrong