Is it possible to compare CSV data w/o Importing in a Data Table?

Question

1.00/5 (1 vote)

See more:

I'm trying to compare data from a CSV file without importing it in a Data Table. Is it possible?

I need help on this one, please.
Thanks.

Posted 12-Jan-14 21:43pm

Karen Mitchelle

Add a Solution

Comments

OriginalGriff 13-Jan-14 3:48am

You'll have to be a bit more specific than that: of course it's possible, but exactly how depends on what you are trying to compare it with, how you need to compare it and so forth.

Karen Mitchelle 13-Jan-14 4:22am

for example, i have lines of transaction, i have to know all the transactions that has the same transaction time, price, stock but it must be on the different side (buy or sell).
i tried to import it on a data table before comparing it. but my teacher wants me to do it directly. not using a data table. I mean..

OriginalGriff 13-Jan-14 4:49am

So what has your teacher taught you to do to load a CSV file?
There are a lot of ways to do it, and I don't want to introduce something new in case that is not what he wants either.

Karen Mitchelle 13-Jan-14 4:56am

he doesn't give the specifics. all he wants is that I don't have to use a Data Table anymore. He said that after I browse the CSV file's location, and when i click the "Compare Data" Button, it will automatically compare the data inside the CSV file and finally give an output which is in a CSV format also.

OriginalGriff 13-Jan-14 5:06am

So how has he taught you to read a CSV file?

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Jan-14 3:48am

What have you tried and where is the problem?

Karen Mitchelle 13-Jan-14 4:18am

i have tried using data table but my teacher only wants to compare it directly. the problem is, i don't know how to compare it without the use of data table. comparing data from a data table is a lot easier, i think.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Jan-14 4:59am

Can you check - A Fast CSV Reader[^]?

1 solution

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)

CPallini · Answer 1 · 2014-01-12T22:02:00

Solution 1

Of course it is possible, you have to parse yourself the file and then perform the comparison. Loading it in a datatable could make your task easier, though.

Posted 12-Jan-14 22:02pm

CPallini