Discussion Board for collaboration related to QlikView App Development.
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?
This should work:
LOAD PurgeChar(Type, 'ï»¿') as Type,
PurgeChar([Doc No], 'ï»¿') as [Doc No],
PurgeChar(Date, 'ï»¿') as Date,
PurgeChar([Doc Type], 'ï»¿') as [Doc Type]
Tried it with your sample data:
PurgeChar([Doc Type], 'ï»¿') as [Doc Type];
(html, codepage is 1252, embedded labels, table is @1);
Output looks like this:
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...
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
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?