Removal of commas when extracting Master Data to File
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
Doesnt seem to work.
Vadim Kalinin replied
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!!!