ODBC Carriage return problem

[#1]

Hi,

Qlikview, for some reason, shows squares instead of carriage-return. I'm reading an access database (.mdb) using ODBC driver.

Any ideas how to solve this?

See illustrations below:

:

[#2 · Accepted solution]

Hi,

I recently came across the same issue, with the squares.

I used the REPLACE function to fix this. - See attached.

Thanks.

[#3]

You could also use an expression something like this:

replace([acc_dsc],'','
')

That will replace the square with a real new-line in your chart. You will need to change chart Properties on the Presentation tab, Multi-line Settings, to make the cells wrap to two lines.

[#4]

Thanks for the Demo.

It turned out it was tab character (char(9)). Simple REPLACE did the trick.

Dror