Removing '<br>' text when exporting to CSV

Hi all,

 

I am automating the export of a table to CSV that will feed my CRM software.

 

One of the fields is a CONCAT of Text + other fields + line breaks ('<br>'). Unfortunately, when I export to CSV the line breaks are translated to text (i.e A <br> B <br> C), do you have any suggestions on how to avoid this issue.

 

Perhaps using a different code that <br> in Beast Mode for the line breaks?

 

Thanks,

G

Comments

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🔴

    make a beast mode without the formatting, and export that to your crm.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Hi Jae,

     

    Thanks for your quick reply, can you be more specific.

     

    Did you mean to create another Beast Mode field that copies only the text? If so, can you indicate the function?

     

    Much appreciated.

     

    G

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🔴

    a <br> tag is just a line break.  so ... recreate the beast mode without the line break.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Hi Jae,

     

    Thanks, I understand now.

     

    However, I will need the line breaks as in a successive step I set up an automated process that recognizes this format. 

     

    Thanks,

    G