E Greetings

Yesterday we were invited to our friends baby shower. As usual I forgot until the last minute to pick up a card and called up the missus who is very creative. She found a very good site for doing greeting cards americangreetings.com.

She created the above printable card using the available templates and mailed it to me for taking a print out. We attached the same and a small diaper shaped sheet cutout to the gift basket and gave it to the couple. The site was very helpful

Excel to Pipe delimited

As part of my work I got an Excel file today. We had to convert it into Pipe delimited file and upload it. Normally the reverse is easy ie converting from Pipe delimited file to Excel. I was under the impression that this also would be easy and started the work. Half an hour later I was frustrated and googling all over the place trying to find the solution. I was looking at scripts add ons and what not.
Suddenly our of the blue the simplest solution came from a user in a forum. Simple and utterly effective
1. In the excel file find and replace all commas into a special character *

2. Convert the excel file into a CSV file Comma seperated file

3. Open it in notepad and find and replace all commas into Pipe |

4. Find and replace all the special characters * into commas.

Voila you have the Pipe delimited file ready. Sometimes you need to think simple. Thanks to the guy in the forum