Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I think you need to specify the correct character set in your load. Could you post your current script snippet?
Where is the equal sign in the string Open (20 – 39 yrs) ?
I think you need to specify the correct character set in your load. Could you post your current script snippet?
Sorry, I meant dash.
Alex
Sent from my iPhone
CrossTable(Year, GroupPercent)
LOAD [Â ] as Group,
[1980],
[1995],
[2000],
[2005],
[2010],
[2011],
[2012],
[2013]
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?
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€“
];
But I need the dash.
Alex
Sent from my iPhone
Then try with this
Load
Replace(Str, 'a€“' , '-') as Str2
From Location;
Ahh! Perfect! Thanks! Will mark it later!
Alex
Sent from my iPhone