Hi Palitoy,

I need another perl script. To process lots of files. To find the
files you can do a (OPEN, `find . -name '*rpt').

Each file will contain entries in columns like (tab or single or
multiple space seperated)

rubish a/b/c/d number rubish rubish rubish word
so an example would be

pin d/e/f/g -0.039 74.00 daft stupid Hello
pin g/h/i/j -0.40  56.00 joe  dave   Hello
pin d/d/d/g -0.139 74.00 daft stupid Hello

next file would be 

pin g/g/i/j -0.40  56.00 joe  dave   Hello1
pin d/e/f/g -0.059 74.00 daft stupid Hello1
pin g/g/g/j -0.40  56.00 joe  dave   Hello1

There will be lots of these files to process (200) but typically they
are small 30 lines or so.

What I want out is (tab seperated)

         Hello   Hello1
d/e/f/g -0.039   -0.059
g/h/i/j -0.40  
d/d/d/g -0.139
g/g/i/j          -0.40  
g/g/g/j          -0.40  

i.e. the match across files is on column 1 (d/d/d/g) only
If column1 matches a row that is already there put column2 on the same line.
If column1 does not match then add a new row.

Column2 goes under a column given by the name in column6. 
Column6 will be the same within each file but unique across files.

Does this make sense?

Thanks,

Mick

---

Request for Question Clarification by palitoy-ga on 12 Aug 2004 03:22 PDT

Hello Mick

Thanks for posting another question for me.  I will look at this this
afternoon and get back to you with any questions that I have.

Hello Mick

Once again, thank-you for asking this question.

I have posted the script in the .zip file at this location for you to collect:
http://www.rh007b3221.pwp.blueyonder.co.uk/386843-ga.zip

As soon as you have rated the answer I will remove the link.

If you have any problems with the script please let me know and I will
do my best to fix them promptly.

SCript perfect as usual! 

Thanks,

Mick

Thanks for the 5-star rating and generous tip!  They are both appreciated.