How to trim an answer?

(Fabio) #1

Hello there!
I’d like to trim an answer the user gave to me before sending it to a Search Rows (google sheets) function.
A space at the end of the string is usually coming along when the user is on a mobile phone.
I thought I would find a trim function on Text(String) but I didn’t.
Thank you in advance.

(Nathan Stults) #2

There isn’t a Trim function, but we do have “Replace Text”, which you can use with a Regex.

(Fabio) #3

Perfect, thank you Nathan!