Removing '<br>' text when exporting to CSV

user000051

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

jaeW_at_Onyx

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

user000051

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

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

user000051

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