Formula to remove blank lines from text
Hello, I have a field that is being generated by a pipeline and unfortunately due to the formatting of my jinja, creates blank lines:
Is there a way to format this via a formula text field so t...
Forum Discussion
Will the result always be in that exact format? ie, only 2 lines both starting with underscore?
_text
_moretext
------------------------------
Mike Tamoush
------------------------------
Hey Mike,
That's correct. I intentionally threw that in the Jinja2 so that I could hopefully format it using another formula text field.
I have gotten close:
Formula field is as follows:
SearchAndReplace([testing jinja2 pipelines], "\n", "")
------------------------------
Shane Miller
------------------------------Sorry, to elaborate, it could be more than two items with a _beforethetext.
My jinja2 code tests 15 or so fields to see if the previous value is different than the current value. The blank spaces I am experiencing can be anywhere, and there can be any number of _textlikethis up to 15 I suppose
------------------------------
Shane Miller
------------------------------
