blueprism

How to replace string in BluePrism Calculation

Hi How can I replace the month behind to number in calculation?

Example below Jan will be replace with "1" follow by -[number].

26243-Jan --> 1-26243

99-Feb --> 2-99

7328-Mar --> 3-7328

Solution

  • This should do it

    FormatDate("01/" & Right([String], Len([String]) - InStr([String], "-")) & "/2000","MM") & Left([String], Len([String]) - InStr([String], "-"))

    Data Item String is one of your strings.