Using CSV

My recent projects involve the use of CSVs so I thought I should write about it and make this as a guide for web designers wanting to learn more than just web design.

CSV as defined in Wikipedia is a comma-separated values (or CSV; also known as a comma-separated list or Comma-Separated Variable) file format is a file type that stores tabular data.

CSVs are very useful for e-commerce sites as it can be used to bulk update a database (updating the products, prices, members etc at once). Although CSVs are is supposed to be a “comma separated” file format, many applications like X-Cart generates CSV, delimited by either semi-colon, or comma, or tabs. ClixGalore delimits CSV by tabs. This only means that delimiters can be any character defined by the programming instructions.

Browsing the Internet I saw this application that can read a csv file . Csv Reader is an extremely fast and stable .Net class for stream based parsing of virtually any commonly found delimited data format. It handles quoted fields, delimiters in the data, and even data that spans across multiple lines. This gives you the ability to open csv files, edit csv files, and save csv files all directly from code.

Check my other posts:

1. About Phishing Sites
   After years of working on different servers for several clients...
2. Change .php to .html using .htaccess or httpd.conf
   It is common that when a site already has so...
3. Privacy Policy
   I respect your privacy and I am committed to safeguarding...
4. SEO friendly redirect domain.com to www.domain.com
   Last week, I noticed that there is a PageRank difference...
5. Is the book Rich Dad Poor Dad full of Crap?
   Personally, I loved the book. At first glance on the...
6. Ballet Manila’s Romeo and Juliet at Trinoma
   Tonight (6pm) there will be a presentation of Ballet Manila’s...
7. ABS-CBN and YouTube and Copyrighted Video
   Today I got this email from YouTube saying they removed...
8. Top 13 tips on getting on a taxi in Metro Manila
   Having lived in Metro Manila for 5 years now, I...
9. ABS-CBN and GMA Network Wars
   It has been almost a month now that we see...
10. Watching Cable TV on my PC / Laptop / Desktop
    I am very happy to have found this software: TVUPlayer....

Alfredo is a web designer, programmer and a search engine marketer from the Philippines. He is also an amateur photographer and loves to travel. He can be found on Twitter, LinkedIn and Facebook. Questions? Send him an email.