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.





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


      Please advise.