9 Replies Latest reply on Apr 16, 2019 12:37 AM by Naveen B

    extract values of a String

    Patrick Weber

      Hi everyone,


      I have an issue to extract all percentage values of a string (see my workbook example).

      At first I created a calculation which will show me if there's cashback or not.



      Now I need another calculation  called "cashback value" which is able to show only the values 2%, 5% and 3% like in this table here:



      C Id
      cashback value
      130 days after invoice, 2% cashbackY0.02
      2prepayment, 5% cashbackY0.05
      320 days after invoiceN
      4prepayment, 3 days after order dateN
      515 days after invoice, 2.2% cashbackY0.022


      Thanks for any advice.