Start a new topic

Replace Carriage Returns and Line Feeds in a Burst

When bursting from Webintelligence we have found that a .hyper file to Tableau thinks these characters are invaild.


This can be fixed in Webintelligence with the following variable:


=Replace(Replace([Project Name];Char(10);" ");Char(13);" ")

Line Feed ascii is 10

Carriage Return is 13


Suggestion is to have this done while bursting a character fields.  if this any where then replace it with a space.


This is what the formula does:


image


Currently the system logs show:


image



Login or Signup to post a comment