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

4 Replies

Related Content

Break-Even Analysis

Create a line chart that contains three field?

Create a line chart that contains three field?

Duration Fields with Pipelines

Formula Rich Text field containing fields

Recent Discussions

Average last 30 days

Help Needed with Quickbase Pipeline to Accumulate Values Instead of Overwriting

(Pipelines) Get Users in Role / Process XML from HTTP API

Save & Redirect in a Formula URL Using API_GenAddRecordForm

Formula Builder Cursor Position Incorrect