topic Re: Case-Sensitive in Application Development and Automation Discussions

Case-Sensitive

Former Member — Wed, 20 Dec 2006 09:49:05 GMT

Dear All,

In the input I am having Customer Name & Material Description. So, when I enter Customer Name or Material Description in the input then it should not be 'case sensitive' ie. it should display result even though the text is entered in Caps or in small alphabets.

Thanks in advamce.

Warm regards,

nishu

Re: Case-Sensitive

athavanraja — Wed, 20 Dec 2006 09:58:12 GMT

how thes texts are stored in database, mixed case? or upper case.

if upper case, convert your input to upper case and use it for select

Re: Case-Sensitive

Former Member — Wed, 20 Dec 2006 09:58:55 GMT

i think Selection is not case sensitive.

it will convert all to uppercase and check

Re: Case-Sensitive

Former Member — Wed, 20 Dec 2006 09:59:13 GMT

TRY TO USE

TRANSLATE c TO UPPER CASE.

REGARDS

SHIBA DUTTA

Re: Case-Sensitive

Former Member — Wed, 20 Dec 2006 09:59:31 GMT

Hi Nishu ,

It would be difficult , because it is based on how data is stored in the data base , now consider the scenario of the system i am using , we can material description as 'test' or 'TEST' , 'Test' .

If in your system there are only stored in either caps or small the you can perform the select twice .

But i myself dont find it to be such a good solution , but you can give it a try

There is one more solution specific to material description ,and that is in the table MAKT there is a field MAKTG , which stored the description in uppercase , so for this you can first convert the description to uppercase and then perform select on this field

Regards

Arun

Re: Case-Sensitive

Former Member — Wed, 20 Dec 2006 09:59:39 GMT

Hi ,

Normally selection screen elements take the input in caps .To make it to accept lower case letters we use

SELECT-OPTIONS <seltab> FOR <f> ... LOWER CASE

Regards ,

Senthil

Message was edited by: Senthil

senthil kumar

Re: Case-Sensitive

Former Member — Wed, 20 Dec 2006 10:00:08 GMT

Hello,

Use Translate var to UPper case.

or Translate var to lower case.

If useful reward.

Vasanth

Re: Case-Sensitive

Former Member — Wed, 20 Dec 2006 10:03:49 GMT

Hi,

Use translate statement to convert Upper case or Lower case

Regards,

Balavardhan.K

Re: Case-Sensitive

Former Member — Wed, 20 Dec 2006 10:33:51 GMT

Hi All,

In the database text is stored in mixed formats ie. in uppercase, in lower case & some with both upper & lower case.

Warm regards,

Nishu

Re: Case-Sensitive

Former Member — Wed, 20 Dec 2006 10:36:43 GMT

Hi,

First select the data with Upper case if it is not satisfied try with Lower case.

Regards,

Balavardhan.K

Re: Case-Sensitive

athavanraja — Wed, 20 Dec 2006 11:11:32 GMT

if the data is stored in mixed case in the database, the only option out is to read all the texts into a internal table convert them all the upper case, convert the user entered value into upper case and then do the search.

unfortunately this is the only way out.

Regards

Raja

Re: Case-Sensitive

Former Member — Wed, 20 Dec 2006 11:30:56 GMT

ok try like this

first translate the text in lower case to a variable1.

then translate the text in uppercase to variable2.

now take the value in your select-option-low and high and option BT sign I

append that in your select option.

now pass that to select statement.

I am not sure whether it will work or not..

regards

shiba dutta

Re: Case-Sensitive

Former Member — Wed, 20 Dec 2006 11:32:45 GMT

what ever u enter in selection screen internally it takes as UPPER CASE and then fetches data relevant to it.

Re: Case-Sensitive

athavanraja — Wed, 20 Dec 2006 11:38:45 GMT

nishu,

dont get confused.

whatever you enter in the selection screen will get converted to uppercase, if the addition lower case is not added to the parameter declaration.

in your case as you want the user to have the ability to enter mixed case words declare a parameter with the addition lower case.

and again i reiterate the only option left is to get all the texts convert them to upper case, convert the entered text to upper case and do a search,.

if you follow the method shiba suggested, it will not work in the following case.

for example.

data stored in the database is = myName

user enters = Myname

if you convert this to upper case = MYNAME

and use the user entered mixed case = Myname

your selecte wont find myName at all.

Regards

Raja

Re: Case-Sensitive

Former Member — Wed, 20 Dec 2006 11:42:56 GMT

Hi,

Can u give me what tables ur using.

Regards,

Balavardhan

Re: Case-Sensitive

Former Member — Wed, 20 Dec 2006 13:31:08 GMT

Hi All,

Thanks for ur valuable replies.

For Material Description now I have used the table MAKT-MAKTG where all descriptions are in Caps.

Is there any table where Customer Number is stored in Caps??

Warm Regards,

Nishu

Re: Case-Sensitive

Former Member — Wed, 20 Dec 2006 13:37:42 GMT

Hi ,

Do you want customer number or customer name .

If it is customer number , then i feel it is always stored in CAPS, so you do not need to bother about it.

Please check it and revert back in case of any queries.

Regards

Arun

Re: Case-Sensitive

Former Member — Thu, 21 Dec 2006 12:59:20 GMT

Customer Name is alsoc there in table KNA1 in Upper Case

Re: Case-Sensitive

Former Member — Thu, 21 Dec 2006 13:45:56 GMT

Hi,

Yes the customer name will not always be in KNA1 table in upper case , it can be in mixed format also.

Regards

Arun