topic Re: Help String Function To Upper in Application Development and Automation Discussions

Help String Function To Upper

Former Member — Mon, 23 May 2005 09:46:37 GMT

Hi guys,

I want to edit a string by using a function like UpperCase or LowerCase. Is there any function in ABAP which has the same functionality?

next problem is:

Can i use this function in an SQL query?

Like: Select SINGLE IDSEGMENT

FROM Table

INTO IDSEG

WHERE Upcase(string1) = Upcase(string2).

Is this possible?

Problem is that in the DB the string1 is spelled different (capital letters) than string2

Re: Help String Function To Upper

Former Member — Mon, 23 May 2005 09:50:07 GMT

Hi,

Try this out

*Code to demonstrate TRANSLATE to UPPER/LOWER CASE command

*----

DATA: ld_char(20) type c.

ld_char = 'Hello World'.

TRANSLATE ld_char TO UPPER CASE. "Result: ld_char = 'HELLO WORLD'

TRANSLATE ld_char TO LOWER CASE. "Result: ld_char = 'hello world'

See this link

http://help.sap.com/saphelp_46c/helpdata/en/fc/eb33a5358411d1829f0000e829fbfe/frameset.htm

Thanks & Regards,

Judith.

Re: Help String Function To Upper

Former Member — Mon, 23 May 2005 09:52:28 GMT

Thanks Judith,

but this was only my first problem,

any proposal for my second problem?

Re: Help String Function To Upper

andreas_mann3 — Mon, 23 May 2005 09:56:40 GMT

Hi Marcus,

Translate str to upper case.

Select SINGLE IDSEGMENT

FROM Table

INTO IDSEG

WHERE string = str.

Regards Andreas

Re: Help String Function To Upper

Former Member — Mon, 23 May 2005 09:58:28 GMT

Ok. But how can i translate the variable string?

I want both variables (str & string) to translate to upper case!

How about that?

Re: Help String Function To Upper

Former Member — Mon, 23 May 2005 10:01:16 GMT

Hi,

U cant use <b>Upcase</b>(string1) = <b>Upcase</b>(string2) in select query.

Can compare two strings thats all.Try removing that upcase and check.

Thanks & Regards,

Judith.

Re: Help String Function To Upper

Former Member — Mon, 23 May 2005 10:01:54 GMT

Thanks but how u would solve this problem?

Re: Help String Function To Upper

Former Member — Mon, 23 May 2005 10:12:07 GMT

Hi Marcus,

Select your database table data into an internal table and use the FIND command.

You can then use the ignoring case keyword.

If less than basis 6.1 you can use SEARCH (but may have to convert internal table to uppercase before searching).

Cheers,

Brad

Re: Help String Function To Upper

Former Member — Mon, 23 May 2005 10:17:54 GMT

Actually,

FIND doesn't really support internal tables, and SEARCH doesn't have IGNORING CASE.

So you'll have to make a trade off between looping through your internal table and using FIND, or translating the internal table to uppercase and using SEARCH.

I think I'd go for looping through your table and using FIND.

Brad

Re: Help String Function To Upper

Former Member — Mon, 23 May 2005 10:22:43 GMT

Hi,

Use the string comparision operator CS in your select query which is not case-sensistive.

Regards,

Vijay S

Re: Help String Function To Upper

Former Member — Mon, 23 May 2005 11:19:07 GMT

Thank you all for ur answers.

I solved the problem with the solution from Vijayakrishnan.

Regards,

Marcus Pohl

Re: Help String Function To Upper

Former Member — Mon, 23 May 2005 11:29:46 GMT

Thank you all for ur answers.

But CS isn´t a valid comparison

Regards,

Marcus Pohl

Re: Help String Function To Upper

Former Member — Mon, 23 May 2005 11:32:59 GMT

Hi,

Try using LOWER(string1) = string

Also u can compare UPPER(string1) = String.

Like this convert anyone of teh string to the other and try it out.

Thanks & Regards,

Judith.

Re: Help String Function To Upper

Former Member — Mon, 23 May 2005 11:33:10 GMT

I didn't think so...

I think you are stuck with the internal table approach.

Brad