topic Re: String comparison, case insensitive in Application Development and Automation Discussions

String comparison, case insensitive

matteo_montalto — Wed, 17 Jun 2009 13:16:02 GMT

Hi all experts,

I have a field, let's say SHORTTXT, which is a STEXT field that contains name and surname of a person; the order in which these two information are present in the string is not known a priori, and also the case should be irrelevant.

Now; given two field, say NAME1 and NAME2, I'd like to express the following condition, that should be case insensitive:

if NAME1 and NAME2 are both substrings of SHORTTXT....

What's the correct way to express this condition? Which cmp operator should I use? The 'contains' one seems to be case sensitive....

Re: String comparison, case insensitive

Former Member — Wed, 17 Jun 2009 13:20:18 GMT

Hi,

Use the 'Contains String' i.e. 'CS' operation... If it doesnt work you can use 'TRANSLATE' first and then do the comparision..

Re: String comparison, case insensitive

matteo_montalto — Wed, 17 Jun 2009 13:22:22 GMT

sneha, CS is case-sensitive.

'ABcdEF' CS 'CD' returns false. That's not my desiderata. Thanks anyway

Re: String comparison, case insensitive

Former Member — Wed, 17 Jun 2009 13:23:08 GMT

HI,,

IF SHORTTXT CS NAME1 and SHORTTXT CS NAME2

endif.

Thanks

Sudheer

Re: String comparison, case insensitive

Former Member — Wed, 17 Jun 2009 13:23:59 GMT

This also is a pretty basic question - you have to translate both to the same case.

Rob

Re: String comparison, case insensitive

Former Member — Wed, 17 Jun 2009 13:24:19 GMT

Hi Matteo,

That is what i said... If it doesnt work please 'Translate' it to your desired forrmat and then check it..

Re: String comparison, case insensitive

former_member212005 — Wed, 17 Jun 2009 13:25:19 GMT

Use translate statement

Re: String comparison, case insensitive

matteo_montalto — Wed, 17 Jun 2009 13:30:54 GMT

Thanks to you all, I thought there was a way to compare strings in a case-insensitive mode, anyway the suggested solution works as well.

Re: String comparison, case insensitive

Former Member — Wed, 17 Jun 2009 13:31:16 GMT

You don't have to translate.

'ABcdEF' CS 'CD'

returns true in my program.

Re: String comparison, case insensitive

Former Member — Wed, 17 Jun 2009 13:44:27 GMT


> You don't have to translate.

Yup - seems to be true. But case sensitivity is a consideration in SELECTs. I guess that's what we were thinking.

Hat's off to you

Rob