Forum Discussion

LeaGreen's avatar
LeaGreen
Qrew Member
4 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

  • Try this

    ToNumber(

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



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