Re: How to change small letter to capital letter [needs a string split and case change]

[David Marso]

"I've copied this to others on the list ..."
PLEASE STOP DOING THIS!  People will answer when they have time or the
inclination!  Sometimes we just don't give a flying F!

On Fri, 24 Sep 2010 10:21:50 +0200, John F Hall <[hidden email]> wrote:

>Just an idea, but you could try downloading the ID column from the data
editor to Word, then in Word highlight the whole column and use Format >
Change case  and copy it back, but I've been trying this sort of thing with
something else and SPSS only copies the first cell, not the whole column.
It might work via Excel and you might also need to change the names by
adding a character: that way you can check that the names are the same for
the ID bit.
>
>I've copied this to others on the list who helped with a similar problem
and who may be able to propose syntax for a string operation.

>
>John Hall
>[hidden email]
>http://surveyresearch.weebly.com
>
>
>
>  ----- Original Message -----
>  From: Khaing Soe
>  To: [hidden email]
>  Sent: Friday, September 24, 2010 8:49 AM
>  Subject: Re: How to change small letter to capital letter
>
>
>  Dear All,
>  My intention is to match two data sets  for which the household ID number

is the only key variable . In one data set,   HH ID numbers are small letter
like 1hml0001  while these are in capital letter like 1HML0001 in other data
set.   I cannot match two data sets.with this. whereas, when I manually
changed some values to capital letter, the match was OK. But there are over
3000 cases!

>
>  Please advise.
>
>  Regards,
>  Khaing Soe
>
>
>
>
>------------------------------------------------------------------------------
>  From: ViAnn Beadle <[hidden email]>
>  To: [hidden email]
>  Sent: Thu, September 23, 2010 7:38:39 PM
>  Subject: Re: How to change small letter to capital letter
>
>
>  The OP is asking about values, not variable names. Variable names are

case insensitive when parsed in syntax but retain their case when displayed
in output.
>
>
>
>  From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
John F Hall
>  Sent: Thursday, September 23, 2010 6:04 AM
>  To: [hidden email]
>  Subject: Re: How to change small letter to capital letter
>
>
>
>  Forget it.  SPSS is case insensitive, so it doesn't matter whether
variable names are in upprer or lower case , or even mixed.

>
>
>
>  John Hall
>  [hidden email]
>  http://surveyresearch.weebly.com
>
>    ----- Original Message -----
>
>    From: Khaing Soe
>
>    To: [hidden email]
>
>    Sent: Thursday, September 23, 2010 11:57 AM
>
>    Subject: How to change small letter to capital letter
>
>
>
>    Dear All,
>
>
>
>    Much appreciate if I can be guided on this:
>
>
>
>    I am dealing with a dataset where the entries for the  household ID was

put in 'string variable like

>
>    1hml002
>
>    1hml003
>
>    1hml004
>
>    ..........
>
>    Is there any possible way to convert the case of  <- hml---> from Small

letter to Capital letter without manually doing on every entry- for 3000
entries?

>
>
>
>    Thanking,
>
>    Khaing Soe
>
>
>
>
>

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD