Visit Our UNIX and Linux User Community


Fill in columns


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Fill in columns
# 1  
Old 10-07-2009
Fill in columns

Hi,

I've got a file with several columns where some entries are missing.
Example:

Code:
a b c d
f    g h
j  k    l
p y    r

I need to replace the empty spaces with zero, so the new file would be:

Code:
a b c d
f 0 g h
j k 0  l
p y 0 r

The original file is tab delimited.
Many thansk for your help in advance!
# 2  
Old 10-07-2009
For the given input, this will work.
Code:
sed 's/\t\t/\t0\t/' a

# 3  
Old 10-07-2009
Code:
# cat file
a       b       c       d
f               g       h
j       k               l
p       y               r
# awk '{FS=OFS="\t"}{for(i=1;i++<NF;) $i=($i)?$i:"0"}1' file
a       b       c       d
f       0       g       h
j       k       0       l
p       y       0       r

# 4  
Old 10-08-2009
Many thanks guys!
It all works!!!
 

Previous Thread | Next Thread
Test Your Knowledge in Computers #931
Difficulty: Medium
64-bit computer system storage allocation for timekeeping will allow them to represent dates more than 300 billion years into the future.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Join, merge, fill NULL the void columns of multiples files like sql "LEFT JOIN" by using awk

Hello, This post is already here but want to do this with another way Merge multiples files with multiples duplicates keys by filling "NULL" the void columns for anothers joinning files file1.csv: 1|abc 1|def 2|ghi 2|jkl 3|mno 3|pqr file2.csv: 1|123|jojo 1|NULL|bibi... (2 Replies)
Discussion started by: yjacknewton
2 Replies

2. Shell Programming and Scripting

Join and merge multiple files with duplicate key and fill void columns

Join and merge multiple files with duplicate key and fill void columns Hi guys, I have many files that I want to merge: file1.csv: 1|abc 1|def 2|ghi 2|jkl 3|mno 3|pqr file2.csv: (5 Replies)
Discussion started by: yjacknewton
5 Replies

3. Shell Programming and Scripting

Fill in missing values

Hi, I have a data sample as shown below. I want to fill in the left column so that the line will be continuous. For example, between 1 and 5 should be 2,3,4. And corresponding values in the right column will be 0. Thus the expected data should look like that: 1 1 1 10 1 2 1 3 1 5 1 6 2 0... (6 Replies)
Discussion started by: theanh0508
6 Replies

4. Shell Programming and Scripting

fill in last column of data

Hello, I am fairly new to awk, and I have the following problem. My file has missing data in the last column, and the program I am pre-processing this file for cannot interpret correctly shortened rows (it just wraps the data around). Is there a way to force awk to create the same... (6 Replies)
Discussion started by: timert34
6 Replies

5. Shell Programming and Scripting

Fill the directory

HI all When i do df -h,it displays the amount of free space. Tell me a command or a script to fill the total space to a certain percent (say 99%) Thanks in advance (8 Replies)
Discussion started by: 2002anand
8 Replies

6. Shell Programming and Scripting

Compare columns and rows with template, and fill empty slots.

Hi, I'm working on a script that will take the contents of a file, that is in a row and column format, and compare it to a arrangment file. Such that if there is any or all blanks in my content file, the blank will be filled with a flag and will retain the row and column configuration. Ex. ... (2 Replies)
Discussion started by: hizzle
2 Replies

7. Shell Programming and Scripting

Zero fill a string

How do I zero fill a string. E.g pad a string to two digits m=`date "+%m"` pm=`expr $m - 1` echo $pm the above code echoes 1. I want it to echo 01. Any ideas? (3 Replies)
Discussion started by: timgolding
3 Replies

8. Programming

Zero Fill 10 position field

Hi everyone, I am using shell scripting on a Unix SCO box. It calls a C program named zerofill. I do not know anything about C. I am having an issue with a hash total that should only be zero filled 10 positions but the record has 11 positions. DEBUG RESULTS + nice -n -5 bc -l /tmp/fhash8395... (0 Replies)
Discussion started by: ski
0 Replies

9. Shell Programming and Scripting

fill in missing columns

It can't be that hard, but I just can't figure it out: I have file like: File Sub-brick M_1 S_1 M_2 S_2 M_4 S_4 ... xxx 1 214 731 228 621 132 578 ... and would like to get 0 0 where M_3 S_3 is missing xxx 1 214 731 228 621 0 0 132 578 ... I wrote following script, but can't figure out... (3 Replies)
Discussion started by: avvk
3 Replies

10. Shell Programming and Scripting

Fixed length (Fill out)

hello, I have a file that has lines with different lengts. I want this file to be filled up with a zero so that al the lines have the same length. Please advice? File 1: ----------- 2310 2009 830 1345 Result File 2: ---------- 2310 2009 0830 (3 Replies)
Discussion started by: peterk
3 Replies

Featured Tech Videos