Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Merge 3 columns side by side

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Merge 3 columns side by side
# 1  
Old 02-06-2009
Merge 3 columns side by side
I know this is a stupid question for you guys!

half day googling and i got nothing Smilie

i have 3 variables/files, say:

$X1 or file1:
# there is one whitespace space after each line
| 21
| 9
| 28
| 100
| 51


$X2 or file2:
# there is one whitespace space after each line
| disabled
| enabled
| enabled
| disabled
| enabled

$X3 or file3:
| 522 |
| 30 |
| 0 |
| 12 |
| 10 |

need output like this:
| 21 | disabled | 522 |
| 9 | enabled | 30 |
| 28 | enabled | 0 |
| 100 | disabled | 12 |
| 51 | enabled | 10 |


Help me please... Master!

The columns look bad here, i don't know how to fix it Smilie
it should be nice with same width in each column.

you may find the attachment
attch.gz (51 Bytes) 
attch.zip (135 Bytes) 
Last edited by amaulana; 02-06-2009 at 09:25 AM..
# 2  
Old 02-06-2009
You can use the paste command. Check the man page of paste.

Regards
# 3  
Old 02-06-2009
oh ya, i'm using variable here,

sample$ paste $X1 $2 $x3

here is the result:
sample$ paste: cannot open
# 4  
Old 02-06-2009
oh egad....

some mispelling is all...

to get things lined up nice, you could always use awk:

Code:
paste $X1 $X2 $X3 |
  awk -F\| '{ printf( "|%-7.7s|%-12.12s|%-7.7s\n", $1, $2, $3 ); }'

# 5  
Old 02-06-2009
MySQL
Hi ...

i could see in my machine..it gives correct answer..

paste -d "" 1.txt 2.txt 3.txt

output - | 21 | disabled | 522 |

Thanks
Sha
# 6  
Old 02-06-2009
Quote:
Originally Posted by quirkasaurus
oh egad....

some mispelling is all...

to get things lined up nice, you could always use awk:

Code:
paste $X1 $X2 $X3 |
  awk -F\| '{ printf( "|%-7.7s|%-12.12s|%-7.7s\n", $1, $2, $3 ); }'

You're right guru! sorry, i was in hurry yesterday...., i'll implement this next monday in solaris system.
# 7  
Old 02-06-2009
Quote:
Originally Posted by Shahul
Hi ...

i could see in my machine..it gives correct answer..

paste -d "" 1.txt 2.txt 3.txt

output - | 21 | disabled | 522 |

Thanks
Sha
if those variables should redirect to files, i'll do that guru... i'll implement this also in next monday in solaris system ( but also i'll try in linux, in my machine)
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Import 2 columns from 8 .csv files into pandas df (side by side) and write a new csv

I have 8 .csv files with 16 columns and "n" rows with no Header. I want to parse each of these .csv and get column and put the data into a new.csv. Once this is done, the new.csv should have 16 columns (2 from each input.csv) and "n" rows. Now, I want to just take the average of Column from... (3 Replies)
Discussion started by: Zam_1234
3 Replies

2. Shell Programming and Scripting

AWK to merge multiple files side by side

I have about 100s of files of type text in a known directory. I want to merge all files side by side. Number of lines in all the files will remain same. For example file1 contains cat dog File 2 contains rat mat Output file should be cat rat dog mat Using awk I was able to... (5 Replies)
Discussion started by: kanthrajgowda
5 Replies

3. Shell Programming and Scripting

printing 3 files side by side based on similar values in rows

Hi I'm trying to compare 3 or more files based on similar values and outputting them into 3 columns. For example: file1 ABC DEF GHI file2 DEF DER file3 ABC DER The output should come out like this file1 file2 file3 ABC ABC (4 Replies)
Discussion started by: zerofire123
4 Replies

4. Shell Programming and Scripting

Paste two file side by side together based on specific pattern match problem

Input file_1: P78811 P40108 O17861 Q6NTW1 P40986 Q6PBK1 P38264 Q6PBK1 Q9CZ49 Q1GZI0 Input file_2: (6 Replies)
Discussion started by: patrick87
6 Replies

5. Web Development

Cannot access Apache web server from Wan side, only Lan side.

I have installed WAMPSERVER 2.0 on my windows vista x64 system but still am having issues with getting the webserver to be seen outside my local network. It is working fine within my local network. Been through several setup tutorials so far, no dice still. For testing purposes I have... (1 Reply)
Discussion started by: davidmanvell
1 Replies

6. Shell Programming and Scripting

How to Merge / combine / join / paste 2 text files side-by-side

I have 2 text files, both have one simple, single column. The 2 files might be the same length, or might not, and if not, it's unknown which one would be longer. For this example, file1 is longer: ---file1 Joe Bob Mary Sally Fred Elmer David ---file2 Tomato House Car... (3 Replies)
Discussion started by: cajunfries
3 Replies

7. Shell Programming and Scripting

Script to place selected columns from a group of files side by side in a new file

Hi Everyone, I need a shell/perl script to bring selected columns from all the files located in a directory and place them in a new file side by side. File1: a b c d 2 3 4 5 f g h i .......... File2: I II III IV w x y z .............. and so on many files are there...... (8 Replies)
Discussion started by: ks_reddy
8 Replies

8. Shell Programming and Scripting

Merge 2 text files to one text file side by side

Inquiring minds want to know.... I need to take two files that I have latitude and longitude values and then combine them into one file with the values side by side separated by a space. the first file is temp113-lat.txt and the second is temp113-lon.txt. They each have values listed in the... (15 Replies)
Discussion started by: ahinkebein
15 Replies

9. Shell Programming and Scripting

How to Merge Two .xls files side by side into a single .xls

Hi all, please help me out in below requirement. I have two .xls files say abc.xls and bbc.xls , i want to merge these two files into a single file ..say xyz.xls side by side Ex: abc.xls bbc.xls Eno Ename Eno Ename 101 hello ... (2 Replies)
Discussion started by: jagadish99
2 Replies

10. Shell Programming and Scripting

How to Merge Two .xls files side by side into a single .xls

Hi all, please help me out in below requirement. I have two .xls files say abc.xls and bbc.xls , i want to merge these two files into a single file ..say xyz.xls side by side Ex: abc.xls Eno Ename 101 hello 102 hero 103 india bbc.xls Eno Ename 201 delhi 202 Hyd 203... (0 Replies)
Discussion started by: jagadish99
0 Replies
Login or Register to Ask a Question