How do i turn the text field values into a number?

  • 1
  • 2
  • Question
  • Updated 2 years ago
  • Answered
Hi there,

I have a customer satisfaction app and I have a number of questions with multiple choice text fields with values like this:

5-Extremely professionally
4-Very professionally
3-Somewhat professionally
2-Not so professionally
1-Not at all professionally

I need to take the first character and turn it into the number above so I can calculate my ratings.

What's the best way of handing this?

Thanks,
Photo of Chris Collins

Chris Collins

  • 40 Points

Posted 2 years ago

  • 1
  • 2
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,522 Points 20k badge 2x thumb
ToNumber(Left([Answer], 1))
Photo of Chris Collins

Chris Collins

  • 40 Points
Thanks very much....