Visokio website     Downloads     Video tutorials     KnowledgeBase  
Formulae: Text-processing; determining Text or Number? - Visokio Forums
Formulae: Text-processing; determining Text or Number?
  • aknotts     aknotts May 1, 2014 8:23AM
    If you want to see if the first character of a string is a text or a number, you can use the following function in a formula field

    TYPEOF(value(left([my_string], 1)))

    This returns the type of the argument passed to it (e.g. text, decimal, integer)
  • 1 Comment
  •     Mees May 1, 2014 6:29PM
    Thanks

    Just used it and works great
This discussion has been closed.
← All Discussions

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership