Forum Discussion

LeaGreen's avatar
LeaGreen
Qrew Member
3 months ago

converting text to number

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
------------------------------

2 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger

    Try this

    ToNumber(

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



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------