How to replace characters in all fields with blank/null?

[#1]

Hi All,

I have below sample data, I want to remove these charaters '' to blank/null while loading data. Please advise. Can we do by one script being applied to all columns?

Type	Doc No	Date	Doc Type
A	34765		
B		1/24/2015	INV
C	500369		
A			
B			
C			

Thanks,

SAK

[sunny_talwar]

This should work:

LOAD PurgeChar(Type, '') as Type,

          PurgeChar([Doc No], '') as [Doc No],

          PurgeChar(Date, '') as Date,

          PurgeChar([Doc Type], '') as [Doc Type]

Resident/FROM

HTH

Best,

Sunny

[sunny_talwar]

Tried it with your sample data:

Table:

LOAD PurgeChar(Type, '') as Type,

          PurgeChar([Doc No], '') as [Doc No],

          PurgeChar(Date, '') as Date,

          PurgeChar([Doc Type], '') as [Doc Type];

LOAD Type,

     [Doc No],

     Date,

     [Doc Type]

FROM

[https://community.qlik.com/thread/163361]

(html, codepage is 1252, embedded labels, table is @1);

Output looks like this:

[petter]

How did you load this data? It looks like you specified the wrong character set or code page... Maybe if you changed that you wouldn't get the strange characters...

[#5]

Yep, you are right.

First I got data downloaded to excel from HTML webpage and hence got these characters.

But then I directly loaded into qlikview, so now it's all fine

[#6]

The labels are now coming in first row of data loaded even though I have made it embedded labels.

IS there any way to add header lines in embedded labels while loading data from HTML wewebpage?