Improve company productivity with a Business Account.Sign Up


Concatenate files into one single file

Posted on 2014-02-26
Medium Priority
Last Modified: 2014-02-26
I am trying to concatenate the following individual files into one file based on the current date that is attached to the individual file names.
For eg: There could be several files. One of the file name appears like SVCTURN_ON_SO2_29JAN2014_075144.txt and another as PNDGSVCORD_SO1_29JAN2014_075153.txt and so on..
I need to find a way to concatenate these individual files that includes the current date in the name.
Question by:baralp
  • 3
  • 3
  • 2
  • +2
LVL 75

Expert Comment

by:käµfm³d 👽
ID: 39889175
Are you familiar with the cat command?

Author Comment

ID: 39889205
yes I am familiar with cat. I can do something like this cat *.txt >> all.txt. But I don't know how to concatenate those files that have current date attached in the file name. For eg. you can see the current date on the file SVCTURN_ON_SO2_26Feb2014_075144.txt that I need to look to concatenate.
LVL 23

Expert Comment

ID: 39889210
This should do it:

for i in `ls | grep 29JAN`; do cat $i >> newfile.txt; done

It will find all the files in the current working directory that have 29JAN in them (current date) and then one by one put the contents of that file into newfile.txt.
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

LVL 13

Expert Comment

ID: 39889223

## date format ##

## Backup path ##

for i in /etc/logs/*
cat $i >> $FILE

This should do close to what you want. May need to change the paths/names etc but just put this into a shell script and run it.

Author Comment

ID: 39889383
In your command for i in `ls | grep 29JAN`; do cat $i >> newfile.txt; done
Can we replace 29Jan with the current date variable since the file name changes according to the run date?
LVL 13

Assisted Solution

Sean earned 668 total points
ID: 39889420
now=$(date +"%m_%d_%Y")

for i in `ls | grep $now`; do cat $i >> newfile.txt; done

This will use the current date.

Author Comment

ID: 39889438
I think now=$(date +"%m_%d_%Y")  would be now=$(date +"%d_%m_%Y") as the file name appears like SVCTURN_ON_SO2_26Feb2014_075144.txt. Correct?
LVL 13

Expert Comment

ID: 39889446
Yes you can change it to match the file.

see reference for the different ways to use the date command.
LVL 23

Accepted Solution

savone earned 668 total points
ID: 39889754
Yes, but it has to be in the format that is in the filename.

Try this:

today=`date +%d%b`; for i in `ls | grep $today`; do echo $i >> newfile.txt; done

This will format the date to look like this: 26Feb

Which matches the examples you provided.
LVL 48

Assisted Solution

Tintin earned 664 total points
ID: 39890583
Assuming the files contain the date format


eg:  26Feb2014

then you can simply do

cat *$(date +%d%b%Y)* >concatenated_file

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

The purpose of this article is to demonstrate how we can use conditional statements using Python.
Fine Tune your automatic Updates for Ubuntu / Debian
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

585 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question