Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Rearrange columns and rows with awk
Top Forums UNIX for Dummies Questions & Answers Rearrange columns and rows with awk Post 302334070 by Tom46 on Tuesday 14th of July 2009 05:02:35 PM
Old 07-14-2009
Rearrange columns and rows with awk
Hello, I have the following problem

I have two columns with numbers arranged as follows:
Code:
x1     y1
x2     y2
....
....
x250  y250

Now I need them arranged as follows:
Code:
"string a"
x1   y1
x1   y2
"string b"
"string a"
x1   y2
x2   y2
"string b"
"string a"
x2   y2
x2   y3
"string b"
"string a"
x2   y3
x3   y3
"string b"
...

I got the hint that this should be possible with awk, but did not find a command to write information from two different lines of the input-file in the same line of the output-file. (like for example x2 and y3)

Thanks for your support.

Next time use CODE-tags when posting code, data or logs to enhance readability and keep formatting like indention etc., ty.
Last edited by zaxxon; 07-17-2009 at 02:07 AM.. Reason: code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need help in AWK;Search String and rearrange columns

Hi AWK Experts, file1.txt contains: 29b11b820ddcc:-|OHad.perWrk|spn_id=AH111|spn_ordtyp=MY_REQ|msg_typ=ah.ntf.out|spn_ordid=928176|spn_nid=3|msg_strt=1175615334703|msg_que=oput|diff=371|17:48:55,074|17:48:55,084|10 file2.txt contains:... (2 Replies)
Discussion started by: spring_buck
2 Replies

2. Shell Programming and Scripting

Need help with a script to rearrange columns

I have a file that is semi-colon delimited and the column headers are always the same but the column number is totally random each time this file is generated. I don't have the skills to make a script for this so maybe someone can help. I would like to be able to take this file which has over... (11 Replies)
Discussion started by: n3al10
11 Replies

3. Shell Programming and Scripting

awk - reformating rows into columns

looking to do the following... What the data looks like server1 02/01/2008 groups 10 server1 03/01/2008 groups 15 server1 04/01/2008 groups 20 server2 02/01/2008 users 50 server2 03/01/2008 users 75 server2 04/01/2008 users 100 server2 04/01/2008 users 125 What I would like the... (1 Reply)
Discussion started by: jmd2004
1 Replies

4. UNIX for Dummies Questions & Answers

Convert rows to columns using AWK

Hi , I am struck while coding AWK script. Need your help to convert rows into columns. I should copy only those rows which are marked to Y in a file and ignore N rows. Please help me find a solution. input file 1|abc|Y 2|cdf|Y 3|efg|N 4|xyz|Y my output should be something like this... (2 Replies)
Discussion started by: rashmisb
2 Replies

5. Shell Programming and Scripting

Convert rows into columns using awk or perl

hi friends, i am able to parse cvs diff file using bit of cut and grep commands to produce following output in text file '''cvs-diff.txt''' Package-Name = dev-freetype. Old-Version = 2.4.8 New-Version = 2.4.10 Patches-removed = freetype-2.4.8-cross-compile.patch... (2 Replies)
Discussion started by: alexzander18
2 Replies

6. UNIX for Dummies Questions & Answers

Awk: convert rows to columns every n lines

Hi guys! I use AWK commands under GAMS to predispose the data files to be read by GAMS. I have a file which contains groups of data I need. Unfortunately I have the data spread in 3 rows for each subject. Here's an example (the file is really long) 1 0 2.0956 100.00 250.00 100.00 2.0956... (4 Replies)
Discussion started by: Pintug
4 Replies

7. Shell Programming and Scripting

awk to transpose every 7 rows into columns

input: a1 a2 a3 a4 a5 a6 a7 b1 b2 b3 .. b7 .. z1 .. z7 (12 Replies)
Discussion started by: ux4me
12 Replies

8. Shell Programming and Scripting

Rearrange a file (2000 base64 strings in 1 row into 1 string by rows)

I have 1 row which contains abouts 20000 base64 string. e.g: /p4bdllBS8qcvW/69GUYej8nEv6gwt7UAYl0g==WZdjwTUQX9UEKsT/zWaZdQ==uI would like rearrange this file by base64 strings. So the output should be this ( 1 string in 1 row): 69GUYej8nEv6gwt7UAYl0g== WZdjwTUQX9UEKsT/zWaZdQ==How could I do... (4 Replies)
Discussion started by: freeroute
4 Replies

9. Shell Programming and Scripting

Rearrange rows by group pairs

Hello gurus, I have two variable columns 1 and 2 , and their respective groups in 3 and 4 var1 var2 gr1 gr2 a b g h c d h g d f d h f g h g d r h d p q a b h y h g r t g h I want to rearrange the rows in such a way that all similarly grouped (var1 var2) pairs are together . The... (4 Replies)
Discussion started by: senhia83
4 Replies

10. Shell Programming and Scripting

Convert rows into columns and create table with awk

Hello I've four fields . They are First Name, Last Name, Age, Country. So when I run a Unix command, I get below output with these fields comes every time in different order as you can see. Some times first name is the first row and other time last name is first row in the output and etc etc..... (9 Replies)
Discussion started by: rprpr
9 Replies

LEARN ABOUT DEBIAN

dialtest

DIALTEST(8)						      System Manager's Manual						       DIALTEST(8)

NAME

       dialtest - HylaFAX dial string processing rules test program

SYNOPSIS

       /usr/sbin/dialtest [ options ] dialrules

DESCRIPTION

       dialtest  is  an  interactive  program for the testing and development of dial string processing rules used by HylaFAX.	dialtest reads the
       file of rules specified on the command line and then prompts for a dial string.	For each string typed in, dialtest prints  the	result	of
       applying  the  canonicalization	and dial-string preparation rule sets.	A rule set whose name is setname can be specified by typing ``set-
       name(string)''; for example, ``CanonicalName(+1.415.965.7824)''.

       Note that dialtest reads the rules file only when it is initially started up.  This means that dialtest must be restarted for it  to  apply
       changes to a rules file.

OPTIONS

       -a code	 Use code as the value of AreaCode in the rules file.  The default area code is ``415''.

       -c code	 Use code as the value of CountryCode in the rules file.  The default country code is ``1''.

       -i prefix Use prefix as the value of InternationalPrefix in the rules file.  The default international dialing prefix is ``011''.

       -l prefix Use prefix as the value of LongDistancePrefix in the rules file.  The default long distance dialing prefix is ``1''.

       -q	 Be quiet, suppressing most all output except for the actual results.  This is useful for using dialtest in an automated fashion.

       -v	 Print	each  input line before displaying the results of applying the dial string rules to the input string.  This can be useful,
		 for example, in shell scripts.

SEE ALSO

       dialrules(5)

								   March 3, 1995						       DIALTEST(8)
All times are GMT -4. The time now is 11:18 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy