Remove HTML from Excel Files

Occasionally I will have an Excel file that contains HTML markup that I need to remove. The Excel Replace feature makes removing HTML easy. To remove the HTML tags highlight the cells that contain the HTML and then select Edit > Replace. In the “Find what” field enter <*>. Leave the “Replace with” field blank and then click on the “Replace All” button. Poof! All of your HTML will magically be removed.

html_replace

It’s time to tell IBM how you really feel about some things…

IBM developerWorks has launched the developerWorks LIVE Jam which runs from June 11-18. Here you as a professional developer can give the developerWorks team your thoughts on how you prefer to learn technical skills, share your expertise, and build your online reputation. You can use your IdeaJam.net registration to participate in the jam. If you are not already registered you can register here.

f-rc-dwlivejam

Podcast: Opting In – Ed Brill talks about his new book

Today we spoke with Ed Brill (http://edbrill.com), Director of Social Business and Collaboration Solutions at IBM, about his new book. It’s called Opting In: Lessons in Social Business from a Fortune 500 Product Manager, and it’s available both on Amazon.com (http://www.amazon.com/Opting-In-Lessons-Business-Fortune/dp/0133258939) and directly from IBM Press (http://www.ibmpressbooks.com/store/opting-in-lessons-in-social-business-from-a-fortune-9780133258936).

We discussed:

  • Why did you write this book?
  • Who is the audience?
  • What is the message of the book?
  • What has surprised you about the book?
  • What’s going on at IBM Connect related to the book?
  • And more…

Listen now >

Podcast: The IBM 2012 Tech Trends Report

On this episode we interviewed IBM’s Paul Brunet, Vice President ISVs, startups and academic relations, IBM about the recent release of the IBM 2012 Tech Trends Report. During the interview we talked about:
Paul’s role at IBM

  • What exactly does the Tech Trends Report covers
  • What surprised Paul in the report
  • The growing skill gaps in technology
  • What IBM Is doing to help shrink the skills gap
  • Paul’s advice for developers and IT admins that are trying to keep up with all of the changes in IT
  • Social Business and Collaboration. Did the report uncover anything interesting in those areas?
  • and much more…

On the recording you will hear the show be identified as episode 172 when in actuality it’s really 173. The show runs for 28:08 minutes.

Listen now >

Must watch video for all XPages developers: What’s new in Domino Designer 9.0

Matt White has just released a free video that walks you through some of the new things you will find in IBM’s forthcoming Domino Designer on his XPages 101 site. Matt will be presenting at IBM’s Connect event and I highly recommend that you make time in your schedule to attend his sessions.

 

Podcast: Learning XPages with NotesIn9

Today we had the pleasure of interviewing the creator of the awesome NotesIn9 screencast – David Leedy (@notesin9). We were also joined by special guests Paul Calhoun and Dr. Mark Roden. We talked about:

  • How and why David got started with NotesIn9
  • Where the name for the show came from
  • What goes into producing a show
  • What community resources David provides
  • The XPages Cheat Sheet
  • What is the “Drive to 99” Event?
  • The number of shows David has published
  • The number of contributors who have appeared on the show
  • How people can get involved and contribute to the show and what do they need to do
  • Which XPages topics do people want to learn more about
  • and much more…

The show runs 31:36 and best listened to while eating Pennsylvania OR Texas BBQ.

Listen now >

Podcast: There’s Gold in Them XPages

We talked with XPages developers Jesse Gallagher (@Gidgerby) and Dr. Mark Roden (@markyroden) about:

  • How Jesse got started with Notes/Domino
  • How Jesse’s interest in Ruby on Rails spilled over into XPages
  • How a Notes/Domino programmer like Jesse has approached and been successful with XPages
  • How to approach XPages app development
  • What about Lotusscript?
  • How to write “clean” code
  • Using source code control
  • Moving from Lotusscript to MVC
  • Why Expression Language and Java are important
  • What XPages can offer that other platforms cannot or offer in a different way
  • The adaptability and flexibility of the XPages platform
  • and much more…

Listen now >

Podcast: What’s New with IBM Wikis

We talked to IBM User Experience Development team members Amanda Bauman, Craig Lordan, Kevin Giles, and Mike Stewart about what’s going on these days with the IBM Wikis. Topics included:

  • History of the IBM wikis
  • Types of content on the wikis (it’s not just random information spread across various pages)
  • New features in the latest iteration of the wiki template
  • Improvements in navigation and search
  • Dynamic content control
  • And more…

Bonus trivia: did you know that the short URL to the Lotus (aka ICS) wikis is wiki.lotus.com?

Listen now >

Updated: IBM Notes/Domino mobile solutions podcast roundup

Over the last couple of months Taking Notes (@takingnotespod) has interviewed three five companies who provide software, tools and services that can help you mobilize your Notes and Domino applications:

We also recently had some other mobile related shows that you may find interesting:

  • jQuery in XPages with Marky Roden (Episode 157)
  • Mobile App Strategies with Graham Acres (Episode 152)
  • What’s New in IBM Connections 4 (Episode 168)
  • What’s New in IBM Mobile Apps, with Chris Reckling and Rob Ingram (Episode 164)

JoyDrop: Give • Get • Share

This evening Apple approved the JoyDrop app that I developed for the Children’s Cancer Association.

“JoyDrop offers a place to share spontaneous moments of joy.Your “drops” of joy, collected with others, can create a sea of joy. At the Children’s Cancer Association we like to call it the Joy Effect.We invite you to share your found joy, moment by moment, drop by drop by using the JoyDrop app.Please share often.”

JoyDrop for iOS

The app allows you to share your words of joy and post them to Facebook if you want. Not only can JoyDrops be seen in the app, they can also be added and viewed on the Children’s Cancer Association Facebook “JoyDrop” Fan Page app:
JoyDrop Facebook App

For you geeks out there the iOS app was built with Appcelerator and stores data in an IBM Domino database. There are no more than 400 lines of code for the Appcelerator portion of the app. The app utilizes an XPages “XAgent” to post data and a Domino Access Services view to send JSON data back to the app to display JoyDrops. It literally took only minutes to develop the app interfaces in XPages. The Facebook app was built with XPages and the Facebook Graph API. It’s pretty cool how easy it is to utilize the Graph API within XPages.

The next version of the app will incorporate photo sharing from the iPhone and some other goodies. After that I will work on getting an Android version of the app developed.

A big thanks to my friends Matt White, Jeremy Hodge, Serdar Basegmez, Julian Robichaux, Niklas Heidloff, Mark Hughes, Per Henrik Lausten and Thomas Gumz for their support.
Stay tuned for a NotesIn9 video on how this app was put together.