How do i insert a line break in a cell in Ag Gid Domo table?

naveenprabhu811
naveenprabhu811 Member
in Magic ETL

Hello all,

I have plugged AG Grid framework with Domo. Below is the AG Grid Table with multiple values separated by ',' inside a cell. But I want a line breaker after each value. I tried to replace ',' by '\n' using Magic ETL but it is not working. Can someone please help me here?

image.png

Tagged:

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    Are you using a Domo brick to render this AG Grid? I wonder if you would need to do the replace in the JavaScript section of the brick in order for this to work. It may be that Domo is encapsulating the data returned to avoid certain injection attacks.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • GrantSmith
    GrantSmith Coach

    Have you tried utilizing <br> instead of \n? Is it actually displaying \n or just not doing a new line?

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • naveenprabhu811
    naveenprabhu811 Member

    Hey Grant,

    Thank you for the reply. I have replaced ',' by '<br>' in Magic ETL as below-

    image.png

    It is displaying <br> on screen instead of actually line breaking

    image.png

  • MarkSnodgrass
    MarkSnodgrass Coach

    Have you tried &#013; as another way to force a line break?

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • naveenprabhu811
    naveenprabhu811 Member

    Hey Mark,

    Yes, I have tried that. It just displays '&#013' instead of line break

    image.png

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    Are you using a Domo brick to render this AG Grid? I wonder if you would need to do the replace in the JavaScript section of the brick in order for this to work. It may be that Domo is encapsulating the data returned to avoid certain injection attacks.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories