Hi,

We have Multiple source files which has some data, I need a K shell script which will append number '1' as the last character to all the lines of the first file and then increments the value and appends '2' to all the lines to the next file and so on.

For Example

Incoming file 1

a,aa,aa,a,aa
b,bb,bb,b,bb

Incoming file 2

c,cc,cc,c,cc
d,dd,dd,d,dd

the Output should be

Incoming file 1

a,aa,aa,a,aa,1
b,bb,bb,b,bb,1

Incoming file 2

c,cc,cc,c,cc,2
d,dd,dd,d,dd ,2


Can anyone Plz help me on this.

Thanks
Sunny.

Can you explain what you have so far, and what you're having trouble with? Post your sample script, and we'll see how we can assist.

Regards

I am getting the header and detail records in the same file. they dont have a common key. what i am supposed to do is to break each file depending on a fixed header rows and then load them to a seperate file, But we need a Common key to join them in the ETL so the Number i wanted to append at the end of each record will act as a reference and helps me to do that. I am able to split the File in to 2 parts depending on the no of header records.

but where i am stuck is i have to append a number at the end of each line in a file and that number needs to increment for each file

Below is my code

#Arguments
DIRECTORY=$1
FILE=$2
NO_HEADER=$3

#Validating the Arguments

if [ $# -lt 1 ]
then
echo
echo "\n Error :$0 Usage Input File \n"
echo
exit 1

# splits up the Header File

head -$NO_HEADER $DIRECTORY/$FILE > $DIRECTORY/${FILE}.head

echo `cat $DIRECTORY/${FILE}.head | awk 'BEGIN {FS = "," } ; { printf ("%s,", $2) }'` > $DIRECTORY/${FILE}.Header

rm -f $DIRECTORY/${FILE}.head

#calculates the remaining records in the File and writes them into the Detail file

NO_TAIL=`expr $NO_LINES - $NO_HEADER`

tail -$NO_TAIL $DIRECTORY/$FILE > $DIRECTORY/${FILE}.detail

Please help

assuming that you have already done a
var_dat="1" or whatever logic you desire

>sed "s/$/$var_dat/" sample.txt >output.txt

this will put the value of $var_dat at the end of every line of sample.txt, creating a new file output.txt

This will work if i am working with a single file, But i have multiple files and the variable value should increment for each file isn't it?

Try this if awk is allowed, it creats the files "newfile.1", "newfile.2", "newfile.3" and so on.

Regards