Formaula not workingREPLACE_ALL( '#', '', TOUPPER( FLDname ) )

[Former Member]

Hi,

Can you help me on executing to formalas in one transformation.

I want to replace # with '' and change all lowercase characters into upper.

So I wrote the formua like this

REPLACE_ALL( '#', '', TOUPPER( DEALNAME ) )

but unable to activate it. Please suggest me on it.

[Former Member · Accepted solution]

Hi Kaveri,

REPLACE_ALL seems to be method of a class..

Eg:

call method textedit- >replace_all

exporting

case_sensitive_mode = case_sensitive_mode

replace_string = replace_string

search_string = search_string

whole_word_mode = whole_word_mode

changing

counter = counter

exceptions

error_cntl_call_method = 1

invalid_parameter = 2.

can you try using this way..

declare rule(20) TYPE c VALUE '#"'

TRANSLATE <b>DEALNAME</b> TO UPPER CASE.

TRANSLATE DEALNAME USING rule.

not sure if thisis what you are looking for..

Regards

Manga

[Former Member · Accepted solution]

I tried in above ways, but not worked

Can you suggest me on how to load '#' from datasource to datatarget.

Now I am un able to load this character into datatarget amd giving # as invalid characters.

Message was edited by:

Kaveri

[Former Member · Accepted solution]

did you try this way:

declare rule(20) TYPE c VALUE '# " ' ( open single quote have <u><b>#</b></u> and <u><b>"</b></u> without any space between them and close single quote)

[Former Member · Accepted solution]

declare rule(20) TYPE c VALUE '# " '

I worte the above code on the formula but shown it as error

Please suggest me on writing 2 formaulas in one transformation rule.

Message was edited by:

Kaveri

[Former Member · Accepted solution]

as mentioned no space between..

declare rule(20) TYPE c VALUE '#"' <b>( open single quote have # and " without any space between them and close single quote)</b>

null

[Former Member]

Please try putting <b>DEALNAME</b> in single quotes

[Former Member]

They are two different ABAP key words.

Keep it in 2 diff lines in transformation.

Ravi Thothadri