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
      String
      cashback
      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.