Search Results

Thanks so much! This was exactly what I was looking for.

Just in case this is useful to anyone else at any stage I then replaced the ^M characters created with $s using:

sed 's/^M/$/g' file1...

Hi again, thanks for your help with this!

This file contains records matched on column 1 and column 4.

There can be up to four rows for each record, these rows appear sequentially on the...

From my test file, I should have 19 lines after the merge. I have 23. Maybe I would be best to use AWK to substitute the new lines based on the two conditions?

Hi, thanks for the response, but there are two variables that should match before joining the lines.

The first and the fourth columns have to match.

These will change after one line/two...

That's done the trick!!

Thanks a million!!

---------- Post updated at 08:43 AM ---------- Previous update was at 07:16 AM ----------

Sorry to come back to you on this again.

It seems...

Thanks for you response.

This hasn't done the trick for me though. The file that I'm working on is fixed length and contains both text and numerics throughout. The variables that I am matching...

I’m writing a bash shell script and I want to join lines together where two variables on each line are the same ie.

12345variablestuff43212morevariablestuff...