INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Search expression to find words starting with lowercase letters?  (Read 3731 times)

Awesome Donkey

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 8189
  • The color of Spring!
Search expression to find words starting with lowercase letters?
« 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.
Logged
I don't work for JRiver... I help keep the forums safe from "male enhancements" and other sources of sketchy pharmaceuticals.

Windows 11 24H2 Update 64-bit + Ubuntu 24.10 Oracular Oriole 64-bit (AMD 7900X CPU/AMD 7800 XT GPU/64GB RAM/2TB M.2 NVMe SSD)
macOS Sequoia 15.3.2 (M4 Mac Mini 16GB RAM/256GB SSD)
Windows 11 24H2 Update 64-bit (Intel N305 Fanless NUC 16GB RAM/500GB M.2 NVMe SSD)
JRiver Media Center 33 (Windows + Mac + Linux) | iFi ZEN DAC 3 | JBL 306P MkII Studio Monitors | Audio-Technica ATH-M50x Headphones

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42742
  • Shoes gone again!
Re: Search expression to find words starting with lowercase letters?
« Reply #1 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.
Logged
Matt Ashland, JRiver Media Center

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42742
  • Shoes gone again!
Re: Search expression to find words starting with lowercase letters?
« Reply #2 on: January 24, 2017, 09:49:31 am »
You can also search like this (requires the new build):
[=IsLowerCase([Name])]=1
Logged
Matt Ashland, JRiver Media Center

Awesome Donkey

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 8189
  • The color of Spring!
Re: Search expression to find words starting with lowercase letters?
« Reply #3 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
Logged
I don't work for JRiver... I help keep the forums safe from "male enhancements" and other sources of sketchy pharmaceuticals.

Windows 11 24H2 Update 64-bit + Ubuntu 24.10 Oracular Oriole 64-bit (AMD 7900X CPU/AMD 7800 XT GPU/64GB RAM/2TB M.2 NVMe SSD)
macOS Sequoia 15.3.2 (M4 Mac Mini 16GB RAM/256GB SSD)
Windows 11 24H2 Update 64-bit (Intel N305 Fanless NUC 16GB RAM/500GB M.2 NVMe SSD)
JRiver Media Center 33 (Windows + Mac + Linux) | iFi ZEN DAC 3 | JBL 306P MkII Studio Monitors | Audio-Technica ATH-M50x Headphones

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42742
  • Shoes gone again!
Re: Search expression to find words starting with lowercase letters?
« Reply #4 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.
Logged
Matt Ashland, JRiver Media Center

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42742
  • Shoes gone again!
Re: Search expression to find words starting with lowercase letters?
« Reply #5 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.
Logged
Matt Ashland, JRiver Media Center

Cmely

  • Junior Woodchuck
  • **
  • Posts: 82
Re: Search expression to find words starting with lowercase letters?
« Reply #6 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 ?
Logged

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42742
  • Shoes gone again!
Re: Search expression to find words starting with lowercase letters?
« Reply #7 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?
Logged
Matt Ashland, JRiver Media Center

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42742
  • Shoes gone again!
Re: Search expression to find words starting with lowercase letters?
« Reply #8 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.
Logged
Matt Ashland, JRiver Media Center

Cmely

  • Junior Woodchuck
  • **
  • Posts: 82
Re: Search expression to find words starting with lowercase letters?
« Reply #9 on: January 25, 2017, 10:08:17 am »
 :o

I can say only one thing : Bravo !!!
Logged
Pages: [1]   Go Up
« previous next »