Convert Content from a String Variable

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

philippyaki
Posts: 1
Joined: Thu Feb 26, 2015 12:53 pm

Convert Content from a String Variable

Postby philippyaki » Thu Feb 26, 2015 12:57 pm

Hello,

I have a dataset which includes country names and every character is written uppercase. I would like to keep the first letter in uppercase and lower the remaining letters. I tryed this loop:

DATASET ACTIVATE DatenSet2.
loop repetition = 2 to 216.
RECODE V1 = lower(char.substr(V1,2)).
end loop.

But the loop hasn´t worked. What I did wrong?

Thanks in advance for the response!
iopsych
Posts: 25
Joined: Tue Feb 24, 2015 11:58 pm

Re: Convert Content from a String Variable

Postby iopsych » Sun Mar 01, 2015 11:54 pm

Hello Phil,

"DatenSet2" looks a bit weird. Are you sure it is accurate?

Besides, you can always copy to excel, do the transformation, and copy back ;)

I hope this was helpful.

Yalcin

Who is online

Users browsing this forum: No registered users and 1 guest

cron