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?