Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

Former Member
replied

Hi Leo,

The sample I provide in my previous post was tested on the real system! Please, reproduce it with just 2 fields - ID and EVDESCRIPTION. Provide all screenshots! (transformation file, conversion file, export result...) If it's not working - then there is something wrong.

"Do i just change the DELIMITER = TAB and the OUTPUTDELIMITER=TAB too?" - the key is OUTPUTDELIMITER, you are exporting data!!!

Pipe: OUTPUTDELIMITER=|

Vadim

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question