June 3, 2010 in Quick Fixes by Rajendra
Changing field separater in CSV files
Many times it is needed to save excel sheet as Comma Separated Value (CSV) text file to import in the MySql database. Usually when you save file as CSV file the fields are separated by “,”; but sometimes this causes problems in field separation if the content also contains comma.
To define a unique field for your CSV file field separator in your Windows Vista/XP systems, follow the following steps:
- Open control panel.
- Open “Regional and Language Options”.
- In “Formats” tab click “Customize This format”.
- Then in the list separator text box enter the desired field separator and click “ok”.
- Click “Ok”.
Now when you save your excel file as CSV, the new field separators will be used.
Post comment
Search the site
Random Testimonial
- ~ Elance ID – ingariza
"This is the first time I used Elance, and I was blessed having Nirvaat as my provider, very professional, pro-active, great communication , on-time delivery, solve every problem I had. I recommend Nirvaat if you want your job on time, with quality and great support. Thanks" - Read more testimonials »
What's the little bird saying?
- Do u have an image and need a color scheme for your website around it. This is what u are looking for: http://www.degraeve.com/color-palette 2010-08-01
- Design a color scheme for your websites at: http://colorschemedesigner.com/ 2010-08-01
- New blog post: MySql Dump Using a PHP Script http://www.nirvaat.com/blog/web-development/mysql-dump-using-php-script/ 2010-07-25
- @pavanagrawal If computers will start asking questions then who will answer it!!!!! we have to creat a human version of google! in reply to pavanagrawal 2010-07-17
- Turn a USB Flash Drive Into Extra Virtual RAM [USB Drive] http://bit.ly/cb9fOT 2010-06-28
- More updates...
Posting tweet...