Find a blank field and replace values to NA Post: 302847117

Login or Register to Ask a Question and Join Our Community

Sponsored Content

Top Forums Shell Programming and Scripting Find a blank field and replace values to NA Post 302847117 by vgersh99 on Monday 26th of August 2013 10:57:35 AM

Old

08-26-2013

Moderator

it should be straight forward, What have you tried?

vgersh99

View Public Profile for vgersh99

Find all posts by vgersh99

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Find and replace a field in the last line

I have a file 'test.out' with contents: 1|1|10|10|I|asdf| 2|1|10|10|I|sdfg| 4|1|10|10|I|hgfj| 34|0|10|10|I|sdg| I want to modify the fifth column with value 'I' to 'A' for only the last line. Below is what I expect to see: 1|1|10|10|I|asdf| 2|1|10|10|I|sdfg| ...

2. Shell Programming and Scripting

finding field count escaping the blank values

Hi All I have a file.Below are few records of the file. sample.txt CPS,ES,843232910001,ESF81462,W N LINDSAY LTD,01674840629,09-FEB-2009,23-FEB-2009,CDR735,ALL CALLS,01674840629 CPS,ES,843232670001,ESF81462,W N LINDSAY LTD,01674840629,09-FEB-2009,23-FEB-2009,CDR734,ALL...

3. Shell Programming and Scripting

Find top N values for field X based on field Y's value

I want to find the top N entries for a certain field based on the values of another field. For example if N=3, we want the 3 best values for each entry: Entry1 ||| 100 Entry1 ||| 95 Entry1 ||| 30 Entry1 ||| 80 Entry1 ||| 50 Entry2 ||| 40 Entry2 ||| 20 Entry2 ||| 10 Entry2 ||| 50...

4. Shell Programming and Scripting

Replace blank values for string using sed

Hi everyone, I was wondering how could from a file where each row is separated by tabulations, the row values where are in blank replace them by a string or value. My file has this form: 26/01/09 13:45:00 0 0 26/01/09 14:00:00 1495.601318 0 26/01/09 14:15:00 1495.601318 0 ...

5. Shell Programming and Scripting

Find and replace blank in the last field

Hi all, I have a huge file and I need to get ride of the fields 6-11 and replace the blanks in field 5 with a missing value(99999). 159,93848,5354,343,67898,45,677,5443,434,5545,45 677,45545,3522,244, 554,54344,3342,456, 344,43443,2344,444,23477...

6. Shell Programming and Scripting

replace blank field in file 2 with content of file 1

Something like vlookup in excel, column 2 in file 2 is blank and should be replaced by column 2 in file 1 based on comparing column 1 in both files. file1 Code: 1234~abc~b~c~d~e~f~g~h~09/10/09 5678~def~b~c~d~e~f~g~h~12/06/10 8910~hij~b~c~d~e~f~g~h~03/28/13...

7. Shell Programming and Scripting

Replace a field where values are null in a file.

Hi, I've a pipe delimited file and wanted to replace the 3rd field to 099990 where the values are null. How can I achieve it using awk or sed. 20130516|00000061|02210|111554|03710|2|205069|SM APPL $80-100 RTL|S 20130516|00000061|02210|111554|03710|2|205069|SM APPL $80-100 RTL|S...

8. Shell Programming and Scripting

Find a blank field

Find a blank field Hi I have set of fields that have some blank values, how to find that and get its line noumbers in output file. Ex: Col1 col2 col3 11 ss 103 12 104 13 105 14 se 106

9. UNIX for Beginners Questions & Answers

How to replace the field values, which are greater than the specified value with TRUE?

I have a csv file as given below, org1 org2 org3 org4 org5 gene1 100 80 90 80 150 gene2 30 70 50 50 115 gene3 40 120 60 40 105 gene4 20 72 40 60 20 I need to replace the fields are having values greater than 100 with "TRUE". I used the following commands to replace...

LEARN ABOUT CENTOS

tapset::netfilter

tapset::netfilter(3stap)												  tapset::netfilter(3stap)

NAME

       tapset::netfilter - systemtap netfilter tapset

DESCRIPTION

       netfilter.ip.pre_routing
	      Called before an IP packet is routed

	       See probe::netfilter.ip.pre_routing(3stap)
	       for details.

       netfilter.ip.local_in
	      Called on an incoming IP packet addressed to the local computer

	       See probe::netfilter.ip.local_in(3stap)
	       for details.

       netfilter.ip.forward
	      Called on an incoming IP packet addressed to some other computer

	       See probe::netfilter.ip.forward(3stap)
	       for details.

       netfilter.ip.local_out
	      Called on an outgoing IP packet

	       See probe::netfilter.ip.local_out(3stap)
	       for details.

       netfilter.ip.post_routing
	      Called immediately before an outgoing IP packet leaves the computer

	       See probe::netfilter.ip.post_routing(3stap)
	       for details.

       netfilter.bridge.local_in
	      Called on a bridging packet destined for the local computer

	       See probe::netfilter.bridge.local_in(3stap)
	       for details.

       netfilter.bridge.forward
	      Called on an incoming bridging packet destined for some other computer

	       See probe::netfilter.bridge.forward(3stap)
	       for details.

       netfilter.bridge.local_out
	      Called on a bridging packet coming from a local process

	       See probe::netfilter.bridge.local_out(3stap)
	       for details.

SEE ALSO

	    probe::netfilter.ip.pre_routing(3stap),	     probe::netfilter.ip.local_in(3stap),	   probe::netfilter.ip.forward(3stap),
       probe::netfilter.ip.local_out(3stap),		probe::netfilter.ip.post_routing(3stap),	    probe::netfilter.arp.in(3stap),
       probe::netfilter.arp.out(3stap), 	   probe::netfilter.arp.forward(3stap), 	  probe::netfilter.bridge.pre_routing(3stap),
       probe::netfilter.bridge.local_in(3stap),       probe::netfilter.bridge.forward(3stap),	     probe::netfilter.bridge.local_out(3stap),
       probe::netfilter.bridge.post_routing(3stap),  stap(1), stapprobes(3stap)

IBM
									---						  tapset::netfilter(3stap)