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!
 588 Points
Posted 3 years ago
 588 Points
 588 Points
Wow, this was super easy. Just add a formula field which displays field's text but allows URL.
 70 Points
Hi Amber,
I used Dan's answer from https://quickbasecommunity.intuit.com/questions/1152425formulatoreplaceallinstancesofxwith...
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
I used Dan's answer from https://quickbasecommunity.intuit.com/questions/1152425formulatoreplaceallinstancesofxwith...
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
 70 Points
Hi Amber,
I used Dan's answer from https://quickbasecommunity.intuit.com/questions/1152425formulatoreplaceallinstancesofxwith...
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
I used Dan's answer from https://quickbasecommunity.intuit.com/questions/1152425formulatoreplaceallinstancesofxwith...
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
 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://quickbasecommunity.intuit.com/questions/1152425formulatoreplaceallinstancesofxwithyinatextfield in building formula.
Let me know if there are any questions.
Thanks,
Neal
NealPatil @ gmx.com
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://quickbasecommunity.intuit.com/questions/1152425formulatoreplaceallinstancesofxwithyinatextfield in building formula.
Let me know if there are any questions.
Thanks,
Neal
NealPatil @ gmx.com
 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
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
Related Categories

Forms
 3261 Conversations
 132 Followers

Formulas & functions
 2909 Conversations
 74 Followers

Reports & charts
 3085 Conversations
 91 Followers

Tables & fields
 7194 Conversations
 179 Followers