Problem decimal separator

[Former Member]

Dear all,

I have a decimal number ( precision 5, scale 2 ) that I received in file format output.

The field output data type is numeric ( precision 5, scale 2 ).

I would replace the actual separator ',' by '.'

So I indicate the output format #.##0,0 but nothing change !!

3 questions :

1) I have only 2 output formats available. Can I add more format output myself OR define by default by SAP ?

2) How can I solve my problem WITHOUT change settings parameters from the server ?

3) Is it possible to specify a variable pattern in the concerning worflow ?

Best regards,

[Former Member]

Hi,

Q1) You can use the predefined functions to change the incoming data type to target. I don't think so you can add output format from SAP, but certainly could create custom functions for the purpose.

Q2) Use cast() function to convert the datatype.

Q3) Yes, you can define a variable local and global variable. Is that what you are asking?

Thanks,
Arun

[Former Member]

Hi Arun,

I have used the second default format #,##0.0

It seems that I have already used it before but now it works well.

Best regards,

Michel.