Find a blank field and replace values to NA

9 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

LEARN ABOUT DEBIAN

text::formattable

Text::FormatTable(3pm)					User Contributed Perl Documentation				    Text::FormatTable(3pm)

NAME

       Text::FormatTable - Format text tables

SYNOPSIS

	my $table = Text::FormatTable->new('r|l');
	$table->head('a', 'b');
	$table->rule('=');
	$table->row('c', 'd');
	print $table->render(20);

DESCRIPTION

       Text::FormatTable renders simple tables as text. You pass to the constructor (new) a table format specification similar to LaTeX (e.g.
       "r|l|5l|R|20L") and you call methods to fill the table data and insert rules. After the data is filled, you call the render method and the
       table gets formatted as text.

       Methods:

       new($format)
	   Create a Text::FormatTable object, the format of each column is specified as a character of the $format string. The following formats
	   are defined:

	   l   Left-justified top aligned word-wrapped text.

	   L   Left-justified bottom aligned word-wrapped text.

	   r   Right-justified top aligned word-wrapped text.

	   R   Right-justified bottom aligned word-wrapped text.

	   10R, 20r, 15L, 12l,
	       Number is fixed width of the column.  Justified and aligned word-wrapped text (see above).

	   ' ' A space.

	   |   Column separator.

       head($col1, $col2, ...)
	   Add a header row using $col1, $col2, etc. as cell contents. Note that, at the moment, header rows are treated like normal rows.

       row($col1, $col2, ...)
	   Add a row with $col1, $col2, etc. as cell contents.

       rule([$char])
	   Add an horizontal rule. If $char is specified it will be used as character to draw the rule, otherwise '-' will be used.

       render([$screen_width])
	   Return the rendered table formatted with $screen_width or 79 if it is not specified.

SEE ALSO

       Text::ASCIITable

COPYRIGHT

       Copyright (c) 2001-2004 Swiss Federal Institute of Technology, Zurich.
		 (c) 2009 Trey Harris All Rights Reserved.

       This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

CODE REPOSITORY

       Git - http://github.com/treyharris/Text-FormatTable/tree/master

AUTHOR

       David Schweikert <dws@ee.ethz.ch>

       Maintained by Trey Harris <treyharris@gmail.com>

       Fixed column width and bottom alignment written by Veselin Slavov <vslavov@creditreform.bg>

perl v5.10.0							    2009-07-24						    Text::FormatTable(3pm)

Shell Programming and Scripting