Customer Portal

Switch-Case Statements in CloverETL using Regular Expression

Comments 1

  • Avatar
    admin
    0
    Comment actions Permalink
    Hi jed_urETLguy,

    I would cut out the number in parenthesis by CTL2 code:


    string input = "(3) 2 EA OF SKU - PP01";
    string nr = input.find("(?:([0-9]+))")[0];
    //nr == "3"


    Then convert it into integer and use in case statement.

Please sign in to leave a comment.