Skip to main content

Distinguish text from number


1 comment

  • Tiffanie Staver
    John McGarvey commented  ·  

    I don't know if this would help or not (I haven't tried it), but there is a padding function that you can use to add whatever character you want to the left or right of the value in the field.

    If all your lot numbers will never exceed a certain number of characters, you can set a padding of 5 to preface the lot number with whatever you want.

    If using "0" to pad, Lot 100 becomes 00100. Lot H1 becomes 000H1.

    This looks to be the same thing you are doing with your If statement, so not sure if this helps or not.

    lpad({Field A}, N, "Character for padding")


Please sign in to leave a comment.

Powered by Zendesk