Data Extraction to csv

Question

0.00/5 (No votes)

See more:

Hey all,

I'm sorry first and foremost i have to declare that i am a programming blockhead. I need some quick help in this. And yes i wanna take up programming and am willing to learn but have not a clue what language i should take. I do however need quick aid in this one. Here goes nothing!

Alright, supposing i have thousands of text files containing details in such format, how do i put it in a csv with complete header.
==============
Company Name: Data Wizard Pty Ltd

Posted 28-Feb-10 22:41pm

sheilasaunders

Updated 1-Mar-10 0:15am

v3

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Alaric Dailey · Answer 1 · 2010-03-01T05:14:00

CSV sounds like an easy format, until you look at embedded quotes and commas and line feeds in the file and forget about binary data.

If you must go down this road, you have quite a bit of work to do it right, unless you use a library.

XML files are MUCH more flexible.

Language choice is totally up to you. Higher level languages are easier to manipulate strings, and my personal choice is c#.

sheilasaunders · Answer 2 · 2010-03-01T05:18:00

Solution 4

Actually i have been using textpipe from datamystic to sort the data out. What is left is just what i have posted here. As far as sorting out the format, textpipe has done beautifully. Do point me what i need to look at if i want to use C. Thank you.

Rgrds,
Sheila.

Posted 1-Mar-10 5:18am

sheilasaunders

Bassam Abdul-Baki · Answer 3 · 2010-10-22T15:45:00

Solution 5

Try looking at Awk or Microsoft's LogParser. Not sure what your file format's are. If they really are logs, analog.cx would also be very useful.

Posted 22-Oct-10 15:45pm

Bassam Abdul-Baki