Find if text field contains
or Line Break

Question

I have a text field XY containing data"hellofriendhow are you"I m trying to detect if it contains line break or 
 (which it does)contains([XY],"
")&nbsp;This fails , what else can be done?------------------------------Prashant Maheshwari------------------------------

markshnier__you · Answer

I believe that this works as a formula checkboxFind([My Multiline Text Field], "
") &gt; 0------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

prashantmaheshw · Answer

Hi mark,&nbsp;Big Fat Thanks as always , Find did the trick------------------------------Prashant Maheshwari------------------------------

jefflove · Answer

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 &lt;space&gt; etc.------------------------------Thanks, Jeff------------------------------

prashantmaheshw · Answer

Thanks Jeff,I will try the suggestion as well.------------------------------Prashant Maheshwari------------------------------

Forum Discussion

Find if text field contains \n or Line Break

Related Content

Snapshot Fields

Consolidate Field Types

Formula using Contain

Formula to populate a field based on another field that contains a specific text string?

CONTAINS formula