Change Lines into column


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Change Lines into column
# 1  
Old 10-15-2013
Change Lines into column

Hello

how can I change lines into column?
e.g.

I have a Text file which looks like:
Code:
Surename......
Address.....
Phonenumber.....
Zipcode..
Surename...
Address....
Zipcode
Surename...

I want that Surename is in column 1 and every following line should be in additional colums.
how can I do this easily?

has someone any idea?

thanks for support

Last edited by Scott; 10-15-2013 at 01:00 PM.. Reason: Code tags
# 2  
Old 10-15-2013
Please provide a representative sample of input you have and output you expect
# 3  
Old 10-15-2013
hi

the input file I have generated from a xml file. Means in the beginning of line sometimes there is a space or tab.

the content is:

Code:
SURNAME= Mueller
    ADDRESS= Schulstreet 14
    POSTCODE= 86348
    PHONE= +44 998763
SURNAME= Schmidt
    ADDRESS= Westroad 20
    POSTCODE= 45694
    INFO= sometimes the infoline has a big content so that
the line itselfe is visible in more line.
SURNAME=Schuster 
    ADDRESS= Usestreet 80
    PHONE= +44 8963447


the output should like :
Code:
SURNAME= Mueller     ADDRESS= Schulstreet 14    POSTCODE= 86348 etc..
SURNAME= Schmidt    ADDRESS= Westroad 20      POSTCODE= 45694 etc..
SURNAME=Schuster     ADDRESS= Usestreet 80    PHONE= +44 8963447


thanks for support

Last edited by Scott; 10-15-2013 at 01:00 PM.. Reason: Please use code tags
# 4  
Old 10-15-2013
Please use code tags as required by forum rules!

Try
Code:
awk '/SURNAME/ {$0="\n"$0} END {print "\n"}  1' ORS=" " file
SURNAME= Mueller ADDRESS= Schulstreet 14 POSTCODE= 86348 PHONE= +44 998763 
SURNAME= Schmidt ADDRESS= Westroad 20 POSTCODE= 45694 INFO= sometimes the infoline has a big content so that the line itselfe is visible in more line. 
SURNAME=Schuster ADDRESS= Usestreet 80 PHONE= +44 8963447

This User Gave Thanks to RudiC For This Post:
# 5  
Old 10-15-2013
Quote:
the output should like :

SURNAME= Mueller ADDRESS= Schulstreet 14 POSTCODE= 86348 etc..
SURNAME= Schmidt ADDRESS= Westroad 20 POSTCODE= 45694 etc..
SURNAME=Schuster ADDRESS= Usestreet 80 PHONE= +44 8963447


thanks for support
@ RudiC

His o/p requirement is little different I think
# 6  
Old 10-15-2013
Skipping the first line and removing unexpected last trailing space before prompt
Code:
awk 'NR>1{$0=(/SURNAME/?"\n":" ")$0}END{print "\n"}1' ORS= yourfile

This User Gave Thanks to ctsgnb For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Read first column and count lines in second column using awk

Hello all, I would like to ask your help here: I've a huge file that has 2 columns. A part of it is: sorted.txt: kss23 rml.67lkj kss23 zhh.6gf kss23 nhd.09.fdd kss23 hp.767.88.89 fl67 nmdsfs.56.df.67 fl67 kk.fgf.98.56.n fl67 bgdgdfg.hjj.879.d fl66 kl..hfh.76.ghg fl66... (5 Replies)
Discussion started by: Padavan
5 Replies

2. Shell Programming and Scripting

awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column

Hi, My input files is like this axis1 0 1 10 axis2 0 1 5 axis1 1 2 -4 axis2 2 3 -3 axis1 3 4 5 axis2 3 4 -1 axis1 4 5 -6 axis2 4 5 1 Now, these are my following tasks 1. Print a first column for every two rows that has the same value followed by a string. 2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

3. Shell Programming and Scripting

Find lines with matching column 1 value, retain only the one with highest value in column 2

I have a file like: I would like to find lines lines with duplicate values in column 1, and retain only one based on two conditions: 1) keep line with highest value in column 3, 2) if column 3 values are equal, retain the line with the highest value in column 4. Desired output: I was able to... (3 Replies)
Discussion started by: pathunkathunk
3 Replies

4. Shell Programming and Scripting

Change column to row base on column 2

Hi Guys, Input.txt L194 A -118.2 L194 B -115.1 L194 C -118.7 L196 A 0 L196 C 0 L197 A -111.2 L197 B -118.9 L197 C -119.9 L199 A -120.4 L199 B -119.9 ... (2 Replies)
Discussion started by: asavaliya
2 Replies

5. Shell Programming and Scripting

awk or sed: change the color of a column w/o screwing up column spacing

Hey folks. I wrote a little awk script that summarizes /proc/net/dev info and then pipes it to the nix column command to set up column spacing appropriately. Here's some example output: Iface RxMBytes RxPackets RxErrs RxDrop TxMBytes TxPackets TxErrs TxDrop bond0 9 83830... (3 Replies)
Discussion started by: ryran
3 Replies

6. UNIX for Dummies Questions & Answers

Converting column to rows for every 3 lines in the column

Hi gurus! Please help me with this one. I have an file with the following contents: a b c d e f g h i j I would like to make to transform it to look like this as my output file: a,b,c d,e,f (4 Replies)
Discussion started by: kokoro
4 Replies

7. Shell Programming and Scripting

Filtering lines for column elements based on corresponding counts in another column

Hi, I have a file like this ACC 2 2 21 aaa AC 443 3 22 aaa GCT 76 1 33 xxx TCG 34 2 33 aaa ACGT 33 1 22 ggg TTC 99 3 44 wee CCA 33 2 33 ggg AAC 1 3 55 ddd TTG 10 1 22 ddd TTGC 98 3 22 ddd GCT 23 1 21 sds GTC 23 4 32 sds ACGT 32 2 33 vvv CGT 11 2 33 eee CCC 87 2 44... (1 Reply)
Discussion started by: polsum
1 Replies

8. Shell Programming and Scripting

Change file content 4 column to one Column using script

Hi Gurus, I have file content sample: ,5113955056,,TAgent-Suspend ,5119418233,,TAgent-Suspend ,5102119078,,TAgent-Suspend filenames 120229H5_suspend, 120229H6_unsuspend I receive those files one of directory /home/temp/ I need following: 1. Backup first /home/temp/ file to... (5 Replies)
Discussion started by: thepurple
5 Replies

9. Shell Programming and Scripting

Select lines in which column have value greater than some percent of total file lines

i have a file in following format 1 32 3 4 6 4 4 45 1 45 4 61 54 66 4 5 65 51 56 65 1 12 32 85 now here the total number of lines are 8(they vary each time) Now i want to select only those lines in which the values... (6 Replies)
Discussion started by: vaibhavkorde
6 Replies

10. Shell Programming and Scripting

Change names in a column based on the symbols in another column

If the 4th column has - sign then the names in 3rd column has to change to some user defined names (as shown in output). Thanx input1 1 a aaaaa + 2 b bbbbb + 3 c ccccc + 4 d ddddd + 5 e eeeee + 6 f xxxxx + 8 h hhhhh +... (8 Replies)
Discussion started by: repinementer
8 Replies
Login or Register to Ask a Question

Featured Tech Videos