JAN 11, 2010 5:07am ET

Related Links

Analytics: Needing to Know or Wanting to Know?
April 9, 2014
Many Utilities Yet to Understand Full Potential for Big Data Analytics
April 7, 2014
Majority of Health Organizations Have Not Implemented BI System
March 6, 2014

Web Seminars

April 29: Create a data protection strategy with open, software-defined storage
April 29, 2014
New Best Practices To Manage Customer Information
May 7, 2014
May 13: Cost-effective, scale-out backup in 1 solution
May 13, 2014

Ruby Monday – Part 1


About a month ago, I downloaded an open source visualization tool for a quick evaluation. I had planned on using my trusty 276,000 record, several dozen attribute delimited file of census data to see how the tool performed with real world volumes. Alas, I ran into a problem right away. My data file, which consists of roughly equal numbers of numerics and string fields interpreted as category values, failed the load. It seems the tool could only handle commas as delimiters, whereas my file used semi-colons. And I couldn't simply change all semi-colons to commas, since the text fields had embedded commas that would subvert the load with a comma delimiter. What I needed to do was first surround each text field with quotes to protect the embedded commas, then change the semi-colon delimiter to a comma.

Get access to this article and thousands more...

All Information Management articles are archived after 7 days. REGISTER NOW for unlimited access to all recently archived articles, as well as thousands of searchable stories. Registered Members also gain access to:

  • Full access to information-management.com including all searchable archived content
  • Exclusive E-Newsletters delivering the latest headlines to your inbox
  • Access to White Papers, Web Seminars, and Blog Discussions
  • Discounts to upcoming conferences & events
  • Uninterrupted access to all sponsored content, and MORE!

Already Registered?


Comments (2)
Hi Steve, sounds like an interesting Ruby script, mind sharing the code? :)
Posted by Glenn C | Wednesday, January 13 2010 at 4:16PM ET
Nice website! I adore a couple of of the articles that have been written, and especially the comments posted! I am going to definately be returning!

Wii accessories

Posted by wardell77925 w | Wednesday, March 30 2011 at 2:07AM ET
Add Your Comments:
You must be registered to post a comment.
Not Registered?
You must be registered to post a comment. Click here to register.
Already registered? Log in here
Please note you must now log in with your email address and password.

Are you actively evaluating master data management technologies and their ability to scale and support emerging trends around big data, social and mobile?

Yes 61%
No 23%
Don't Know 9%
Not Applicable 6%


Login  |  My Account  |  White Papers  |  Web Seminars  |  Events |  Newsletters |  eBooks
Please note you must now log in with your email address and password.