Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Awesome Donkey]

Basically what the title says. I'm looking to find all the artists, titles, albums, etc. that contain words starting with a lowercase letter (like Ebb and Flow) and I haven't found a viable solution yet.

[Matt]

You made me scratch my head about this one!

Coming next build:
NEW: Added the expression IsLowerCase(...) to test a string to see if it's all lowercase.

So add an expression column like:
IsLowerCase([Name])

And sort by it.

[Matt]

You can also search like this (requires the new build):
[=IsLowerCase([Name])]=1

[Awesome Donkey]

Matt, you're a lifesaver!

P.S. I actually didn't know numbers were considered lowercase.

[Matt]

Matt, you're a lifesaver!

Well I think we actually had zero functions that looked at the case of a string.  We're just always ignoring the case during search.

I thought about making a different type of equality for searching like {...} to mean "Match the case" but that seemed a little complicated.

The expression was a pretty safe and simple addition.

[Matt]

This should be in the build that just went public:
http://yabb.jriver.com/interact/index.php/topic,109099.0.html

Let me know how it works.

Thanks.

[Cmely]

NEW: Added the expression IsLowerCase(...) to test a string to see if it's all lowercase.

...but not if it's starting by lower case ?

Couldn't the expression IsLowerCase work like that : IsLowerCase([string, x])], x being the number of chars of the string to test. If x=0 then test all the string ?

[Matt]

...but not if it's starting by lower case ?

Couldn't the expression IsLowerCase work like that : IsLowerCase([string, x])], x being the number of chars of the string to test. If x=0 then test all the string ?

What are you hoping to test?  Only the first letter or something?

[Matt]

It was an easy change, so coming next build:
Changed: Made the IsLowerCase(...) function take an optional second parameter for the number of characters to test.  That way you can test only the first letter for example.

[Cmely]

 

I can say only one thing : Bravo !!!