Issue with line spacing in a field

[Anonymous]

Hi guys

Another day and another cry for help !

I have a field which shows spacing between entries in SQL like this

When I add the field into a table within Qlikview it appears to be adding carriage returns instead of spaces in the field like it returns in SQL. Screen below from Qlikview

Can anyone shed any light on this? I would like Qlikview to display the data the same as SQL does!  Can this be done?

[Anonymous · Accepted solution]

I think you have newline characters in the DB. They just aren't showing in SQL.

Try this:

replace([bullet_text],chr(13),' ')

This could be put in your load script as:

replace([bullet_text],chr(13),' ');

[rustyfishbones]

Have you tried changing the width of the column to see if it still adds the Carriage Returns

or you can try something like

REPLACE(Matrix_bullet_text, CHR(13),' ')

[anbu1984]

Not sure how you got carriage returns. You can use Purgechar(Chr(10) & Chr(13)) to remove newline and carriage return

[Anonymous]

You probably have those line breaks on SQL too, but they're not appear there.

Try replace this line breaks by spaces on your field, something like this:

Replace(Matrix_bullet_text, Chr(13), ' ') as Matrix_bullet_text

If you could post here a sample qvw, It would help.

Regards,

Gabriel

[Anonymous]

Another question answered !

Thanks a lot guys.  Much appreciated...