Excel to custom character delimited value text(similiar to csv)

Recently after spending a lot of painful hours on trying to convert a excel file to a pipe or tilda or hash delimited value text file, i figured out a very easy solution to implement this on a windows xp machine

Setting up custom character as the default delimiter

From the Start button on the MS Windows task bar, highlight
Settings and select the Control Panel. In the Control Panel window select
Regional and Language Options.
2. In the Regional and Language Options window, select the Regional Options
tab, click the Customize… button.
3. In the Customize Regional Options window, select the Numbers tab.
4. Set the List Separator field to a pipe-delimited symbol | by pressing Shift and |. (You can set any other character you wish)

5. Click OK to close the Customize Regional Options window.
6. Click OK to close the Regional and Language Options window.


Convert MS Excel to the Custom character separated value text file

7. Open MS Excel.
8. In the menu bar click File and then click Open.
9. Choose the excel format file that you want to convert.
10. After excel opens and the data is loaded, In the menu bar click File and the click Save.
11. In the Save As window select CSV (Comma delimited) from the Save as type:
dropdown list and click Save

Don't forget to revert back the default delimiter setting else you will see a lot of unwanted of behavior in alot of applications, MS word, Excel, etc

Favorite poem for 3rd grade

Veer Tum Badhe Chalo

Veer tum badhe chalo
Dheer tum badhe chalo

Sath me dhvaja rahe
Bal dal saja rahe
Dhvaj kabhi jhuke nahi
Dal kabhi ruke nahi


Samne pahad ho
Sinh ki dahad ho
Tum nider hato nahi
Marg me ruko nahi

Veer tum badhe chalo
Dheer tum badhe chalo

Badal garajte rahen
Megh baraste rahen
Bijliyan chamak uthen
Bijliyan tadak uthen

Veer tum badhe chalo
Dheer tum badhe chalo

prat ho na raat ho
Sang ho na sath ho
Surya se badhe chalo
Chandra se badhe chalo

Veer tum badhe chalo
Dheer tum badhe chalo 

बढ़े चलो
-द्वारिकाप्रसाद माहेश्वरी

वीर तुम बढ़े चलो
धीर तुम बढ़े चलो

साथ में ध्वजा रहे
बाल दल सजा रहे
ध्वज कभी झुके नहीं
दल कभी रुके नहीं

सामने पहाड़ हो
सिंह की दहाड़ हो
तुम निडर,हटो नहीं
Marg me ruko nahi

वीर तुम बढ़े चलो
धीर तुम बढ़े चलो

प्रात हो कि रात हो
संग हो न साथ हो
सूर्य से बढ़े चलो
चन्द्र से बढ़े चलो

वीर तुम बढ़े चलो
धीर तुम बढ़े चलो

Vocabulary.com Review

Recently I came across this website called http://www.vocabulary.com/ .I discovered that this is an amazing vocabulary building tool. Some of the interesting aspects of this website are

• Facebook Login
• GRE and GMAT style of questions which further help in exam preparation.
• A social game environment with ability to compare the learning experience with other users of the site or your Facebook friends who use this site.
• Encouraging tokens of good performance when you get a specified set of questions right in a series.
• Adaptive learning
• Repetition of words and questions which were answered wrong once so as it get meaning the registered in the mind
• graphical tools to track progress and performance
• Quick reference dictionary and thesaurus
• 40000+ questions
• The system builds a model based on your performance as you progress and tries to teach words that you most probably do not know based on the model
• last but not the least its free

I have personally learnt a lot of new words with the help of this site. All my friends whom I suggested this site gave an extremely positive feed back. This is one resource where the domain name says it all.

Best Job Search Resources

The following is an excellent article on Job search resources categorized by industry and organised alphabetically. I will edit the original blog later and more content

http://newgradlife.blogspot.com/2009/12/top-100-niche-job-sites.html

If any of you know more resources, then add it to comments. I will definitely add them to the list when I edit this blog in future. Lets help the New Grads and others seekings Jobs

Google Wallet possibilities

Lets get to some basics of the product before we discuss the scope

Google Wallet Launch Video

Following are some of the Highlights of google wallet
1) stores credit cards
2) stores loyalty cards
3) stores coupons
4) one tap transactions at point of sale

what more can be expected as product matures
1) suggestions on which credit card(cash cards, rewards cards etc) or coupon to use based on type of card and its features. Nowadays cash cards offer a standard percentage of cash back but also extra cash back on specific types of products in specific months for which the user needs to sign up. same is the story with rewards cards

• google can suggest based on transaction history of millions of customers on the type of card and coupon used. Here the idea is to utilise collective intelligence 
• various combinations of coupons and credit cards can be iterated over based on the features of the card and the offers in the coupon, and finally a suggestion can be made to use a specific card and coupon at the point of sale

2) send alerts to avoid over the credit limit transactions which can happen by mistake. A lot of times users forget to keep track of some of the recent transactions which are still in pending state

3) product bill labels can be scanned by the users as they pick the products to purchase and list can be sent wirelessly to the systems at the point of sale. user can tap their phone once to bring up their record and tap second time to complete the transaction. If a lot of point of sales systems are installed through out the store, experienced users can complete the transactions themselves avoiding the lines and not taking any help from the sales agents.

4) Merchants can have an account with google and get away with having a billing system at all on their end. google wallet can be integrated with a billing engine. just like user receives reports after on their transactions, merchants receive reports on their sales and of course they should be able to customize the reports and even be able to submit them to the government for tax puposes