Table shall not remove multiple spaces, how to prevent removing space?

[Thore]

1. My goal: show data exact as data is stored in MySql Database

2. Issue: Table removes double space within a String.
   

   

3. tested with the example data below:

[{"id":0,"firstName":"Chic   mid", "lastName":"Footitt","email":"chic.footitt@yahoo.com","website":"https://chic.footitt.com","text":"Nulla sit amet nibh at augue facilisis viverra quis id dui. Nullam mattis ultricies metus. Donec eros lorem, egestas vitae aliquam quis, rutrum a mauris","role":"Viewer","teams":["Workplace","Infrastructure"],"enabled":true,"createdAt":"2023-01-16T23:40:20.385Z"}]

4. Additional info: Self-hosted 3,114,3
   Data Source: "SQL query" that is getting data from MySQL

Hope that somebody can help a user

[Thore]

Hi

Need help with this one.

I have tested this:

Double space is not showing in the table. is there a way to present orginal data that have double space in table as it is stored?

without removing double space?

[MiguelOrtiz]

Hey @Thore,

not sure why "String" type is having this behaviour, but I found that if you use "Multiline String" as column type it won't remove the double spaces, so hopefully you can use that workaround.

[WidleStudioLLP]

Hey @Thore ,

You can try using the following JavaScript in the firstName column to preserve spaces as they appear in the data
{{ item.replace(/ /g, '\u00A0') }}

Normal text without space:

With space :

[Thore]

@WidleStudioLLP

Thank you for the help.