1 Reply Latest reply: May 15, 2014 10:09 AM by thompssc _ RSS

    Monarch (If statement)

    samoore _

      I have a quick question that I need assistance. I have an if statement that I need to apply to a model in Monarch. I have different groups some start with FD but I want to remove the FD if applicable on some groups not on all and pull the 3 and 4 character of the string. I have the if statement working in excel and access but there is not a mid function in Monarch. Here’s the statement.

       

      =IF(LEFT(GROUP,2)="FD",MID(GROUP,3,2),LEFT(GROUP,2))

       

       

      How would I write this in monarch since mid is not a choice?

       

      Please advise.

       

      Thanks.