converting text to number

Question

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".&nbsp;

Thanks!------------------------------L Green------------------------------

markshnier__you · Answer

Try this

ToNumber(
Trim(Left([My text rating field],"-")))------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

lg · Answer

That worked!   Thank you. Solved.

Forum Discussion

converting text to number