how can i do this mapping between 2 txt files

Question

0.00/5 (No votes)

See more:

I have text file contains data like as:

ID 1 Name Mary Mark 89
ID 2 Name Mai Mark 67

and I have another text file contains data :
ID Mobile
1 0993209320
2 0943043094

I want to create excel file which contains only two columns:
Mobile Message
0993209320 ID 1 Name Mary Mark 89
0943043094 ID 2 Name Mai Mark 67

how can i do this mapping between 2 text files based on ID to obtain the previous excel file in c#?

Posted 11-Sep-13 2:27am

Member 10220821

Add a Solution

Comments

ZurdoDev 11-Sep-13 8:38am

Just write the code and process it.

3 solutions

Solution 1

You can use String.Split[^] or a combination of String.IndexOf[^] and String.Substring[^] to isolate the ID.

Posted 11-Sep-13 2:40am

BotCar

Solution 2

There are few ways:

1) using ADO.NET
Much ADO About Text Files[^]
How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET[^]

2) using StringReader[^] class to read text files and Split[^] method.
How to: Read Text from a File[^]
How to: Split Strings (C# Programming Guide)[^]
You did not specify the method you're using to write to Excel file, so i can't help you more ;(

Posted 11-Sep-13 3:01am

Maciej Los

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)

CodeBlack · Accepted Answer · 2013-09-11T03:14:00

Suppose my text file info.txt contains below data :

VB

ID 1 Name Mary Mark 89
ID 2 Name Mai Mark 67

and my text file Mobile.txt contains below data :

VB

ID Mobile
1 0993209320
2 0943043094

Here I would suggest to create one student class with two properties Mobile and Message. And add all the mappings into list object of that class as mentioned below :

C#

var infos = System.IO.File.ReadLines("C:\\CodeBlack\\Info.txt");
            var mobiles = System.IO.File.ReadLines("C:\\CodeBlack\\Mobile.txt");

            var studentInfo = new List<Student>();
            studentInfo.Add(new Student
                {
                    Mobile =  "Mobile",
                    Message = "Message"
                });

            foreach (var info in infos)
            {
                var id = info.Split(' ')[1].ToString();

                var mobile = string.Empty;
                mobile =  mobiles.Where(m => m.Split(' ')[0] == id).Select(m => m.Split(' ')[1]).FirstOrDefault();

                studentInfo.Add(new Student
                    {
                        Mobile = mobile,
                        Message = info
                    });
            }

Student Class :

C#

public class Student
    {
        public string Mobile { get; set; }

        public string Message { get; set; }
    }

Now you can use studentInfo to export it to excel.
Code for export to excel is easily available on net.

Regards,
CodeBlack