UNIX for Dummies Questions & Answers

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

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

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

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?

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