Unable to interpret a mapping description

[Former Member]

Please try to interpret the following mapping description:

if (substring-before(NET__SALES__VALUE(L1),'.')="-0") then

pad-front(concat('-',pad(trim(substring-after(NET__SALES__VALUE(L1),'.')),'2','0')),10,0)

else

pad-front(concat(substring-before(NET__SALES__VALUE(L1),'.'),pad(trim(substring-after(NET__SALES__VALUE(L1),'.')),'2','0')),10,0)

Thanks,

Ramya

[Former Member · Accepted solution]

Shenoy,

On a high level roughly what I understand is you are getting a value and checking before the decimal has - symbol (like if -0.00). If yes then you are taking substring after decimal and padding up with zeros for 10 digit length.

Regards,

---Satish

[VijayKonam]

Hi Ramya,

Best thing would be to exceute those steps manually on paper if you have some sample data. They seem to nested in complex way and not easy to understand by someone who does not know about the kind of data it manipulates.

VJ