BDC Recording with decimal points in it
I have a requirement in BDC recording.
There is a flat file with values in it.The flat file has currency fields also.
The exact requirement is ; when the value from the flat file is moved to the field in the screen, it needs to be changed in the following manner.
If the value of field is 1000, it will be displaced in the field as 1000, but if the value is 1,000.00 then the value , that needs to be displayed in the field while passing value to the field is 1.000,00 .
So the comma(,) present in the currency field has to be replaced with dot(.).
I tried using offset, like passing that field to a variable.
Splitting that variable into 2 parts and replacing , with . in the first part and . with , in the second part.
But it doesnot work, if the value is a whole number.Ex. 1000 which has no , or . in it.
Points for useful suggestions.
Can anybody provide an useful suggestions.