Posts by bringbackthedog

Quote from rory

LINQ doesn't work in VBA as far as I know. Seems overkill here anyway when a simple Like operator will work:

Code

Function HasNumber(sIn As String) As Boolean
HasNumber = sIn Like "*#*"
End Function
Function HasNumberOtherThanZero(sIn As String) As Boolean
HasNumberOtherThanZero = sIn Like "*[1-9]*"
End Function

You're absolutely right ! Works like a charm. So simple yet so efficient.

Thanks rory !

Quote from dentedduck

Re: Check if string contains a number

Here's where a little bit of Linq can make life easier. This will return a boolean telling if there's at least one numeric character in the string.

(from items in inputString.ToCharArray Where Char.IsDigit(items)).Count <> 0


Dave

Display More

Hi Dave, I hope you get this... 7 years later

Could you elaborate on how your code is supposed to work? I can't seem to make it work?

from items in inputString.ToCharArray WhereChar.IsDigit(items)).Count <> 0

how do i write this?

ie: x = from items in inputString.ToCharArray WhereChar.IsDigit(items)).Count <> 0 ??