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
I'm sure editing the Jinja is probably best practice, so if someone knows Jinja, that is the way to go. I am not very good at Jinja, so try this in your formula field:
var text LinesRemoved = SearchAndReplace([testing jinja2 pipelines], "\n", "");
Trim(SearchandReplace($LinesRemoved, "_", "\n"))
//This is untested and I am not sure if Trim will remove the first blank line that will be put back in replacing the first underscore. If it doesn't work, let me know I have other ideas.
------------------------------
Mike Tamoush
------------------------------
I agree with you about reformmating my jinja2. I'll leave it below my response to you in case anyone wants to take a stab at fixing it.
Unfortunately, that formula doesn't work. I can't pin-point why it doesn't, I feel like it should.
This was the outcome it gave me:
------------------------------
Shane Miller
------------------------------
Here is my Pipeline and also the Jinja2 that follows:
------------------------------
Shane Miller
------------------------------My only suggestion is to remove the line breaks from your Jinja. I'd blindly wager this might do the trick.
------------------------------
gary
------------------------------I also found this for testing Jinja. It's pretty helpful: http://jinja.quantprogramming.com/
I tested a small portion of your code with the line breaks removed and the output was good (no line breaks).
------------------------------
gary
------------------------------Thanks for that URL Link gary! It does indeed look like taking out the line breaks will work but gosh - that certainly makes for messy code. I wonder if there are any other options where you don't end up with confusing, run on code?
------------------------------
Mike Tamoush
------------------------------
Interesting. I ran a test and it worked for me. If your first attempt removed all the blank lines, I am confused how it put them all back in. Can you post your exact code? Also, what type of field is the jinja test field. Is it multiline text?
------------------------------
Mike Tamoush
------------------------------I am also confused as I went back and reentered my code:
SearchAndReplace([testing jinja2 pipelines], "\n", "")and it too stopped giving me the outcome I initially screenshot where they were on the same line.
[testing jinja2 pipelines] = Text - Multi-line - this is the field in which Pipelines updates the record.
[formatting jinja2 pipeline with formula] = Formula text field -> current code inhabiting this field:
SearchAndReplace([testing jinja2 pipelines], "\n", "")
result in [formatting jinja2 pipeline with formula] field:_dba changed from 28 to 29
_tax id changed from 28 to 29
------------------------------
Shane Miller
------------------------------It's almost like QB is no longer recognizing "\n" as an escape sequence for some reason?
------------------------------
Shane Miller
------------------------------
