Visit Our UNIX and Linux User Community


appending files


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers appending files
# 1  
Old 11-05-2002
appending files

I have 25 transaction files that need to be put into one file and have the date of the file appended at the end of the line, anyone got a one liner or simple script to help me out

thanks
- Ed
# 2  
Old 11-05-2002
Ed,

If the files are by themselves in a directory, you should be able to put something together quickly with the following pieces:

The "for" Loop

Using "cat" and ">>" (append) within the "for" loop
EXAMPLE: cat variable_holding_filename >> final_file

Not exactly sure what "at the end of line" means, but you should be able to use the following pieces in a single command:

"ls -l" "awk" and ">>"


Biker
Systems/Network Administrator
LiveFire Labs - Hands-On Technical e-Learning
www.LiveFireLabs.com
# 3  
Old 11-05-2002
by end of line I mean the file layout is like this:

A,B,200210,S, A

if the file date was oct 9 i want the master file record to look like this:

A,B,200210,S, A,Nov 9

I good to go creating the master file its just a matter of putting the date at the end for that file I'm having problems with, some honcho wants this so he can open it in excel

I can even put the date on the individual files first before combining them but I'm stuck there

thanks
# 4  
Old 11-05-2002
I'm not sure that I'm following this. But you can do this:

DATE="Nov 9"
sed 's/$/,'"${DATE}/" < inputfile

Is that what you're looking for?
# 5  
Old 11-06-2002
here's what I ended up with thanks for all the input
Code:
#!/usr/bin/ksh

for i in `ls -lrt 0210*.dat|cut -c 55-66`
do
        echo $i
        DATE=`ls -l $i|cut -c 41-48`
        inputfile=$i
        echo $inputfile
        sed 's/$/,'"${DATE}/"  $inputfile >> master.dat
done

added code tags for readability --oombera

Last edited by oombera; 02-18-2004 at 07:59 PM..
 

Previous Thread | Next Thread
Test Your Knowledge in Computers #344
Difficulty: Medium
In February 2005, Sun announced the Sun Grid, a grid computing deployment on which it offered utility computing services priced at US$2 per CPU/hour for processing and per GB/month for storage.
True or False?

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Appending multiple files

I am trying to append multiple files in a directory cat /a/file1.txt /a/file2.txt /a/file3.txt /a/file4.txt > /a/file.txt Except file2 every other file is appending. I interchanged file names and ran the command. Whatever file repeating in the second position is missing in output... (6 Replies)
Discussion started by: eskay
6 Replies

2. UNIX for Dummies Questions & Answers

Appending two text files

Hi, i am using unix server and bash shell.. i have two csv files... i have file 1 as below... arun bvb ssx ccc and file 2 as below manas friu dfgg cat (3 Replies)
Discussion started by: arunmanas
3 Replies

3. Shell Programming and Scripting

Appending two files vertically

Hi Need ur help for the below question. I have two files File-1 & File-2. File-1(This is a fixed file i.e. the content of this file is not going to change over a period of time) ------ a b c d e File-2 (This is a file which changes daily but the record count remains the same)... (1 Reply)
Discussion started by: 46019
1 Replies

4. Shell Programming and Scripting

Appending all files that are in a directory

Hi, This might be a question that has an easy solution but im new to unix. I have a project where I have to append files that are in a directory and then read those files out. can anyone help me this this problem??? thanks in advance, TDS (1 Reply)
Discussion started by: TDS
1 Replies

5. Filesystems, Disks and Memory

Appending files to a tape drive

I've starting playing with a tape drive for the first time. Its a new one, an IBM Ultrium LTO 4. After initially copying a file to the tape with tar cvf /dev/st0 /root/dummy, all subsequent files appended take an increasing amount of time with tar rvf /dev/st0 /root/dummyX. Is it normal for each... (2 Replies)
Discussion started by: jeriryan87
2 Replies

6. Shell Programming and Scripting

Appending a string to all files in a directory

Hi, I will have to append a common string at the beginning of each and every line to all files in the same directory. How do i do this? (1 Reply)
Discussion started by: ragavhere
1 Replies

7. UNIX for Dummies Questions & Answers

appending variable number of files

In a particular path of a server I have number of files.The files are generated every date with a date_mth stap on this.There are different files for different clients. For example in /data1 path i have X_0416_Score Y_0416_Score Z_0417_Score X_0417_Score A_0417_Score If i will run the... (1 Reply)
Discussion started by: dr46014
1 Replies

8. UNIX for Dummies Questions & Answers

Appending the two files

hi, I want to append to two files into a third file without new line like this: file 1: I am learning the unix file 2: Unix is very intersting When I am trying cat file1 file2 >> file3 I am getting: I am learning the unix Unix is very interesting But I want that to be in... (3 Replies)
Discussion started by: harish409
3 Replies

9. UNIX for Dummies Questions & Answers

appending strings in the files

I have some files created by a process in UNIX. I wanted to do some file processing: 1. I want to append a string "EOF" as the first word on the last line of all the files except the last file. 2.Similarly, I want to append "BOF" string as the first word to all the files except the first... (2 Replies)
Discussion started by: vijaylak
2 Replies

Featured Tech Videos