Datatable column is not rendering properly a sentence, which is having space

rajesh123

Hi All,

I am copying a sentence from document sheet and storing it to the database.

example -

Effective Dates 12/01/16 - 01/01/17;  Timely submission is on or before 10/31/16

When it displays in datatable column, it's formatted automatically as below.

Effective Dates�12/01/16 - 01/01/17;� Timely submission is�on or before 10/31/16

How to get rid of '?' in the above line ?

Any help would be appreciated.

Thanks,
Rajesh

kthorngren

I'm not sure what that character is but you can try pasting the line into a plain text editor or use some code to find out. Then use columns.render to remove that character from the string.

Kevin

allan

Looks like there are hidden characters. I agree with Kevin - stick it in a text editor and save the file. Then use a hex viewer to see exactly what the character is.

You could then use a set formatter to strip it out.

Allan