Date:         Wed, 2 Nov 2005 11:20:41 -0800
Reply-To:     "Terjeson, Mark (IM&R)" <Mterjeson@RUSSELL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Terjeson, Mark (IM&R)" <Mterjeson@RUSSELL.COM>
Subject:      Re: information coded in bold in excel
Comments: To: David L Cassell <davidlcassell@MSN.COM>
Content-Type: text/plain; charset="us-ascii"

Knit 2, Perl 1.
or as your grandmother would say
Knit 1, Pearl 2.

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
David L Cassell
Sent: Wednesday, November 02, 2005 11:02 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: information coded in bold in excel


Mterjeson@RUSSELL.COM sagely replied:
> >Is it possible to extract the fact that data is entered in a bold
> >font in excel?
>
>Yes there is.  If you SAVE AS your spreadsheet
>as .xml instead of .xls you can write a small
>bit of text parsing code in SAS to locate the
>cells or words that are in bold.
>
>For "words" that are in bold within a cell it
>would be 5-10 lines of SAS code to locate the
>row, column, and which words were bold.  If
>the entire "cell" is in bold it would be 10-20
>lines of SAS code.

Or one line of Perl.

:-)  :-)  Sorry, I just couldn't resist.

David
--
David L. Cassell
mathematical statistician
Design Pathways
3115 NW Norwood Pl.
Corvallis OR 97330

_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how
to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement