topic Re: Convert to upper case in Application Development and Automation Discussions

Convert to upper case

Former Member — Tue, 22 May 2007 05:57:11 GMT

I need to convert certain fields from an upload file into upper case.

Any pointers as to how this can be done. Thanks.

Former Member — Tue, 22 May 2007 05:58:32 GMT

Use the command

TRANSLATE <field> to LOWERcase/Uppercase.

Reward points if useful

Regards

Anji

Former Member — Tue, 22 May 2007 05:58:59 GMT

store the file into an internal table using GUI_UPLOAD

then

loop at itab into wa_itab.
 translate wa_itab-field1 to upper case.
 modify table itab from wa_itab transporting field1.
endloop.

Former Member — Tue, 22 May 2007 05:59:06 GMT

hi ,

Once you get them into your internal table do like following.

Translate <field> to UPPER CASE.

regards

sarath

Former Member — Tue, 22 May 2007 06:00:06 GMT

w_text(10) type c Value 'shardul'.

translate w_text to upper case.

write: w_text.

Former Member — Tue, 22 May 2007 06:06:40 GMT

U can try it using the TRANSLATE statement

data : TEXT(10) type C.
data : T(10) type C.
TEXT = 'gopi'.

move TEXT to T.
translate T to upper case.
write : T.

Former Member — Tue, 22 May 2007 06:07:55 GMT

Hi,

You can use the TRANSLATE to transalte the field to either upper or lower case.

Reward pointsif it is helpful.

Regards,

Sangeetha.a

Former Member — Tue, 22 May 2007 06:11:36 GMT

hi,

u can use transalte command to convert into upper/lower case. as

loop at itab.

TRANSLATE itab1-fld1 TO LOWER/UPPER CASE.

modift itab1 index sy-index.

endloop.

if helpful reward some points.

with reagrds,

suresh babu aluri.