Date:         Sun, 6 Apr 2008 09:08:41 -0400
Reply-To:     Hans Chen <spsshanschen@gmail.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Hans Chen <spsshanschen@gmail.com>
Subject:      Re: Capitalize the First Word in the Quotation Mark using SPSS
Content-Type: text/plain; charset=ISO-8859-1

Dear lister(s):

My value labels look like as follows:

/Q2M1 TO Q2M3

01           "Happy With Convenient Garbage and Recycle"

02           "Always Room For Some Improvement/ Needs"

03           "Services Aren't Regular/ Not Often Enough"

04           "Garbage Sits Too Long And Ends Up All Over"

05           "A Costly Service For What Is Done"

06           "In The Winter They Should Pick Up More O"

07           "The Price Is Pretty Good For The Convenience"

08           "Need More And Better Recycling Services"

09           "Bins Overflowing"

10           "Too Many Restrictions On What And How Mu"

11           "Private Pick Up/ Excellent Service"

12           "I Live In A Good Neighborhood With Good "

13           "Furniture/ Large Pieces Sit Out Here For"

14           "High Density Are/ Need More Service/ Lit"

15           "I Am Not Sure What We Pay For It Now"

16           "I Have Seen What People In Other Parts O"

17           "I Dislike When People Misuse The System/"

18           "The Recycling Is Convenient, Good Back A"

96           "Just Satisfied/ Fair Adequate"

98           "Don't Know (DO NOT READ)"

99           "Refused (DO NOT READ)"



I would like to change them as follows: the first word in the quotation mark
in each row is capitalized. I have tried to transform the font in Microsoft
Word and Excel but failed. To change it manually would be very boring and
time-consuming. Could you tell me whether it is possible to do it using SPSS
syntax? You response will be highly appreciated.







Hans Chen

=======================================================

/Q2M1 TO Q2M3

01           "Happy with convenient garbage and recycle"

02           "Always room for some improvement/ needs"

03           "Services aren't regular/ not often enough"

04           "Garbage sits too long and ends up all over"

05           "A costly service for what is done"

06           "In the winter they should pick up more"

07           "The price is pretty good for the convenience"

08           "Need more and better recycling services"

09           "Bins overflowing"

10           "Too many restrictions on what and how mu"

11           "Private pick up/ excellent service"

12           "I live in a good neighborhood with good"

13           "Furniture/ large pieces sit out here for"

14           "High density is/ need more service/ lit"

15           "I am not sure what we pay for it now"

16           "I have seen what people in other parts o"

17           "I dislike when people misuse the system/"

18           "The recycling is convenient, good back a"

96           "Just satisfied/ fair adequate"

98           "Don't know (DO NOT READ)"

99           "Refused (DO NOT READ)"

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (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