st: Re: Replacing certain characters in variable labels.

After a bit more exploration I found the solution:
foreach i of varlist _all {
local a : variable label `i'
local a: subinstr local a "â€™" "'"
label var `i' "`a'"
}
On Fri, Apr 9, 2010 at 11:49 AM, Anna Reimondos <areimondos@gmail.com> wrote:
> Hello,
> I am currently cleaning a dataset but am having some trouble with the
> variable labels. The variable labels are related to the wording of the
> actual question in the survey.
> For example for the first variable the variable name should "A
> woman's job is to stay at home?"
>
> However whenever apostrophes are displayed strangely so that in the
> dataset the name looks like "A womanâ€™s job is to stay at home?".
>
> What I would like to do is to replace all occurrences of "â€™" with an
> apostrophe instead " ' ".
>
> I attempted to do this but it did not work and I am not really sure
> what I am doing...
>
> foreach i of varlist _all {
> local a: variable label `i'
> local a: subinstr("`a'","â€™","'",.)
> label var `i' "`a'"
> }
>
> Any help or tips would be much appreciated.
> Thanks!
> Anna
>
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/