Handling Special Characteristics in sap bods, Using Functions.

[Former Member]

Hi ,

I'm facing a different characters( example like reverse Question mark), How to handle multiple special characters or Images in sap bods. Is there any Functions to handle this??

Please help me.

[former_member187605]

There's no need to write a custom function for standard DS functionality!

regex_replace(<input_string>,'\[^a-z0-9\]','', 'CASE_INSENSITIVE')

will remove all non-alphanumeric characters from the input string.

[rajan_burad]

Hello Krish,

This link can be of some help to you:

https://blogs.sap.com/2014/03/25/custom-function-in-bods-to-remove-special-characters-from-a-string/

Thanks!

[former_member198401]

Krish

Kindly provide us more inputs. Whats the Source database and Target database?

What is the code page set in the Target database Datastore? Also check the characterset of your target database. Are you able to see thequestion marks and other characters in database tables also?

Regards

Arun Sasi

[Former Member]

Thanks Arun,

Source and destination both are Oracle DBs,I checked Character-set in both sides,Different character-set are there.But we can't change the character-set because so many things are connected with the DBS. So we need to handle Through BODS.

Thanks in Advance..

[former_member208402]

You have to write custom function to eliminate special characters.

[Former Member]

Dear Ravi,

Can you explain,How to create Custom function to handle SPS.

Thanks in Advance..