Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Reordering the File

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Reordering the File
# 1  
Old 05-03-2013
Reordering the File
Hello All,

I have a file which looks like below:

Code:
HLD_EA_0001X
HLD_DOORS_002X
HLD_EA_0002X
HLD_DOORS_003X
HLD_DOORS_0033
HLD_EA_0003X
HLD_DOORS_004X
HLD_DOORS_0032
HLD_EA_0004X
HLD_DOORS_005X
HLD_DOORS_0031
HLD_EA_0005X
HLD_DOORS_006X
HLD_DOORS_0029
HLD_DOORS_0030
HLD_EA_0006X
HLD_DOORS_007X
HLD_DOORS_0027
HLD_EA_0007X

Everything is in a single column.

I want to recorder the content put the details in a line:
Example:

Code:
HLD_EA_0001X   HLD_DOORS_002X
HLD_EA_0002X   HLD_DOORS_003X  HLD_DOORS_0033
HLD_EA_0003X   HLD_DOORS_004X  HLD_DOORS_0032

I hope you have understood my question
# 2  
Old 05-03-2013
Your example is incomplete and a little vague. If I've guessed correctly at what you want, the awk script below may do what you want:
Code:
awk '
/^HLD_EA/ {
        if(out) print out
        out = $0
        next
}
{       out = out "\t" $0
}
END {   if(out) print out
}' file

As always, if you're using a Solaris/SunOS system, use /usr/xpg4/bin/awk, /usr/xpg6/bin/awk, or nawk instead of awk.

With your sample input file, the output produced is:
Code:
HLD_EA_0001X	HLD_DOORS_002X
HLD_EA_0002X	HLD_DOORS_003X	HLD_DOORS_0033
HLD_EA_0003X	HLD_DOORS_004X	HLD_DOORS_0032
HLD_EA_0004X	HLD_DOORS_005X	HLD_DOORS_0031
HLD_EA_0005X	HLD_DOORS_006X	HLD_DOORS_0029	HLD_DOORS_0030
HLD_EA_0006X	HLD_DOORS_007X	HLD_DOORS_0027
HLD_EA_0007X

This User Gave Thanks to Don Cragun For This Post:
suvendu4urs
# 3  
Old 05-03-2013
Quote:
Originally Posted by Don Cragun
Your example is incomplete and a little vague.
@Don Cragun: That's because, it's a continuation of this thread Smilie
 
Login or Register to Ask a Question

Previous Thread | Next Thread

4 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script (sh file) logic to compare contents of one file with another file and output to file

Shell script logic Hi I have 2 input files like with file 1 content as (file1) "BRGTEST-242" a.txt "BRGTEST-240" a.txt "BRGTEST-219" e.txt File 2 contents as fle(2) "BRGTEST-244" a.txt "BRGTEST-244" b.txt "BRGTEST-231" c.txt "BRGTEST-231" d.txt "BRGTEST-221" e.txt I want to get... (22 Replies)
Discussion started by: pottic
22 Replies

2. Shell Programming and Scripting

Compare 2 text file with 1 column in each file and write mismatch data to 3rd file

Hi, I need to compare 2 text files with around 60000 rows and 1 column. I need to compare these and write the mismatch data to 3rd file. File1 - file2 = file3 wc -l file1.txt 58112 wc -l file2.txt 55260 head -5 file1.txt 101214200123 101214700300 101250030067 101214100500... (10 Replies)
Discussion started by: Divya Nochiyil
10 Replies

3. Shell Programming and Scripting

Match list of strings in File A and compare with File B, C and write to a output file in CSV format

Hi Friends, I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving... File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Discussion started by: asnandhakumar
6 Replies

4. Shell Programming and Scripting

awk - Matching columns between 2 files and reordering results

I am trying to match 4 colums (first_name,last_name,dob,ssn) between 2 files and when there is an exact match I need to write out these matches to a new file with a combination of fields from file1 and file2. I've managed to come up with a way to match these 2 files based on the columns (see below)... (7 Replies)
Discussion started by: ambroze
7 Replies
Login or Register to Ask a Question