Append multiple text files into single file and rename it

Question

0.00/5 (No votes)

See more:

Hello I have multiple text files in one location and they are like the name below :

A_L_PRTD_021345.txt , A_L_PRTD_432124 , like this ..

I want to merge them into single file and want to Rename the single file as L_PRTD_Currentdate>.txt

How can It be possible ? Kindly share me some cod of doing this

Posted 4-Jan-14 18:28pm

DEbopm

Add a Solution

Comments

Karthik_Mahalingam 5-Jan-14 0:31am

you want to append the text of each file into a single file ?

DEbopm 5-Jan-14 0:33am

Yes ,, A_L_PRTD_021345.txt , A_L_PRTD_432124 these are my files actually I have similar type of multiple files and Those will be combined and a single file will be generated.

DEbopm 5-Jan-14 0:39am

I have other file too in that location like A_L_UPSC_766655.txt. But Only I need to append the A_L_PRTD_ files to a single file.

Mitchell J. 5-Jan-14 0:43am

Did you see my answer?

Karthik_Mahalingam 5-Jan-14 0:49am

u mean, the location contains the file names starts with a_l_prt_ ...??

DEbopm 5-Jan-14 0:57am

location contains mixed files there are several A_L_PRTD files and there is one A_L_UPSC files and other A_L_ files are there. And yes I saw your ans. You have hardcoded the file names there. But the last digits are unknown for me and it could be different eah day . Like today 5 files can be there , tomorrow there can be 7 files and it can happen that tomorrow there can be 10 files . like this is not at all fixed.

3 solutions

Solution 1

try this

File.AppendAllText(Path, content);

Posted 4-Jan-14 18:38pm

agent_kruger

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)

Mitchell J. · Accepted Answer · 2014-01-04T18:39:00

Solution 2

Use System.IO.StreamReader/StreamWriter to read/write the text files.

For example...

C#

using System.IO;

DirectoryInfo di = new DirectoryInfo("<path to containing directory>");
FileInfo[] files = di.GetFiles();

string data = "";

foreach (FileInfo fi in files)
{
    if (fi.Name.ToUpper().StartsWith("A_L_PRTD"))
    {
        StreamReader rd = new StreamReader(fi.FullName);
        data += rd.ReadToEnd();
        rd.Close();
        rd.Dispose();
        //Optionally...
        File.Delete(fi.FullName);
    }
}

StreamWriter wr = new StreamWriter(string.Format("L_PRTD_{0}.txt", DateTime.Now.ToString("ddMMyyyy")));
wr.Write(data);
wr.Close();
wr.Dispose();

Posted 4-Jan-14 18:39pm

Mitchell J.

Updated 4-Jan-14 19:08pm

v7

Comments

DEbopm 5-Jan-14 0:46am

@CraigDJ .. I don't have only 2 files . I have multiple files which are starting as A_L_PRTD_<some number="">.txt and I have another files too like A_L_UPSC_<some number="">.txt. But Only I need to append the text of files like A_L_PRTD_<some number=""> in to one single combined file.

Mitchell J. 5-Jan-14 0:51am

So you have a significant number of PRTD files mixed in with the UPSC files?
And you only want to stitch the PRTD files together?

DEbopm 5-Jan-14 0:53am

yes . But I dont know how many PRTD files are there in that location. It is not fixed each day. Today It can be 12, Tomorrow It could be 15 , and day after tomorrow it could be only 1 ..

Mitchell J. 5-Jan-14 1:01am

I've updated my solution.

Karthik_Mahalingam 5-Jan-14 1:03am

5,good shortcut u have used for appending ...craigDJ .

Mitchell J. 5-Jan-14 1:07am

thanks!

Karthik_Mahalingam · Accepted Answer · 2014-01-04T18:44:00

Solution 3

try like this..

C#

string path = "D://Files//";
            //string[] fileNames = { "A_L_PRTD_432124.txt", "A_L_PRTD_021345.txt" };
            string fileNameStartsWIth = "A_L_PRTD_";
            string[] fileNames = Directory
                 .GetFiles(path, "*.txt", SearchOption.AllDirectories)
                 .Select(f => Path.GetFileName(f)).Where(k => k.StartsWith(fileNameStartsWIth)).ToArray();

            string finalFile = "L_PRTD_" + DateTime.Now.ToString("ddMMMyyyy") + ".txt";
            string contentSeperator = Environment.NewLine + "-----------------------------------------------------" + Environment.NewLine;
            foreach (string file in fileNames)
            {
                string content = File.ReadAllText(path + file) + contentSeperator;
                File.AppendAllText(path + finalFile, content);
            }

