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.

  • 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.

  • 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