6 Replies Latest reply: Feb 24, 2017 11:32 AM by swana woo RSS

    data go wrong in dual()

    swana woo

      for the table that has money variable that has different currencies for each value.


      I loaded table with the sentences below.



           money,//text that contains currency symbol and ,(comma)

           PurgeChar(money,'0123456789,') as Currency_Symbol,

           Dual(money, Num(PurgeChar(money,'$€£RCHF₹¥₩kr'))) as money_dual

      Resident Temp;


      The correct value from Temp is money text column, and extract Currency_Symbol correctly, but in money_dual column some of the value go wrong...(except dollar sign$)