A problem with a text field

[#1]

Hello to all,

I have the following problem:

I load a table from a SQL Server text field whose length reaches to 1000 characters

When I export to Excel the field is filled with '###### characters'

Why is this happening? Is there a way to say that the length of the field can be up to 1000 characters?

Thank to all

[Kushal_Chawda]

You can try loading like below

LOAD *,

         trim(mid(Field,1,1000)) as Field

.....

FROM table

[sujeetsingh]

Convert it in SQL itself

[#4]

Thank you

but it does not work.

I felt when unloading the table from SQL servere to put the statement

LTRIM (SUBSTRING (DO30_DESCART, 1.1000)) AS DO30DESCART

but not work.

[marcus_sommer]

The '###### characters mean only that the content didn't fit within the column-width. So you have the possibility to extend the column-width and/or the row-height and/or to enforce a line-breaks. Did you have anywhere a problem with this in qlikview?

- Marcus

[#6]

No, I had this problem only on some lines.

It can be a character ASCII particular?

If yes, how can I find out which is it?

[Anil_Babu_Samineni]

Marino,

Can you please check the length of Each cell / Share that Excel..

LEN(Text of Cell) -- LEN(A2)

Please Find that, Length is came or not. So that we can get idea of that...

Updated : I have 2740 Characters. Such time you have to select the column and then WrapText.

You will get idea... Please find Attachment ...

[marcus_sommer]

If I'm not sure about some characters I copy them within a editor like notepad ++ to check if there is anything noticeable.

- Marcus

[#9]

Bay Anil.

Ok.

If I understand it.

the length of some fields oh the tble QVW and if it works export to Excel:

length Yes/No

95 yes

49 yes

40 yes

244 yes

244 yes

513 no

353 no

250 yes

390 no

91 yes

106 yes

152 yes

118 yes

66 yes

141 yes

[#10]

Hello Anil .

Yes, so it works. I tried it once.

Then, in your opinion, the problem is in Excel and not QLW?

Thank