Behind the Screen
The opinions, views, and insights stated within this Monologue are my own. The facts, fallacies, and errors, however, belong to someone else (see disclaimer).
Tuesday, September 28, 2004
Time for an update.
On Sunday, September 19, I attended Chicago the musical at the Butler University auditorium in Indianapolis. They did a great job, though I liked the movie more.
On Tuesday, the boss surprised a few of us with a chance to drive a race car that afternoon. Really, they were more like go-carts, but it was fun nonetheless. The Track Attack was a gift from the neighborhood Holiday Inn, which gets a lot of our business.
This weekend I went canoeing and camping in western Indiana. I bought a four-person tent and two sleeping bags from the Eddie Bauer outlet about three weeks ago, so it was good to try them out. We couldn’t have asked for a better weekend.
Thursday, September 16, 2004
Today I was given a 150-page MS Word document and was asked to pull out all of the email address within the document and place them into a MS Excel file.
Since the email addresses were imbedded throughout the document's text, I couldn't just sort, cut, and paste them. I needed to find a way to pull them from the text. Here's how I did it.
- In MS Word, use Find and Replace to find every "space" and replace it with a new line break "^". Since email addresses don't have spaces, they will all appear on a new line.
- Copy the extremely long document into MS Excel. All copy will appear in a single column.
- Highlight that column and choose Text to Columns within MS Excel's Data menu.
- For the Delimiter, input the AT symbol "@". This will spilt all email address into the second column, all other content will remain in the first column.
- Highlight both columns and sort the content by Column B. Now all of the email address are in the top rows.
- Copy all of the rows that have content in two rows and paste it back into a new MS Word file. Make sure you paste as plain text.
- All that's left is for you to Find and Replace every Tab "^t" with the at symbol "@"
Wednesday, September 01, 2004
My dad's company, Pearce Brinkley Cease + Lee PA Architecture, received first place honors by the American Institute of Architects Committee on Design's "New Home on the Range" 2004 competition. The selection was announced this summer at the American Institute of Architects national convention in Chicago.
They also received AIA's Best Firm in North Carolina award. The news is so fresh, they haven't updated their site yet, but you'll eventually find the article here.
Way to go dad!