Define spacing of columns


Trivia Category: Science: Gadgets
Difficulty: Easy
The communication protocol NFC stands for Near-Field Control.
True or False?

 
Thread Tools Search this Thread
# 1  
Define spacing of columns

Hi!

I need to change the spacing assigned to each number in a text file. I have an input file with 5 columns and 3 rows. Here, all numbers are separated by 1 space. I need to change this in such a way that the number in the first column has 6, the number in the second column has 5 and all other numbers has 4 spaces:

Convert:
Code:
-6666 _-5555_444_44_4
-6666 _-5555_444_44_4
-6666 _-5555_444_44_4

To:
Code:
_-6666-5555_444__44___4
 _-6666-5555_444__44___4
 _-6666-5555_444__44___4

(I used "_" instead of "space" in this thread for illustrative purpose only)

Any help appreciated! Thank you!
Cheers,
Chris

Last edited by Scrutinizer; 09-03-2012 at 02:07 PM.. Reason: code tags
# 2  
Give it a try..
Code:
 
awk '{printf "% 6s% 5s% 4s% 4s% 4s\n",$1,$2,$3,$4,$5}' filename

This User Gave Thanks to vidyadhar85 For This Post:
# 3  
Thank you so much! That works perfectly!
All the best, Chris.
 

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Grep spacing issue

Hi, I'm trying to match html strings using grep commend and I'm not able to eliminate the extra spaces. This is working when there is no space. Can anyone help me what am I missing here? I'm able to match KayDee where there is no space. grep commands tried: grep -P -o -e... (1 Reply)
Discussion started by: Shenbaga.d
1 Replies

2. Shell Programming and Scripting

Uniform Spacing in the message

Hello, I am running a script which sends an output as an email; I am having issues with the spacing being not uniform in the message. Snippet of the code and email message below: if ] then echo "$Hostname\tMISSING\tHMCBackup" >> $BackupMsg else if ] then echo... (12 Replies)
Discussion started by: hasn318
12 Replies

3. UNIX for Dummies Questions & Answers

Help with the spacing

while IFS="" read r; do printf "XXX\t%s\n" "$r" done < test1.txt > test.txt The issue is, XXX wud be a dummy column/row added to the file..But i want this XXX column to be a separated as a TAB Delimiter it should be something like XXX 1 XXX 2 (3 Replies)
Discussion started by: saggiboy10
3 Replies

4. Shell Programming and Scripting

How to echo columns with consistent spacing?

for (.....) echo -e "$Name | $Age | $Sex\t|$Grade\t\t" done output: John |12 |Male |6th Jack |15 |Male |8th Zachary |15 |Male |9th I want the lines to line up...but it's out of line when the name is long (2 Replies)
Discussion started by: etranman1
2 Replies

5. Shell Programming and Scripting

Spacing between words

Hi I have a csv file in below format First Line=1 Second Line=2 And the third Line=3 Now comes the fourth Line=4 I want to insert spaces so that the output would be First Line=1 Second Line=2 And the third Line=3 Now comes the fourth Line=4 Can anyone help me do... (10 Replies)
Discussion started by: msivask
10 Replies

6. Homework & Coursework Questions

Join command help with spacing

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: I have to join 3 files numerically according to ID(first column) with no comments. In the end i'll be something... (0 Replies)
Discussion started by: bigubosu
0 Replies

7. Shell Programming and Scripting

spacing problem

Hi guys, I have this little code: for directory in / $(echo $path | tr '/' ' ' ) do cd $directory echo "$(ls -ld | cut -c2-10 | sed 's/.\{3\}/& /' | sed 's/.\{7\}/& /' | sed 's/.\{1\}/& /g')" " $directory" done The output of this will be showing the permissions with spaces so it will... (2 Replies)
Discussion started by: darkhider
2 Replies

8. Shell Programming and Scripting

How to adjust spacing

Is there a way to adjust spacing of a line using k shell? e.g I have a file below $ cat file1 AAA BBB CCC A B C AAAA BB CC I want each word to be adjusted with spaces to have 10 character length like below: AAA BBB CCC A B C AAAA BB CC Any... (4 Replies)
Discussion started by: stevefox
4 Replies

9. Shell Programming and Scripting

character spacing issue

I have a script that has a counter in it, the output from the script puts the values in columns, and when the values are greater than 9 it moves the rest of the row over, hence displacing the columns. Is their something I can do to make these values fit in their respective column? I tried typing an... (1 Reply)
Discussion started by: wxornot
1 Replies

10. UNIX for Dummies Questions & Answers

spacing question

hi , i have follwing strings in a text file hello i am cool hey i am cool arrey i am cool in all the above 3 i wanna retrieve cool.......for this i used split(/ /) but it takes into consideration only one space.......is there any regular expression to do the trcik? ... (7 Replies)
Discussion started by: vivekshankar
7 Replies

Featured Tech Videos