Lantica User Forum - Search for lower-case text?

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Search for lower-case text?

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: 1

Send Topic

Print

Normal Topic

Search for lower-case text? (Read 861 times)

Infinity Senior Member Members Offline Diagonally parked in a parallel dimension Posts: 1290 Location: Massachusetts Joined: May 27^th, 2005	Search for lower-case text? Sep 14^th, 2007 at 3:35pm	Print Post
	Is there any way to search text elements for lower case text?

	** Captain Infinity
	WWW IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Search for lower-case text? Reply #1 - Sep 14^th, 2007 at 3:38pm	Print Post
	Just any lower case text or particular lower case text? -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Infinity Senior Member Members Offline Diagonally parked in a parallel dimension Posts: 1290 Location: Massachusetts Joined: May 27^th, 2005	Re: Search for lower-case text? Reply #2 - Sep 14^th, 2007 at 3:52pm	Print Post
	Any instance of lower case in the element. My Invoices have two elements which record the Invoice creator's userid and the salesman's ID. I've formatted the elements so they display as uppercase on the screen, but lower case values are still maintained in the underlying database. They need to print in upper case, which isn't happening; the Printstring command prints the data exactly as stored in the database.

	** Captain Infinity
	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Search for lower-case text? Reply #3 - Sep 14^th, 2007 at 4:24pm	Print Post
	Use ToUpper in your PrintString command to force the values to uppercase before printing.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Infinity Senior Member Members Offline Diagonally parked in a parallel dimension Posts: 1290 Location: Massachusetts Joined: May 27^th, 2005	Re: Search for lower-case text? Reply #4 - Sep 14^th, 2007 at 4:30pm	Print Post
	OK, I'll do that. Actually, I think I'll program on-element-change to do it so it's saved the way I want. But I take it that specific case searches are not possible?

	** Captain Infinity
	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Search for lower-case text? Reply #5 - Sep 14^th, 2007 at 4:46pm	Print Post
	Infinity wrote on Sep 14^th, 2007 at 4:30pm: OK, I'll do that. Actually, I think I'll program on-element-change to do it so it's saved the way I want. But I take it that specific case searches are not possible? If you precede the search criteria with a backtick, it will be case-insensitive. For example, the below will find any value with a lower case vowel. `..a..;..e..;..i..;..o..;..u..

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Infinity Senior Member Members Offline Diagonally parked in a parallel dimension Posts: 1290 Location: Massachusetts Joined: May 27^th, 2005	Re: Search for lower-case text? Reply #6 - Sep 14^th, 2007 at 4:55pm	Print Post
	FANTASTIC! Thanks!

	** Captain Infinity
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Search for lower-case text? Reply #7 - Sep 14^th, 2007 at 5:52pm	Print Post
	Is there a RegEX upper/lower case filter in Sesame 2.0 ?

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Search for lower-case text? Reply #8 - Sep 14^th, 2007 at 6:11pm	Print Post
	Bob_Hansen wrote on Sep 14^th, 2007 at 5:52pm: Is there a RegEX upper/lower case filter in Sesame 2.0 ? At the moment, regex searches are not case sensitive. We may provide an option to make them so in an upcoming release.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Page Index Toggle

Pages: 1

Send Topic

Print

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top

Top

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid XHTML

Valid CSS

Powered by Perl

Source Forge