Skip to Content
0
Jan 22, 2016 at 01:58 PM

how to remove the "SHIFT ENTER" Character in BW Transformation

452 Views

Hi, i need to remove that "Enter" from a record storaged in BW

the sentence in the record is exactly like this:

"2015 Legal fees Outplacement consultancy services"

it shows in one line, but it contains the 2 "enters" characters (CR LF in word)... when i extract the data from ZPA to Excel, it shows exactly like this

"2015

Legal fees

Outplacement consultancy services"

and it doesnt fail until i tried to activate the data in the DSO.

i do search in the forum and see the same thing, but the solution doesnt work for me... it was to set this line in the transformation just before de DSO.



REPLACE ALL OCCURRENCES OF CL_ABAP_CHAR_UTILITIES=>CR_LF(1) in NAME with space.

tryed that, but the error is still going on,

"Message no. BRAIN315

Diagnosis

Characters that have a hexadecimal display between HEX00 and HEX1F are not permitted in characteristic values. The character at position 5 is one of these characters. The value is therefore not permitted.

Note that these characters cannot be displayed and are therefore displayed as #. The actual character # has the hexadecimal display HEX23."