Re-arrangement of data


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Re-arrangement of data
# 1  
Old 11-07-2008
Re-arrangement of data

Dear Frineds,
I have a flat file as follows

ABCD
ABDCWQE
POIERAS
ADSGASGFG
GHJKFHD
XBDFGHFGDH


POIU
IJPFG
AFGJFPGOU
A;DGUPGU
SFSDFDSDFHDSF
SDFGHSFDH



I want this column to be converted into row like follows
ABCD, ABDCWQE, POIERAS, ADSGASGFG, GHJKFHD, XBDFGHFGDH
POIU, IJPFG, AFGJFPGOU, A;DGUPGU, SFSDFDSDFHDSF, SDFGHSFDH

How can I do this?
Please guide me.
Thanks in advance
# 2  
Old 11-07-2008
You can try like this....
cat temp.log | perl -lp00e 's/\n(?=(\w))/$1?", ":""/eg'
# 3  
Old 11-07-2008
With AWK:

Code:
awk '$1=$1' RS=  OFS=, infile

But the code above assumes no blanks in the fields.
If that assumption is wrong, use this:

Code:
awk '$1=$1' RS=  FS='\n' OFS=, infile

Use nawk or /usr/xpg4/bin/awk on Solaris.
# 4  
Old 11-07-2008
Dear Friend
I have tried awk '$1=$1' RS= FS='\n' OFS=, infile but the script named as rearng.sh gives following error

rearng.sh: 1=1: not found.
awk: Cannot find or open file infile.
The source line number is 1.
# 5  
Old 11-07-2008
Could you post the content of your script?
You should substitute infile with your real filename.

Did you try the perl solution?
# 6  
Old 11-08-2008
Dear Rado,
I have tried the solution given by you and its working perfect. Just to know, what if i want the output file to be pipe (|) separated instead of comma (,)?
And secondly as you have asked if I have tried perl. I dont know how to use perl for it. It would be really great if you guide me thro it as well.

Thank you for all your help.
# 7  
Old 11-08-2008
Assuming you file is named file:

Code:
% cat file
ABCD
ABDCWQE
POIERAS
ADSGASGFG
GHJKFHD
XBDFGHFGDH

POIU
IJPFG
AFGJFPGOU
A;DGUPGU
SFSDFDSDFHDSF
SDFGHSFDH

With AWK:

Code:
% awk '$1=$1' RS=  OFS=\| file 
ABCD|ABDCWQE|POIERAS|ADSGASGFG|GHJKFHD|XBDFGHFGDH
POIU|IJPFG|AFGJFPGOU|A;DGUPGU|SFSDFDSDFHDSF|SDFGHSFDH

With Perl:

Code:
% perl -lp00e 's/\n(?=(\w))/$1?"|":""/eg' file
ABCD|ABDCWQE|POIERAS|ADSGASGFG|GHJKFHD|XBDFGHFGDH
POIU|IJPFG|AFGJFPGOU|A;DGUPGU|SFSDFDSDFHDSF|SDFGHSFDH

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Retreive data with arrangement

Hi all I have following part of a big file TTDS00002 Synonyms M1 receptor TTDS00002 Disease Alzheimer's disease TTDS00002 Disease Bronchospasm (histamine induced) TTDS00002 Disease Cognitive deficits TTDS00002 Disease Schizophrenia TTDS00002 Function The muscarinic acetylcholine... (2 Replies)
Discussion started by: kareena
2 Replies

2. UNIX for Advanced & Expert Users

Data re-arrangement

Hi I have a huge problem to solve ASAP. Can someone please help!!! My format is arranged in this format: It has three columns. LOGIN ALIAS REC_ID A BB1 0 A ... (1 Reply)
Discussion started by: Mapilo
1 Replies

3. Shell Programming and Scripting

Help with data re-arrangement problem facing

Input file: <symbol>Q9Y8G1</symbol> <name>Q9Y8G1_EMENI</name> <symbol>Q6V953</symbol> <symbol>Q5B8K1</symbol> <name>Q6V953_EMENI</name> <symbol>G1A416</symbol> <name>G1A416_9FUNG</name> <symbol>D4N894</symbol> <name>D4N894_PLEER</name> <symbol>B0FFU4</symbol>... (13 Replies)
Discussion started by: cpp_beginner
13 Replies

4. Shell Programming and Scripting

Help to data re-arrangement problem

Input file <data id>="1">\ </data>\ <data id>="2">\ </data>\ <code>="1" target="2">\ </code>\ <data id>="1">\ </data>\ <data id>="2">\ </data>\ <code>="1" target="2">\ </code>\ <data id>="1">\ </data>\ <data id>="2">\ </data>\ <code>="1" target="2">\ </code>\ (2 Replies)
Discussion started by: cpp_beginner
2 Replies

5. Shell Programming and Scripting

sorting/arrangement problem

Hi, I have the following 'sorting' problem. Given the input file: a:b:c:12:x:k s:m:d:8:z:m a:b:c:1:x:k p:q:r:23:y:m a:b:c:3:x:k p:q:r:1:y:m the output I expect is: a:b:c:1:x:k p:q:r:1:y:m s:m:d:8:z:m What happened here is I grouped together lines having the same values for... (7 Replies)
Discussion started by: Abhishek Ghose
7 Replies

6. UNIX for Dummies Questions & Answers

Help on file arrangement

Can anyone help me on this. I have a file that looks like this: color red green blue color pink yellow number one two gender male gender female The output would look like this: color red green blue pink yellow number one two gender male female I have over 5000 rows and i dont want... (5 Replies)
Discussion started by: kharen11
5 Replies

7. UNIX for Dummies Questions & Answers

Data arrangement

10 2 1 2 3 4 5 6 7 8 20 3 2 1 3 2 9 8 2 1 Need the data to be arranged: 10 2 1 5 2 6 3 7 4 8 20 3 2 1 1 2 3 8 2 9 please help! (6 Replies)
Discussion started by: bobo
6 Replies

8. UNIX for Dummies Questions & Answers

Cell arrangement

I have a data file with hundreds of lines: I want to place a YES right below the line that say mydata....can someone please help! on the left is my the original data on the right the data format need to be: left > Right mydata > mydata yes > yesno > no mydata > mydata... (12 Replies)
Discussion started by: bobo
12 Replies

9. UNIX for Dummies Questions & Answers

Data arrangement

I have these following data: Home Tom Member List 100 Yes 200 No Home Tom Member List 1 No 2 Yes Home Tome Member List 3 No 400 Yes I want my data to be consistants like this: (4 Replies)
Discussion started by: bobo
4 Replies

10. UNIX for Dummies Questions & Answers

Text file arrangement

Dear UNIX experts: Hi, I have a text file which the contents are arranged vertically down, line by line. How do use a loop (I think) to make it arrange in vertical arrangement with a tab delimitated and write to a new file? Eg: of source file Hello World Good-day Thanks Welcome The... (8 Replies)
Discussion started by: merry susana
8 Replies
Login or Register to Ask a Question

Featured Tech Videos