I would like to write a script that takes something like this:
And makes it to look like this:
etc.
I would think it would be fairly easy to use two loops, one for the the 5-line pattern and one for each set of 5 lines. However, I am having trouble planning out the code because if I create a loop within the loop, I have problems figuring out how to control which line to read. Any suggestions?
Perhaps have a loop that would create 1 super long line but insert a counter to insert a line break every 5 lines?
Last edited by Scrutinizer; 11-22-2012 at 09:59 PM..
Reason: code tags
Can you explain what each component of the awk stmt means?
I am getting an error message:
(This was issued as a command, not as part of a script)
The paste command worked perfectly...actually too perfectly...because I found out that there are a few anomalies in the line sequences. Towards the end of the 50,000 lines in the file, the pattern changes to this:
And then it reverts back to the original pattern after those 2 sequences. I don't know why that's the case, but it's there.
You don't happen to know of any way to avoid that pothole, do you? (This is more wishful thinking)
Thanks for your help.
---------- Post updated at 12:31 PM ---------- Previous update was at 12:28 PM ----------
Oh I think if I can remove all blank lines in the file, then do a 4-line sequence, that should work as the 2-line sequences were actually halves of the 4-line sequence. So in light of that, how can I remove all blank lines from a file?
Last edited by Scrutinizer; 11-22-2012 at 09:56 PM..
Reason: code tags
The awk commands are probably because you are on Solaris, if so try nawk instead of awk. The awk solution uses blank lines to align so your two anomalies will come out as:
But this should avoid getting out of sync for the rest of the file which is probably safer in case of other issues like this at a later date.
If you want to stick with paste you can use grep -v "^$" infile > outfile to remove blank lines, and don't forget to remove one of the dashes from the paste arguments to reduce to a 4-line sequence.
If not all empty lines are completely empty but some may contain spaces then instead of grep you could use:
You could then try running it through paste like Chubler suggests:
--
On Solaris < version 11 use /usr/xpg4/bin/awk or nawk rather than awk
Last edited by Scrutinizer; 11-22-2012 at 10:13 PM..
Hello,
I have a bilingual database with the following structure
a,b,c=d,e,f
The right half is in a Left to right script and the second is in a Right to left script as the examples below show
What I need is to separate out the database such that the first word on the left hand matches the first... (4 Replies)
Hi, I have a rquirement in unix as below .
I have a text file with me seperated by | symbol and i need to generate a excel file through unix commands/script so that each value will go to each column.
ex:
Input Text file:
1|A|apple
2|B|bottle
excel file to be generated as output as... (9 Replies)
Hi How to make tab delimited file to space delimited?
in put file:
ABC kgy
jkh ghj
ash kjl
o/p file:
ABC kgy
jkh ghj
ash kjl
Use code tags, thanks. (1 Reply)
Hello folks, I have another doozy. I have two files. The first file has four fields in it. These four fields map to different locations in my second file. What I want to do is read the master file (file 2 - 23 fields) and compare each line against each record in file 1. If I get a match in all four... (4 Replies)
I have a file which was pipe delimited, I need to make it tab delimited. I tried with sed but no use
cat file | sed 's/|//t/g'
The above command substituted "/t" not tab in the place of pipe.
Sample file:
abc|123|2012-01-30|2012-04-28|xyz
have to convert to:
abc 123... (6 Replies)
Hi All,
I have space delimited file similar to the one as shown below.. I need to convert it as a pipe delimited, the values inside the pipe delimited file should be as highlighted...
AA ATIU2345098809 009697 005374
BB ATIU2345097809 005445 006518
CC ATIU9685098809 003215 003571
DD... (7 Replies)
i have a file whose data is like this::
osr_pe_assign|-120|wg000d@att.com|4|
osr_evt|-21|wg000d@att.com|4|
pe_avail|-21|wg000d@att.com|4|
osr_svt|-11|wg000d@att.com|4|
pe_mop|-13|wg000d@att.com|4|
instar_ready|-35|wg000d@att.com|4|
nsdnet_ready|-90|wg000d@att.com|4|... (6 Replies)
Hi all,
I have a file with single white space delimited values, I want to convert them to a tab delimited file.
I tried sed, tr ... but nothing is working.
Thanks,
Rajeevan D (16 Replies)