Convert to Upper Case Letter

[Former Member]

Hi,

I am pulling Material Number from Legacy system.

Ex: 123_a56..

I need to convert small characters to Upper Characters...

Expeted O/P shoudl be 123_A56....Could you please help me.

Regards.

[Former Member · Accepted solution]

Hi,

For that column in Query Transformation user this function code 

upper(Column_name) that's it. it convert all characters to Upper case

[Former Member]

Hi,

Do the mapping as below:

upper(column_name)--this can convert all char from lower to upper.

[former_member1157950]

Hi,

You can use a case converter for this task. For example this one.

Good luck!

[tharaka_fernando]

Hi Chaitanya,

If you can write an ABAP code , plz enter following,

data : material_output type string.

material_output = material_input.

TRANSLATE material_output TO UPPER CASE.

Thanks

Tharaka

[Former Member]

Hi,

I am looking for code in Data Services (BODS)

Regards.

[Former Member]

Hi,

Do the mapping as below::

upper(COLUMN_NAME)-- this can convert all char from lower to upper.