Shell Programming and Scripting

Thanks a lot guys..but frankly speaking I did not get what will be the right code to use :-(..I am new to UNIX and this is part of my first assignment in UNIX..and please let me know how to append the timestamp of the file at the end of each record while merging the all files..Thanks again.

---------- Post updated at 09:45 AM ---------- Previous update was at 09:34 AM ----------

I am using the code:

Code:

ls -1rt | while IFS= read -r f; do [[ -f $item ]] && cat $item >> /work/scripts/acu/outputfile.txt ; done

but it is not working

---------- Post updated at 10:33 AM ---------- Previous update was at 09:45 AM ----------

I have used:

Code:

for f in $(ls -tr); do cat "$f" >> /work/scripts/acu/my_accumulated_data_file; done

This is merging all the files in order to timestamp of the file but sometime the first line in the new file is starting from the new line and sometime from the end of the last line of the previous file

I have tried this as well:

Code:

ls | while IFS= read -r f; do cat "$f" >> /work/scripts/acu/outputfile.txt ; done

The new line issue is here also and it is not following any order in mergeing the file it seems.
Please advise as it is urgent. And how to append the timestamp (the timestamp when the file placed in the folder) at the end of the each record of that perticular file.

Thanks

Code:

ls -1rt | while IFS= read -r item; do [[ -f $item ]] && { cat $item; stat -c %y $item; } >> /work/scripts/acu/outputfile.txt; done

Hi Lem,

i am getting error that "stat: not found." for all the files in the folder.
The first line of all the files are not starting from the new line as well.

It probably means what it says. It checks in the current folder for a file named "a.txt" or whatever, and it's not there.

I'm guessing you're not listing the current, hence why it can't find those files -- it's looking in the wrong place.

Prepend the path that ls removed.

Code:

ls -1rt folder | while IFS= read -r item; do [[ -f $item ]] && { cat folder/$item; stat -c %y folder/$item; } >> /work/scripts/acu/outputfile.txt; done

ohh..is it for .txt only??can't we do it for any kind of extension?(.dat,.trg etc)..and what about the new line :-(

Why on earth would you want the file contents dumped into the logfile if they weren't text? You won't be able to read them...

What about the newline? I don't understand the problem you're having. Show an example of the bad output.

ok..I should have explained the scenario at the very beginning itself.
Different users can put some information in pre-defined format (180 bytes) in a file which may end in .dat or .trg or .txt. We have to merge all this data in one file and then load them in teradata.(to know what record came when we want to append the file timestamp at the end of each record which will be then inserted to teradata).
If this code will work for .txt only we can ask users to put the files in .txt format only but it will be better if there will be no bar on extension.
The new line character issue is: After merge,the first record of the new file is starting from the end of the last record of the earlier file. Can't we have all the records starting from the new line?