reference:
File.ReadAllText [^]

File.AppendText[^]

Posted 4-Jan-14 18:44pm

Karthik_Mahalingam

Updated 4-Jan-14 18:55pm

v3

Comments

DEbopm 5-Jan-14 0:49am

@KARTHIK ..
string[] fileNames = { "A_L_PRTD_432124.txt", "A_L_PRTD_021345.txt" }; This is showing that u are mentioning only for two files . But there are multiple files like the same name only the last digits are different and I dont know how many files will come . There may be 5 files and there could be 7 or rather 10. So this will not be statis as you mentioned but dynamic

Karthik_Mahalingam 5-Jan-14 0:55am

try updated solution..

Mitchell J. 5-Jan-14 0:58am

Nice solution :-)

Karthik_Mahalingam 5-Jan-14 1:00am

thanks criagDJ

Karthik_Mahalingam 5-Jan-14 1:13am

add these namespace

using System;
using System.IO;
using System.Linq;

DEbopm 5-Jan-14 1:16am

thanks @Karthik .. It worked..

Karthik_Mahalingam 5-Jan-14 1:18am

welcome :)

DEbopm 5-Jan-14 1:18am

hello I have one more concern here the file which is generated is like this : L_PRTD_05Jan2014. But I want the type like L_PRTD_05012014

Karthik_Mahalingam 5-Jan-14 1:21am

string finalFile = "L_PRTD_" + DateTime.Now.ToString("ddMMyyyy") + ".txt";

try this..

DEbopm 5-Jan-14 1:26am

yes that is coming like L_PRTD_05Jan2014. But I want like L_PRTD_05012014. instead of JAN 01 is needed.

Karthik_Mahalingam 5-Jan-14 1:31am

this should work fine.. "ddMMyyyy" it gives me as "05012014"
please check carefully..

DEbopm 5-Jan-14 1:34am

ohoo I missed one M here .. Thanks very much for your help @KARTHIK

Karthik_Mahalingam 5-Jan-14 1:37am

sometime it happens :)
welcome :)

DEbopm 5-Jan-14 1:37am

I have another questionaire on this section . In this file If I have duplicate rows then only single row will remain and the duplicate one should be deleted. how to remove duplicate rows from this text file.

Karthik_Mahalingam 5-Jan-14 1:40am

duplicate rows in single file or multiple files ?
duplicate in the sense ??
not getting it ...

DEbopm 5-Jan-14 1:45am

not multiple files . My text file content is like this :

AAA^123^BBB^321
ACV^432^DFC^765
BVC^555^UYT^435
ACV^432^DFC^765
AAA^123^BBB^321

So first row and last are repeating here and so as second and 4th line are also repeating. I want only one row should be there . So It would be looking like :

AAA^123^BBB^321
ACV^432^DFC^765
BVC^555^UYT^435

Karthik_Mahalingam 5-Jan-14 1:47am

ok got..

Karthik_Mahalingam 5-Jan-14 1:52am

try these lines

foreach (string file in fileNames)
{
string[] content = File.ReadAllLines(path + file).Distinct().ToArray() ;
File.AppendAllLines(path + finalFile, content);
}

DEbopm 5-Jan-14 1:48am

PLEASE HELP ME ..

Karthik_Mahalingam 5-Jan-14 1:54am

check ...

DEbopm 5-Jan-14 2:00am

Its only appending . Not removing the duplicate lines .

Karthik_Mahalingam 5-Jan-14 2:07am

try this.
string[] content = File.ReadAllLines(path + file).Select(k=>k.Trim()).Distinct().ToArray() ;

DEbopm 5-Jan-14 2:10am

same thing is happening . only Appending .

Karthik_Mahalingam 5-Jan-14 2:20am

post your data..

DEbopm 5-Jan-14 2:28am

A_L_PRTD_023456.txt :

AAA^123^BBB^321
ACV^432^DFC^765
BVC^555^UYT^435

A_L_PRTD_789653.txt:

AbA^123^BBB^321
AdV^432^DFC^765
BaC^555^UYT^435
AaV^432^DFC^765
ApA^123^BBB^321

