Replace Special Character using conversion file

[former_member233993]

Hi Gurus,

We are loading the data from flat file.  The data in one column say for Account comes with special characters ex ACCT123.$, I would like to convert it to ACCT123 (remove .$).

Tried using the conversion file for Account with below combinations

External	Internal
*.$	*
*.$	js:%external%.replace(".$","")
*.$	js:%external%.toString().replace('.$','')
*.$	RG_TEST

However, it doesn't work.  It doesn't convert to "RG_TEST" as well.  It throws an error for ACCT123.$ doesn't exists in ACCOUNT dimension.

Looks like it doesn't recognise $ in External column.

We are on BPC 10NW SP6 on HANA

HANABPC SP4

SAP BW 7.31 SP8

Please suggest.

Let me know if you need more information.

Regards,

Rashmi

[former_member186338 · Accepted solution]

Try:

js:%external%.toString().replace(/\.\$/g,"")

Vadim