Skip to Content
0
Former Member
Jan 15, 2008 at 10:57 AM

Unable to interpret a mapping description

17 Views

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