Removing '<br>' text when exporting to CSV

user000051
user000051 Member
in Magic ETL

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 Coach

    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"
  • user000051
    user000051 Member

    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 Coach

    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"
  • user000051
    user000051 Member

    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

Categories