INTERACT FORUM

More => Old Versions => JRiver Media Center 22 for Windows => Topic started by: Awesome Donkey on January 24, 2017, 09:19:13 am

Title: Search expression to find words starting with lowercase letters?
Post by: Awesome Donkey on January 24, 2017, 09:19:13 am
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.
Title: Re: Search expression to find words starting with lowercase letters?
Post by: Matt on January 24, 2017, 09:45:13 am
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.
Title: Re: Search expression to find words starting with lowercase letters?
Post by: Matt on January 24, 2017, 09:49:31 am
You can also search like this (requires the new build):
[=IsLowerCase([Name])]=1
Title: Re: Search expression to find words starting with lowercase letters?
Post by: Awesome Donkey on January 24, 2017, 11:06:26 am
Matt, you're a lifesaver! ;)

P.S. I actually didn't know numbers were considered lowercase. :P
Title: Re: Search expression to find words starting with lowercase letters?
Post by: Matt on January 24, 2017, 11:14:54 am
Quote from: Awesome Donkey on January 24, 2017, 11:06:26 am
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.
Title: Re: Search expression to find words starting with lowercase letters?
Post by: Matt on January 25, 2017, 06:36:11 am
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.
Title: Re: Search expression to find words starting with lowercase letters?
Post by: Cmely on January 25, 2017, 07:09:31 am
Quote from: Matt on January 24, 2017, 09:45:13 am

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 ?
Title: Re: Search expression to find words starting with lowercase letters?
Post by: Matt on January 25, 2017, 07:16:53 am
Quote from: Cmely on January 25, 2017, 07:09:31 am
...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?
Title: Re: Search expression to find words starting with lowercase letters?
Post by: Matt on January 25, 2017, 07:24:24 am
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.
Title: Re: Search expression to find words starting with lowercase letters?
Post by: Cmely on January 25, 2017, 10:08:17 am
 :o

I can say only one thing : Bravo !!!