topic Re: Upper and lower case conversion in Application Development and Automation Discussions

Upper and lower case conversion

Former Member — Tue, 03 Oct 2006 09:16:26 GMT

Hi,

I need small help on conversions.

I need to convert the data in database tables to lower case.

Like i need to pick some data from a database table. The data stored in the database table is in uppercase. Here i need to convert the data to lowercase through the select statement. Is there any way to do this.

Regards,

Ram

Re: Upper and lower case conversion

Former Member — Tue, 03 Oct 2006 09:18:04 GMT

U can read the data from the table...convert to lower case and modify the table again.

TRANSLATE lchr TO LOWER CASE.

--> I hope you dont have to translate the key fields even in that case u would need to delete the record and insert.

Message was edited by: Anurag Bankley

Re: Upper and lower case conversion

anversha_s — Tue, 03 Oct 2006 09:19:17 GMT

hi,

us this.

transalate <field> to lower case.

similarly u can convert to upper case.

rgds

anver

pls mark hlpful answers

Re: Upper and lower case conversion

Former Member — Tue, 03 Oct 2006 09:20:35 GMT

loop at <internal_table> into <work_area>.
  TRANSLATE <work_area-field_name> to LOWER CASE.
  MODIFY <table> from <work_area>.
endloop.

Re: Upper and lower case conversion

Former Member — Tue, 03 Oct 2006 09:21:11 GMT

Hi,

Before i execute the select statement i need the data to be converted to lowercase.

The thing is i can do the conversion after the select statement. Here i need to get some data from select statement and from the data we get here i need to write one more select statement which also to be displayed lowercase data.

Regards,

Ram

Re: Upper and lower case conversion

anversha_s — Tue, 03 Oct 2006 09:23:23 GMT

hi ram,

one way.

before inserting to db, u can convert the data to lower case.

rgds

anver

Re: Upper and lower case conversion

Former Member — Tue, 03 Oct 2006 09:24:36 GMT

Hi,

just write 2 select statements in that case.

After the first select you modify the data in the

table then select the changed data.

Re: Upper and lower case conversion

Former Member — Tue, 03 Oct 2006 09:30:38 GMT

Hi,

Here is my code..

SELECT addrnumber name1 city1 FROM adrc INTO TABLE i_adrc

WHERE name1 IN r_name1 AND city1 IN r_city1.

IF i_adrc IS NOT INITIAL.

SELECT kunnr adrnr brsch bran1 land1 INTO TABLE i_kna1

FROM kna1 FOR ALL ENTRIES IN i_adrc

WHERE adrnr = i_adrc-addrnumber AND

brsch IN r_brsch AND

bran1 IN r_braco AND

land1 IN r_land1.

Here after the first select statement i am not getting the required data as name1 is maintained in Uppercase in the database. SO i need to change the data to lowercase before the select statement itself.

regards,

Ram

Re: Upper and lower case conversion

Former Member — Tue, 03 Oct 2006 09:36:37 GMT

I think the best way is to convert the data in your range r_name1 to uppercase and fetch the date from adrc table.

loop at r_name1.

translate r_name1-low to upper case.

translate r_name1-high to upper case.

modify r_name1.

endloop.

Re: Upper and lower case conversion

Former Member — Tue, 03 Oct 2006 09:44:23 GMT

Hi,

It not peoblem with the ranges. The data in the database should be made nto lowercase before my select statement so that i will get all the data.

regards,

Ram

Re: Upper and lower case conversion

Former Member — Tue, 03 Oct 2006 09:55:33 GMT

Is your problem that you need to convert the data in ADRC table into lower case OR fetching the data from ADRC ??

Re: Upper and lower case conversion

Former Member — Tue, 03 Oct 2006 09:59:06 GMT

ADRC-Name1 data should be converted to lowercase and need to get the requred data based on the select statement.

Regards,

Ram

Re: Upper and lower case conversion

Former Member — Tue, 03 Oct 2006 10:01:50 GMT

The only way is to do the below before your code...

<b>select name1 into lname1 from adrc.

translate lname1 to lower case.

adrc-name1 = lname1.

modify adrc.

endselect.</b>

Message was edited by: Anurag Bankley

Re: Upper and lower case conversion

Former Member — Tue, 03 Oct 2006 10:07:58 GMT

HI Anurag,

select name1 from adrc.

translate adrc-name1 to lower case.

update adrc.

endselect.

The above statement is giving error as

"Field list without into clause is not allowed. Itab or into(f1....fn) is not allowed..Can you pls correct me.

Regards,

Ram

Re: Upper and lower case conversion

Former Member — Tue, 03 Oct 2006 10:08:29 GMT

Hi,

As far as I understood, Ur problem is getting all the data be it lower case or uppercase in ADRC table for the range...

I think you can try...

Select <fields> from ADRC

where name1 LIKE <range field>.

Thanks,

Rashmi.

Re: Upper and lower case conversion

Former Member — Tue, 03 Oct 2006 10:31:10 GMT

Hi Anurag,

Thanks for the reply.

But its taking much time to execute the select statement. Is there any other simple way of doing this.

Regards,

Ram

Re: Upper and lower case conversion

Former Member — Tue, 03 Oct 2006 10:34:21 GMT

Actually it would as you want to update all the records in ADRC table...I am not sure why you wish to update all the database table records in lower case...you can easily fetch your data if you change the range to use upper case and manipulate the same in report when required.

To change the range check my earlier code and you would be able to get the data.

Re: Upper and lower case conversion

Former Member — Tue, 03 Oct 2006 10:49:11 GMT

Hi ANurag,

Even after changing the range field as you said its giving the data which is in UPPER case for the name1 field. I need all the data for name1 with lower and upper case as well.

Regards,

Ram

Re: Upper and lower case conversion

Former Member — Tue, 03 Oct 2006 10:52:59 GMT

Yes, it would give you in upper case but once you have fetched the data you can convert it into lower case using the TRANSLATE statement.

Second option is when you are updating ADRC do it for the required records only.

Re: Upper and lower case conversion

Former Member — Tue, 03 Oct 2006 11:03:23 GMT

Hi Anurag,

My question is, I have both upper case and Lower case data in ADRC-name1 field. I am searching for some records with string 'good'. Once i execute the select statement its fetching only the Uppercase data. Here i need all the records with upper as well as lower case for 'good' as the string.

I am writing this in function mofdule and so it takes only uppercase search even if we give that in lower case.

Hope you understood my question.

Regards,

Ram