Define spacing of columns


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Define spacing of columns
# 1  
Old 09-03-2012
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  
Old 09-03-2012
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  
Old 09-03-2012
Thank you so much! That works perfectly!
All the best, Chris.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to print out with equal spacing between columns?

For instance, my file contains the following content... set -A array set -A test ${array}=1 ${array}=2 ${array}=3 ${test}="Boy" ${test}="Girl" ${test}="Dog" x=0 while ;do print "${array}" " " "${test}" x=$((x+1) done... (1 Reply)
Discussion started by: TestKing
1 Replies

2. UNIX for Dummies Questions & Answers

paste command without spacing?

I'm trying to combine text files without a space. So if i use the paste command paste file1 file2 file3 > file4 the new file created has spacing between the contents of the once individual files. Is there some trick I can do with a delimiter that removes the spaces.. like paste -d'' or... (1 Reply)
Discussion started by: steveinthebox
1 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

PERL array spacing

lines in: 4,355,384 20,762,557 16,407,173 TOTAL 14,470,261 27,190,250 12,719,989 TOTAL 18,825,645 47,952,807 29,127,162 TOTAL PERL script: open(TOTAL,"grepTOTAL /otl/ds_metric/data_files/modem_times|"); push(@total,<TOTAL>);... (3 Replies)
Discussion started by: Jamison
3 Replies

9. 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

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
Login or Register to Ask a Question