Find if text field contains \n or Line Break
I have a text field XY containing data "hello friend how are you" I m trying to detect if it contains line break or \n (which it does) contains([XY],"\n") This fails , what else can be ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI believe that this works as a formula checkbox
Find([My Multiline Text Field], "\n") > 0
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Find([My Multiline Text Field], "\n") > 0
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- Hi mark,
Big Fat Thanks as always , Find did the trick
------------------------------
Prashant Maheshwari
------------------------------Another trick to identify and change or replace text fields is to use the
URLEncode() on the field first, this displays lots of funky things that you can
Find/Replace with <space> etc.
------------------------------
Thanks, Jeff
------------------------------- Thanks Jeff,
I will try the suggestion as well.
------------------------------
Prashant Maheshwari
------------------------------
