Help with arranging data file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help with arranging data file
# 1  
Old 05-29-2008
Help with arranging data file

Dears,

I have the below data,

sss-aaaaaa
111211 222222 33333 22222 1163111
sss-vvvvvv
111311 224522 335633 24322 111511
sss-cccccc
111221 224522 333333 24322 111511
sss-dddddd
111211 222222 33333 22345222 113111

I want to make them like

sss-aaaaaa 111211 222222 33333 22222 1163111

sss-vvvvvv 111311 224522 335633 24322 111511

sss-cccccc 111221 224522 333333 24322 111511

sss-dddddd 111211 222222 33333 22345222 113111

Best Regards
# 2  
Old 05-29-2008
Code:
nawk 'ORS=(FNR%2)?FS:RS' myFile

# 3  
Old 05-29-2008
doesn't work Smilie
# 4  
Old 05-29-2008
Work's for me Smilie
Try to provide some info about your enviroment !
# 5  
Old 05-29-2008
1 - This smells like homework

2 - It works for me, and I don't have a clue what the nawk command is doing. (Heck, up until a couple days ago, I never even knew about the nawk command.)
# 6  
Old 05-29-2008
I changed the shell and it worked, thanks a lot,
could you explain this code for me, Im new to unix and I feel that this is 2 much for me Smilie
By the way Mr. Dave, this is not a home work, this is a part of my job duties !!!
# 7  
Old 05-29-2008
Quote:
Originally Posted by vgersh99
Code:
nawk 'ORS=(FNR%2)?FS:RS' myFile

ORS - OutputRecordSeparator
FNR - FileNumberRecord counter
FS - FieldSeparator
RS - RecordSeparator (similar to ORS, but for INPUT)

(FNR%2) - modulo of 2 of the current record/line number

if ( modulo of 2 of the current record/line number) is not '0' (odd record/line number), assign a value of 'FS' to ORS (space by default) - this joins 2 sequencial lines. Otherwise, assign the value of RS (new line by default) to ORS - this goes to the next line of output.

Because there's no explicit action associated with the 'if/test' condition, the default action is to print the current record/line.

So what happens is we keep joining the TWO adjacent lines to each other. If you change '2' to '3' - you'll be joining THREE adjacent lines of input to ONE line of output.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sorting/Arranging file based on tags using awk

Hi, I have file which contains data based on tags. Output of the file should be in order of tags. Below are the files : Tags.txt f12 f13 f23 f45 f56 Original data is like this : Data.txt 2017/01/04|09:07:00:021|R|XYZ|38|9|1234|f12=CAT|f23=APPLE|f45=PENCIL|f13=CAR... (5 Replies)
Discussion started by: Prathmesh
5 Replies

2. UNIX for Beginners Questions & Answers

Help arranging text

By using this code how can we get the stars in inverted positions? str="*" for i in 1 2 3 4 5 do echo "$str" str="$str *" done The output should be like this * * * * * * * * * * * * * * * Please use CODE tags as required by forum rules!... (5 Replies)
Discussion started by: Meeran Rizvi
5 Replies

3. Shell Programming and Scripting

Need help in arranging data

I have a file with user activity and need to display only the start and end timestamp of the activity. I don't know how can we write an logic for this please help me in a bettr way to work on it User Activity_log ----------------------------------- ... (5 Replies)
Discussion started by: lazydev
5 Replies

4. UNIX for Dummies Questions & Answers

Arranging columns in a line

Hi, Please give a solution... Current File 200101701 A 5 B 283 D 222 200085506 A 5 B 6 C 304 200081406 A 5 200101784 D 1111Desired Output 200101701 A 0005 B 0283 * * D 222 ... (4 Replies)
Discussion started by: satyar
4 Replies

5. Shell Programming and Scripting

Need Help in arranging the output

Hello All, Please find attached input and output files. I want to write a shell script to achieve this. I tried using awk but not getting how to do this as I am new to shell programming. Thanks (4 Replies)
Discussion started by: Sudeep Bhattad
4 Replies

6. UNIX for Dummies Questions & Answers

Arranging data

I have thousand lines of data...: A 1 B 2 C 3 D 4 E 5 A 21 B 22 C 23 D 24 E 25 A 31 B 32 C 33 D 34 E 35 ........... ON AND AND ON (3 Replies)
Discussion started by: bobo
3 Replies

7. Shell Programming and Scripting

need help in arranging the alias

Hello Guys, I have around 100 hosts setup as alias in my profile for easy sshing. alias ada='ssh -Y username@da.domain.com' alias ast='ssh -Y username@terix.domain.com' alias bb1='ssh -X username@ggserver.ns.domain.com' . . . . I now would like to use sshmenu software in which... (4 Replies)
Discussion started by: upengan78
4 Replies

8. Shell Programming and Scripting

arranging datas if input file is not having also...!!

hi, my input file is containg uid, eriMaster ,eriResign, ericontry, dept. some of the uid are not having all info. out put should include all info irrespctive of datas of input file if any one data is missing, then it has to print Null or zero..then continue with the existing one. here... (0 Replies)
Discussion started by: hegdeshashi
0 Replies

9. Shell Programming and Scripting

Arranging files

Hi all, This is program to identify and arrange programs(scripts) based on their she-bang values to a folder with the same name. The parts of mkdir and copy and creating problems.I also doubt the use of hash...maybe some problems in it. Please help out debugging this. Code pasted at: Paste... (2 Replies)
Discussion started by: Vivek788
2 Replies

10. UNIX for Dummies Questions & Answers

re-arranging text in a file with AWK

Hi Gurus, I have a text file that I want to process with the following structure; 4528788 Blah - Something 9341423 Text - Somethinghere 98792223,5546761 Some - More - Text 5119503,5159504,1234567 Text - More - Text 13459695 Stuff - Text Again 13526583 Junk - More Text Here 13595177... (1 Reply)
Discussion started by: th3g0bl1n
1 Replies
Login or Register to Ask a Question