AnsweredAssumed Answered

Middle function: Can you get result as number?

Question asked by tays01s on Aug 29, 2016
Latest reply on Aug 29, 2016 by philmodjunk

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.