Left Function

[theitalianguy]

Hi i am having a problem tryin to read a string up to a chr(). The code looks like this:




strMonth = Left(strStartDate, chr(47))

what i want it to do is read the string from the left and stop when it gets to the chr(47) which is "/", but it gives me an error saying "type mismatch". Can someone tell me why this isn't working? Thanks

[ADezii]

Hi i am having a problem tryin to read a string up to a chr(). The code looks like this:




strMonth = Left(strStartDate, chr(47))

what i want it to do is read the string from the left and stop when it gets to the chr(47) which is "/", but it gives me an error saying "type mismatch". Can someone tell me why this isn't working? Thanks

You have the wrong Syntax for Left() and you are missing another required Function. This will work:

Dim strString As String, strSearchString As String
 
strString = "Yabbadabba/Doo"
strSearchString = "/"
 
Debug.Print Left$(strString, InStr(strString, strSearchString) - 1)
 
 'Output: Yabbadabba

[NeoPa]

Another way is to say :

Dim strString As String, strSearchString As String
 
strString = "Yabbadabba/Doo"
strSearchString = "/"
 
Debug.Print Split(strString, strSearchString)(0)
 Output: Yabbadabba

This also handles (automatically and without error) the case of there being no "/" character in the main string.

[MMcCarthy]

Alternatively, if you prefer to use the chr(47) adapting ADezii's code slightly

 
strMonth = Left(strStartDate, InStr(strStartDate, chr(47)))

[ADezii]

Alternatively, if you prefer to use the chr(47) adapting ADezii's code slightly

 
strMonth = Left(strStartDate, InStr(strStartDate, chr(47)))

Mary:
Wouldn't that leave the Trailing Backslash?

[MMcCarthy]

Mary:
Wouldn't that leave the Trailing Backslash?

You are right of course.

Should be ..

 strMonth = Left(strStartDate, InStr(strStartDate, chr(47))-1)

[NeoPa]

I still think you're better advised to use Split() rather than Left() and InStr() (See post #3).

[MMcCarthy]

I still think you're better advised to use Split() rather than Left() and InStr() (See post #3).

I agree, just thought it was worth posting the correct syntax for the Left function. ;)