3 Replies Latest reply on Aug 29, 2016 9:59 PM by philmodjunk

    Middle function: Can you get result as number?

    tays01s

      I'm using middle function, within a script, to extract a character that is then to be used in a calculation. However, the dialogue informs me that the result must be 'text', even though the original field it is extracting from is a number. I should mention that the said number field was itself produced using the middle function to extract characters from another text field.......though I didn't think there is 'residual' effect.