topic ODBC Carriage return problem in QlikView

ODBC Carriage return problem

Thu, 02 Dec 2010 10:29:48 GMT

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:

ODBC Carriage return problem

Thu, 02 Dec 2010 11:12:16 GMT

Hi,

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

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

Thanks.

ODBC Carriage return problem

Fri, 03 Dec 2010 22:19:15 GMT

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.

ODBC Carriage return problem

Tue, 07 Dec 2010 09:34:24 GMT

Thanks for the Demo.

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

Dror