Skip to Content
avatar image
Former Member

Removal of commas when extracting Master Data to File

Hi,

I want to extract SAP BW master data to file but make sure commas are removed from any text. Otherwise the file which which has comma delimiters would be incorrect.

I am using "js: %external%.toString().replace(/,/g,"")" in the conversion file in EXTERNAL column. INTERNAL is set to "*",

I refer to the conversion file in the transformation file

"DESCRIPTION=EXCL_COMMAS.xls"

Doesnt seem to work.


Any ideas?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 28, 2015 at 12:55 PM

    And the correct JavaScript syntax to remove comma's will be:

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

    You have to use "\," instead of ","

    Vadim

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 28, 2015 at 12:52 PM

    Hi Leo,

    Strange idea "Otherwise the file which which has comma delimiters would be incorrect." - use file with TAB delimiter 😊

    Vadim

    Add comment
    10|10000 characters needed characters exceeded