Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Justif orden col raw file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Justif orden col raw file
# 1  
Old 01-05-2015
Linux Justif orden col raw file
Hi All,

I need order file some, e.g.

$cat file

Code:
data description importantainfo
121  desp1 info1
122  desp2 info21
2342 desp3 info32
5345 desp4 info43

the how can make file

but out formating

$cat file (adjunt image)


thank you
Justif orden col raw file-outfilepng
Last edited by vgersh99; 01-05-2015 at 12:43 PM.. Reason: code tags, please
# 2  
Old 01-05-2015
you can play with the 'fmt' value to get where you want to be:
Code:
 awk -v fmt='%-10s%-15s%-15s\n' '{printf fmt,$1,$2,$3}'  myFile

---------- Post updated at 11:45 AM ---------- Previous update was at 11:30 AM ----------

Quote:
Originally Posted by aav1307
Hi All,

I need order file some, e.g.

$cat file

Code:
data description importantainfo
121  desp1 info1
122  desp2 info21
2342 desp3 info32
5345 desp4 info43

the how can make file

but out formating

$cat file (adjunt image)


thank you
For the future, use [code]my sample input/output[/code] code tags when posting sample input/output/code samples. Don't use images.
This User Gave Thanks to vgersh99 For This Post:
aav1307
# 3  
Old 01-05-2015
How about
Code:
column -t file
data  description  importantainfo
121   desp1        info1
122   desp2        info21
2342  desp3        info32
5345  desp4        info43

These 2 Users Gave Thanks to RudiC For This Post:
aav1307 vgersh99
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Modifying col values based on another col

Hi, Please help with this. I have several excel files (with and .xlsx format) with 10-15 columns each. They all have the same type of data but the columns are not ordered in the same way. Here is a 3 column example. What I want to do add the alphabet from column 2 to column 3, provided... (9 Replies)
Discussion started by: newbie83
9 Replies

2. Shell Programming and Scripting

Run a program-print parameters to output file-replace op file contents with max 4th col

Hi Friends, This is the only solution to my task. So, any help is highly appreciated. I have a file cat input1.bed chr1 100 200 abc chr1 120 300 def chr1 145 226 ghi chr2 567 600 unix Now, I have another file by name input2.bed (This file is a binary file not readable by the... (7 Replies)
Discussion started by: jacobs.smith
7 Replies

3. Shell Programming and Scripting

Printing from col x to end of line, except last col

Hello, I have some tab delimited data and I need to move the last col. I could hard code it, awk '{ print $1,$NF,$2,$3,$4,etc }' infile > outfile but it would be nice to know the syntax to print a range cols. I know in cut you can do, cut -f 1,4-8,11- to print fields 1,... (8 Replies)
Discussion started by: LMHmedchem
8 Replies

4. UNIX for Advanced & Expert Users

Print line based on highest value of col (B) and repetion of values in col (A)

Hello everyone, I am writing a script to process data from the ATP world tour. I have a file which contains: t=540 y=2011 r=1 p=N409 t=540 y=2011 r=2 p=N409 t=540 y=2011 r=3 p=N409 t=540 y=2011 r=4 p=N409 t=520 y=2011 r=1 p=N409 t=520 y=2011 r=2 p=N409 t=520 y=2011 r=3 p=N409 The... (4 Replies)
Discussion started by: imahmoud
4 Replies

5. Shell Programming and Scripting

how to add new col in a file

Hi, Experts, I have a requirement as following: my source file: a a a b b c c c c I need add one more colume as following: 1 a 2 a 3 a 1 b 2 b 1 c 2 c (4 Replies)
Discussion started by: ken002
4 Replies

6. Shell Programming and Scripting

Compare - 1st col of file

Hi, I have two different files, one has two columns and other has only one column. I would like to compare the first column in the first file with the data in the second file and write a third file with the data that is not present is not common to them. First file:... (26 Replies)
Discussion started by: swame_sp
26 Replies

7. Ubuntu

Match col 1 of File 1 with col 1 File 2 and create a 3rd file

Hello, I have a 1.6 GB file that I would like to modify by matching some ids in col1 with the ids in col 1 of file2.txt and save the results into a 3rd file. For example: File 1 has 1411 rows, I ignore how many columns it has (thousands) File 2 has 311 rows, 1 column Would like to... (7 Replies)
Discussion started by: sogi
7 Replies

8. Shell Programming and Scripting

sum(col) finding from a file

Hi I have an file which looks like country address phone amount sweden |address |phone | 10 | Singapo |address |phone | 20 | Italy-N |address |phone | 30 | denmar |address |phone | 40 | Here i need to do the sum(amount), how to do this in shell scripting Thanks Babu (11 Replies)
Discussion started by: ksmbabu
11 Replies
Login or Register to Ask a Question