Can a field display text from another field MINUS the line breaks?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a Notes field (for Vendor records) in which we use line breaks to heavily to break up areas of information, but it would be great to have a condensed version of this field (without line breaks) for reports.

Ideally the line break could be replaced by a single 'space' character.

Thank you!

Photo of Amber

Amber

  • 588 Points 500 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Amber

Amber

  • 588 Points 500 badge 2x thumb
Or would someone be able to confirm this isn't possible?
Photo of Amber

Amber

  • 588 Points 500 badge 2x thumb
Wow, this was super easy. Just add a formula field which displays field's text but allows URL.
Photo of Neal

Neal

  • 70 Points
Hi Amber,

I used Dan's answer from https://quickbase-community.intuit.com/questions/1152425-formula-to-replace-all-instances-of-x-with-...

Formula used :

List (" ",
  Part([notewithlinebreaks], 1, "\n"),
  Part([notewithlinebreaks], 2, "\n"),
  Part([notewithlinebreaks], 3, "\n"),
  Part([notewithlinebreaks], 4, "\n"),
  Part([notewithlinebreaks], 5, "\n"),
  Part([notewithlinebreaks], 6, "\n"),
  Part([notewithlinebreaks], 7, "\n"),
  Part([notewithlinebreaks], 8, "\n"),
  Part([notewithlinebreaks], 9, "\n"),
  Part([notewithlinebreaks], 10, "\n")
)

I will add 2 screenshots to the answers relevant to this question.

Thanks,

Neal

NealPatil @ gmx.com
Photo of Neal

Neal

  • 70 Points
Hi Amber,

I used Dan's answer from https://quickbase-community.intuit.com/questions/1152425-formula-to-replace-all-instances-of-x-with-...

Formula used :

List (" ",
  Part([notewithlinebreaks], 1, "\n"),
  Part([notewithlinebreaks], 2, "\n"),
  Part([notewithlinebreaks], 3, "\n"),
  Part([notewithlinebreaks], 4, "\n"),
  Part([notewithlinebreaks], 5, "\n"),
  Part([notewithlinebreaks], 6, "\n"),
  Part([notewithlinebreaks], 7, "\n"),
  Part([notewithlinebreaks], 8, "\n"),
  Part([notewithlinebreaks], 9, "\n"),
  Part([notewithlinebreaks], 10, "\n")
)

I will add 2 screenshots to the answers relevant to this question.

2nd Screenshot is attached here.


Thanks,

Neal

NealPatil @ gmx.com
Photo of Neal

Neal

  • 70 Points
[mention://1471195 @Amber]
Hi Amber,
I have attached two screenshots and formula (in answer section ) which I used in my test environment for replacement of new line. I used "dandiebolt_QB_Pirate"'s answer https://quickbase-community.intuit.com/questions/1152425-formula-to-replace-all-instances-of-x-with-y-in-a-text-field in building formula.
Let me know if there are any questions.
Thanks,
Neal
NealPatil @ gmx.com
Photo of Neal

Neal

  • 70 Points
[mention://1471195 @Amber]  
Please note that it is for replacing first 10 new lines. If there are more than 10 new lines then formula needs to be modified .
Thanks,
Neal
NealPatil @ gmx.com