in reply to Making commond for large number of files

What do the input lines look like? We know one line in the file contains "SCF Done = 999" but then you talk about column 3. What does the rest of that line look like? Is it comma or space or tab delimited? Or is column 3 in a different line than the "SCF Done" line?

Assuming file 2 contained the lowest SCF, do you want something like the following (where 99 stands in for the actual column 3 value minus the lowest SCF)?

file1    99
file3    99
...
file200  99

[download]
Dum Spiro Spero

Replies are listed 'Best First'.
Re^2: Making commond for large number of files
by acrobat118 (Initiate) on Apr 17, 2015 at 15:43 UTC

    Thanks for your reply. Each files contains information in number and alphabets. There are two things which I need from each file. One is the SCF Done that is energy like SCF Done =0.56846. Second is a column with electron delocalization papameter that a long column with number but column header is (EDu). I want to. 1. Which file among 200 files have lowest SCF Done. 2. Then I want to use the (EDu) column of this minimized SCF Done file from step 1 to get the difference of (EDu) of all remaining 199 files and want to get result in a text file. For example if (EDu) of minimum SCF Done file be (EDu)min. I want (EDu)min - (EDu)1, (EDu)min - (EDu)2.......... where 1, 2, 3..... represent the name of all files in the directory.

[reply]

      You just repeated what you said in the first post, but did not answer my questions.

      Can you post a small sample of the contents of one of those 200 files?

      Dum Spiro Spero
[reply]

        I apologize. I am a new user that is why I could not write properly. Here is my Output file in real Format. I shall be careful next time.

[reply]

[reply]

In Section Seekers of Perl Wisdom