Format of a field value

[#1]

I am loading a field called "Group" directly from a website.  One of the values is "Open (20 – 39 yrs)", but Qlikview is interperting the equals sign ("=") to three very weird characters (a€“).  How do I correct this?

[alexandros17]

Where is the equal sign in the string Open (20 – 39 yrs)  ?

[swuehl · Accepted solution]

I think you need to specify the correct character set in your load. Could you post your current script snippet?

[#4]

Sorry, I meant dash.

Alex

Sent from my iPhone

[#5]

CrossTable(Year, GroupPercent)

LOAD [Â ] as Group,

     [1980],

     [1995],

     [2000],

     [2005],

     [2010],

     [2011],

     [2012],

     [2013]

[cspencer3]

Could you load the field name using a string replace function, and replace the dash with a new character or a character function chr(45) ; character function of 45?

[its_anandrjs]

You can use PurgeChar function to purge the values which is specifying by you if always get same values like (a€“)

Load

PurgeChar(Str,'a€“') as

From Location;

Eg:-

LOAD PurgeChar(Str,'a€“') as NewStr,Str;

LOAD * Inline

[

Str

a€“Open (20 – 39 yrs)a€“

];

[#8]

But I need the dash.

Alex

Sent from my iPhone

[its_anandrjs]

Then try with this

Load

Replace(Str, 'a€“' , '-') as Str2

From Location;

[#10]

Ahh! Perfect! Thanks! Will mark it later!

Alex

Sent from my iPhone