A_L_PRTD_789654.txt:

AAA^123^BBB^321
ACV^432^DFC^765
BVC^555^UYT^435

and A_L_PRTD_877666.txt:

AQA^123^BBB^321
ACV^432^DFC^765
BPC^555^UYT^435
AIV^432^DFC^765
AGA^123^BBB^321

DEbopm 5-Jan-14 2:31am

I need to check it after the file will bve combined. I think you have write the code for checking before file is combining.

Karthik_Mahalingam 5-Jan-14 2:40am

in the above list of all single files, there is no duplicates..
it is working fine.. i tried with adding duplicate items..

DEbopm 5-Jan-14 2:43am

A_L_PRTD_023456.txt :

AAA^123^BBB^321
ACV^432^DFC^765
BVC^555^UYT^435

A_L_PRTD_789654.txt:

AAA^123^BBB^321
ACV^432^DFC^765
BVC^555^UYT^435

Two duplicate files are there and after combining the duplicate values remain same and just appending . I need to check after the files will be combined.

Karthik_Mahalingam 5-Jan-14 2:46am

you want to remove after combining??

DEbopm 5-Jan-14 2:50am

yes I want to remove after and before combining if any.

Karthik_Mahalingam 5-Jan-14 2:52am

try below code..

Karthik_Mahalingam 5-Jan-14 2:51am

try this code..

List<string> lstLines = new List<string>();
foreach (string file in fileNames)
{
string[] content = File.ReadAllLines(path + file).Select(k=>k.Trim()).Distinct().ToArray() ;
lstLines.AddRange(content);
}
var data = lstLines.Distinct();
File.AppendAllLines(path + finalFile, data);

DEbopm 5-Jan-14 2:52am

I have also tried :

string[] content = File.ReadAllLines(path + file).Select(k => k.Trim()).Distinct().ToArray();
File.AppendAllLines(path + finalFile, content);
content.Distinct().ToArray();

But it is not giving the result.

Karthik_Mahalingam 5-Jan-14 2:54am

try this code..

List lstLines = new List();
foreach (string file in fileNames)
{
string[] content = File.ReadAllLines(path + file).Select(k=>k.Trim()).Distinct().ToArray() ;
lstLines.AddRange(content);
}
var data = lstLines.Distinct();
File.AppendAllLines(path + finalFile, data);

DEbopm 5-Jan-14 2:56am

Its giving me the error like List require one type of Argument.

Karthik_Mahalingam 5-Jan-14 3:00am

exact error message pls

Karthik_Mahalingam 5-Jan-14 3:01am

in which line you are getting error

Karthik_Mahalingam 5-Jan-14 3:07am

add the namespace..

DEbopm 5-Jan-14 3:06am

List lstLines = new List(); - using the generic type system.collections.generic.list T> requires one type argument

Karthik_Mahalingam 5-Jan-14 3:10am

List<string> lstLines = new List<string>();

DEbopm 5-Jan-14 3:07am

I have this one .

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;

namespace ConsoleApplication2
{
class Program
{
static void Main(string[] args)
{
string path = "D:/Project/";
//string[] fileNames = { "A_L_PRTD_432124.txt", "A_L_PRTD_021345.txt" };
string fileNameStartsWIth = "A_L_PRTD_";
string[] fileNames = Directory
.GetFiles(path, "*.txt", SearchOption.AllDirectories)
.Select(f => Path.GetFileName(f)).Where(k => k.StartsWith(fileNameStartsWIth)).ToArray();

string finalFile = "L_PRTD_" + DateTime.Now.ToString("ddMMyyyy") + ".txt";

List lstLines = new List();
foreach (string file in fileNames)
{
string[] content = File.ReadAllLines(path + file).Select(k => k.Trim()).Distinct().ToArray();
lstLines.AddRange(content);
}
var data = lstLines.Distinct();
File.AppendAllLines(path + finalFile, data);

}
}
}

Karthik_Mahalingam 5-Jan-14 3:10am

try this
List<string> lstLines = new List<string>();

DEbopm 5-Jan-14 3:15am

Great ! It is working now. Thanks a lot dude for all your help throughout the day. Thanks a lot again and again ..

Karthik_Mahalingam 5-Jan-14 3:17am

welcome dude!!!
now i can take a big breath.. :)

DEbopm 5-Jan-14 3:35am

Yes Sir .. U are a true champ .. Thanks again .. See you later