STRING PARSING QUESTION

[BHostmeyer]

How do i pull a the begining of this string but not the end..

string = 12345/67890

i want new_string = 12345
any help will be most appricated

thanks
brooke

[MartinLiss]

new_string = Left$(string, 5)

------------------
Marty
What did the fish say when it hit the concrete wall?
> > > > > "Dam!"

[BHostmeyer]

WHAT IF ITS 123456/799483 i want everything in front of the /

[Serge]

Try this:


Dim strText As String

strText = "12345/abcd

strText = Left(strText, InStr(strText, "/") - 1)



------------------

Serge

Senior Programmer Analyst
[email protected]
[email protected]
ICQ#: 51055819