BusinessObjects Board

replace special or control character from columns

dataservices job design
#1

Hi
I want to subsitute certain control character from description. I am trying to replace char(26) from description with ‘rr’. but this code is not working.

substr( Description,chr(26),‘rr’)

char(26) is ASCII code for square shape special character

any clue how to find and replace special char from columns

thanks in advance

GBS74 (BOB member since 2007-01-23)

#2

Where do you see the Square Characters? It may not be really a square! If this is Microsoft SQL Server, it usually displays junk characters in that Square or for that case SAP also…

Let me know where you do see the boxes

ganeshxp :us: (BOB member since 2008-07-17)

#3

@GBS74.

Search is your friend…

e.g. https://bobj-board.org/t/212873

Darth Services :uk: (BOB member since 2007-11-20)