Conversion of Special symbol description from BW to BPC

[Former Member]

Hello Team,

I am trying to eliminate special symbols while loading description from BW to BPC. I would like to replace the symbol <(> with a blank "".

I am using the transformation file :

Conversion section :

ID= Description.xls

Maintained a conversion file named Description with the following syntax:

Internal = *

External =

js:%external%.toString().replace(/<)>/g,"")

However the transformation file is not fetching the conversion file.

Regards,
Bharadwaj Cheruvu.

[former_member186338]

Ups, now I understood what are you trying to achieve!

The whole discussion will be very short if you provide full transformation file 🙂

There is no way to perform conversion of the description of some member from BW (only language selection)!

Only ROUTINE badi will help you.

[former_member186338]

P.S. What aboud ID length? Max 32 allowed!

[Former Member]

Hi vadim,

No. I'm not referring to ID of the dimension. I am fetching the description of the dimension from BW Long Text.

Does ID = Description. xls in the conversion section of the transformation file would convert the text description or should I give Description= Desciption.xls?

Regards,

Bharadwaj Cheruvu.

[former_member186338]

First - having "&" in member ID may result in errors with some script logic code. "&" is not listed as invalid character for member ID's but is listed as invalid character for dimension name. I recommend replacement to "_"

Tables:

The code without "&" replacement will be: js:%external%.toString().replace(/[\<\>\(\)]/g,"")

Second - if you load data from BW then in transformation file the separator has to be TAB!

[Former Member]

Hi vadim,

Thanks for your response. However, the requirement is to retain the & symbol which is coming from ECC. These special symbols(<>) are observed only in BW and not in ECC. Eventually, need to eliminate using a conversion in BPC.

Also not able to fetch the description after the comma separation. Is there any possible way to achieve this using conversion instead of changing the delimiter in transformation file.

Regards,

Bharadwaj Cheruvu.

[former_member186338]

P.S. Can you show your full transformation file an selection screenshots?

[former_member186338]

With "&" replacement to "_"

js:%external%.toString().replace(/[\<\>\(\)]/g,"").replace(/\&/g,"_")

[former_member186338]

In general you need to remove the following special characters: "<",">","(",")","&"

You have to use regular expression with escape symbol "\"

js:%external%.toString().replace(/[\<\>\&\(\)]/g,"")

[] - list of symbols

\< - escaped <, etc...

Also in transformation file provide tab name in conversion file if you have more then one tab:

ID= Description.xls!TabName

[Former Member]

Hi Vadim,

No only the special symbols <(> and <)> should be removed. & should be retained.

Regards,

Bharadwaj cheruvu

[former_member186338]

"&" has to be also removed, can result in errors!

Replace it with "_"

[Former Member]

Hi Vadim,

Here is the screenshot from Text table.

Regards,

Bharadwaj Cheruvu.

[former_member186338]

By the way, I see also "&" special symbol that has to be removed from member ID!

[former_member186338]

Please show screenshot of BW data with special symbol!