Delimiter

[Tony]

Is there a way to have a query look for a delimiter and if it exists have it
print everything to the left of it? My example here is:

What I have:
792-3421/Bob Johnson

What I want to have:
792-3421

The delimiter I want to use is /.

Thank you in advance,
Tony

 

[Tony]

This is perfect.

Thank you very much!!!

Tony

Use the expression after the question mark:

strInput$ = "792-3421/Bob Johnson"
?Left(strInput, InStr(1,strInput,"/")-1)
792-3421

HTH
Van T. Dinh
MVP (Access)




have