Skip to main content
Question

converting text to number

  • February 17, 2024
  • 0 replies
  • 159 views
Forum|alt.badge.img+2

I'm looking to convert a text field into a number based on what the text field says. Example: If the content is "1 - Low confidence" convert to number "1". 

Thanks!



------------------------------
L Green
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+22
    • MarkShnierYou
    • Quickbase Alumni
    • February 17, 2024

    Try this

    ToNumber(

    Trim(Left([My text rating field],"-")))



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement