How to read text Delimited file

Question

0.00/5 (No votes)

See more:

C#

VB

ASP.NET

How to read text Delimited file

Posted 6-Dec-12 12:14pm

vikram5412

Updated 25-Dec-12 6:14am

v3

Add a Solution

Comments

Adam R Harris 6-Dec-12 18:27pm

Delete that entire sample right now, I'm sure your clients would be pissed right off to know you just posted their private information on a public website. Then take a small subset of your sample and replace the real world values with fictitious values so you don't violate any privacy laws.

After that loom at the StreamReader class and String.Split method

DinoRondelly 6-Dec-12 18:29pm

Good point and it looks like the Bank of India no less !!

vikram5412 8-Dec-12 9:05am

these are demo clients.

DinoRondelly 6-Dec-12 18:28pm

Reading the file is easy
Reading the file
using (StreamReader sr = new StreamReader("YOURFILE"))
{
//Do what you want
}

ThatsAlok 6-Dec-12 21:36pm

You might require custom parser for it... i could provide that service for charge :-) .. you need to parse the file, since being in banking domain, i can recommend you need to check incoming data for you your customized parser for example you might need to check header line for you incoming data, since it's for account balance report, it would be a contant format at header and only data would be changing. so you have read each line for possible custom scenario

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)

DinoRondelly · Answer 1 · 2012-12-06T12:32:00

Solution 1

This should help

Reading the file
http://msdn.microsoft.com/en-us/library/db5x7c0d.aspx[^]

Split the file
http://msdn.microsoft.com/en-us/library/system.string.split.aspx[^]

Posted 6-Dec-12 12:32pm

DinoRondelly

Comments

vikram5412 9-Dec-12 10:42am

Can read this file, but i need to read this file to read in grid view.