Skip to Content
0
Former Member
Jun 03, 2008 at 07:30 AM

how to CHECK WHETHER LOWER CASE OR UPPER CASE IN CUSTOM TABLE

992 Views

Dear Friends,

I have a requirement where from the flat file i have collected into the internal table is as below :

IDNo. Name Date Location Designation Dept

101 raja 4/12/2007 Delhi manager HR

102 james 4/12/2007 Delhi clerk HR

now iam checking against my custom table where iam if the designation for the employee name already exists then i shouldnt modify/update the custom table that record

now iam facing a problem where is the flat file is always having the Lower Case only ,

as per the scenario if my custom table already have the employee name i shouldnt modify/update i.e i shouldnt overwrite,

this scenario is working but it is failing in the case

by chance in the Custom table the employee name or designation is in Upper Case the condition where iam checking in the code is failing as the flat file data coming into the internal table is having always lower Case.

So could any one please let me know how i should check in my custom table whether iam having upper case or lower case and how can i make it lower case ?

because iam able to manage in the case where if the flat file data coming in Upper case i can check before only by

using Translate to lower case . how i unalbe to check for the data coming from the Custom table if in Uppercase , so i want to change that to lower case then checking my condition whether that data already exists in my custom table before modifying the data coming from the flat .

because the condition is failing when the data in the custom table is in upper case and the Flat file data is in lower case.

please help how i can check for the data in the Custom table is in upper case and then change it to lower case.

Regards

Madhuri.