5 Replies Latest reply: Aug 20, 2016 7:55 AM by Andrew Walker RSS

    Pattern in logic test

    Łukasz Liziniewicz



      I have a set of data with invoice number (INVOICE_NO) and value (INVOICE_VALUE)

      I need to transform INVOICE_VALUE when the first 3 letters of INVOICE_NO match the pattern (nn/)

      example if INVOICE_NO begins on: 16/ 17/ 99/ 14/ I would like to multiply INVOICE_VALUE by 3.


      any suggestions?