AnsweredAssumed Answered

Copying each digit from a value and paste on another fields

Question asked by marciotky on Feb 17, 2014
Latest reply on Jul 16, 2014 by KellyFisher

Title

Copying each digit from a value and paste on another fields

Post


     Hey All,

      

     Newbie here. My problem is that I have a total amount (sales) but need to get each digit from that value and copy it to separate fields, one by one. (It is generate from another table with a script button)

     E.g

     Total Sales: ¥25,000 (the value could change from 4 ~ 6 digits)

     Field A: 2

     Field B: 5

     Field C: 0

     Field D: 0

     Field E: 0
      

     I think the solution is the middle, left or right function with the position function. But couldn't find a perfect solution. Any ideas?

      

     Thanks

      

Outcomes