Skip to Content

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

Modify signeddata in a Trans/conv file

Hi all,

I need to upload some information to the system that is stored in a flat file. the input file before any transformation is this:

ENTITY;CECO;ACCOUNT;TIME;CATEGORY;SIGNEDDATA

250;25000000;621300000;20121200;0;370.591,25

I am configuring the transformation like this:

DELIMITER=;

AMOUNTDECIMALPOINT=,

As you can see, the problem comes with the point in the signeddata value (signeddata=370.591,25) the system does not understand that sign so it throws an error ("SIGNEDDATA:370.591,25 is not a valid format data"). If I manually remove the point before uploading, it works fine, so the solution should be to remove that point.

I thought to use a conversión file to manipulate the value so I can remove that sign. At this point, I have some questions:

1) Is it possible to use JS in a conversion in the Microsoft platform? I read that is not possible to use it but I did not find any "official" text of SAP talking about this point. if I can use it, I think this should work: "JS:Number(Value.toString().replace(".",""));"

2) If I can't use JavaScript, I think I can use VB but reading the conversion file documentation I read this ("While VBA can be used successfully in some instances, we cannot guarantee it will work with BPC for Excel") so I don't know if this gonna work.

Any ideas of how can I remove that point in the conversion or transformation file?

Regards

Tags:
Former Member
replied

Hi Jose,

MS version does not support Javascript only VB function, use the string functions to clean your string.

You can do it also before to execute the import file.

Regards

     Roberto

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