in above lines 1st line is header (column names) and below are the values.
my requirement is --> if only 2nd and 3rd columns value are Null then it should replace with NA.Another columns value should not be changed keep as it is.
how to do in unix either command or a shell script.
Result should look like below mentioned.
Advance Thanks...
Thanks,
Krupa
Last edited by Scott; 12-16-2012 at 07:59 AM..
Reason: Please use code tags and less formatting
Hi Guys,
I have a file in which each set of records are separated by two blank line. I want to replace it with a single blank line.
Can you guys help me out?
Regards,
Magesh (9 Replies)
i have a file with the below content
file1.txt
ALERTADMIN.FIELD
ALERTADMIN.TX_ALERTS_LOG
i have another file
file2
ALERTADMIN.FIELD
ALERTADMIN.FIELD_WS
ALERTADMIN.SECTION_FIELD_WS
ALERTADMIN.TX_ACCT_PROCESSING_WORK_TABLE
ALERTADMIN.TX_ACCT_REVIEW_EXEC_METRICS... (2 Replies)
hi,
I have a doubt in replacing characters with blank.
My requirement is that, i have one file and looks like below
4:ALTER SYSTEM DISCONNECT SESSION '193,191' IMMEDIATE;
6:ALTER SYSTEM DISCONNECT SESSION '205,7274' IMMEDIATE;
5:ALTER SYSTEM DISCONNECT SESSION '206,34158' IMMEDIATE;... (4 Replies)
Hi,
I have data like below: The columns MARKET ,STORE, WEEK1 will be present always. After that, there can be week2, week3 columns or some times there wont be no columns after week1. The week1 or week2 columns can have data or blank. I need to replace the blank with NIS.
MARKET,STORE,STORE... (6 Replies)
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... (12 Replies)
hlow all i need help
how can i replace blank number with awk
input.txt
300::|355264313178490
301::|358814003239510
302::|358316038113400
303::|357954002633660
304::|354072040694090
305::|356956015214190
306::|352943020525180
307::|359574033836610
308::|381810990023580
so will be like... (4 Replies)
Need help to replace the line beginning with tcp_sendspace with a blank line.
# cat if
en0: flags=1e080863,480<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),CHAIN>
inet 10.27.53.21 netmask 0xffffff00 broadcast 10.207.52.255
inet... (11 Replies)
Hi all,
I have 89 columns,1200 rows in a flat file, some of the values are just '.' (the character dot). I want to replace them by nothing (blank), but when I do so, it affects the decimal numbers too. so 12.34 becomes 1234.
How can I just replace values which are only '.' with 1 white... (13 Replies)
hi,
i need to replace a blank tab output in a file to zero.
input file:
2015/08/04 00:00:00 171 730579 27088 <blank> 3823 30273 1621778 ... (6 Replies)
Dear All,
In a CSV file, say that a given column has been extracted. In that column, information is missing (i.e. blank lines appear). I would like to replace the blank lines by the last valid line (not blank) previously read.
For example, consider the extract below:
123
234
543
111... (7 Replies)
Discussion started by: bagvian
7 Replies
LEARN ABOUT DEBIAN
relaytest
relaytest(1) General Commands Manual relaytest(1)NAME
relaytest - attempt to use SMTP to relay to a DSBL-compliant host
SYNOPSIS
relaytest [-v] <ip address[:port]>
DESCRIPTION
relaytest attempts to connect to the specified <ip address> on the specified port (default is port 25) and uses a variety of tests to
attempt to relay through the host.
In the tests below, source.com is sender_domain from dsbl.conf(5) and sender is sender_user.
Non-domain-specific tests:
MAIL FROM:<sender@source.com>
RCPT TO:<listme@dsbl.org>
MAIL FROM:<sender@source.com>
RCPT TO:<"listme@dsbl.org">
MAIL FROM:<sender@source.com>
RCPT TO:listme@dsbl.org
MAIL FROM:<sender@source.com>
RCPT TO:<dsbl.org!listme>
MAIL FROM:<nobody>
RCPT TO:<listme@dsbl.org>
MAIL FROM:<nobody>
RCPT TO:<"listme@dsbl.org">
MAIL FROM:<nobody>
RCPT TO:listme@dsbl.org
MAIL FROM:<nobody>
RCPT TO:<dsbl.org!listme>
MAIL FROM:<source.com!sender>
RCPT TO:<listme@dsbl.org>
MAIL FROM:<source.com!sender>
RCPT TO:<"listme@dsbl.org">
MAIL FROM:<source.com!sender>
RCPT TO:listme@dsbl.org
MAIL FROM:<source.com!sender>
RCPT TO:<dsbl.org!listme>
MAIL FROM:<>
RCPT TO:<listme@dsbl.org>
MAIL FROM:<>
RCPT TO:<"listme@dsbl.org">
MAIL FROM:<>
RCPT TO:listme@dsbl.org
MAIL FROM:<>
RCPT TO:<dsbl.org!listme>
relaytest then builds a list of possible domains, including "[127.0.0.1]", "localhost", [<ip address>], and any other domains that can be
derived from reverse DNS of the IP or the SMTP greeting.
Domain specific tests:
MAIL FROM:<nobody@DOMAIN>
RCPT TO:<listme@dsbl.org>
MAIL FROM:<nobody@DOMAIN>
RCPT TO:<"listme@dsbl.org">
MAIL FROM:<nobody@DOMAIN>
RCPT TO:listme@dsbl.org
MAIL FROM:<nobody@DOMAIN>
RCPT TO:<listme%dsbl.org@DOMAIN>
MAIL FROM:<nobody@DOMAIN>
RCPT TO:<listme%dsbl.org>
MAIL FROM:<nobody@DOMAIN>
RCPT TO:<"listme%dsbl.org">
MAIL FROM:<nobody@DOMAIN>
RCPT TO:<listme@dsbl.org@DOMAIN>
MAIL FROM:<nobody@DOMAIN>
RCPT TO:<"listme@dsbl.org"@DOMAIN>
MAIL FROM:<nobody@DOMAIN>
RCPT TO:<@DOMAIN:listme@dsbl.org>
MAIL FROM:<nobody@DOMAIN>
RCPT TO:<dsbl.org!listme>
MAIL FROM:<nobody@DOMAIN>
RCPT TO:<dsbl.org!listme@DOMAIN>
MAIL FROM:<DOMAIN!nobody>
RCPT TO:<dsbl.org!listme>
MAIL FROM:<DOMAIN!nobody>
RCPT TO:<dsbl.org!listme@DOMAIN>
MAIL FROM:<nobody@DOMAIN>
RCPT TO:<listme@dsbl.org>
MAIL FROM:<postmaster@DOMAIN>
RCPT TO:<listme@dsbl.org>
MAIL FROM:<administrator@DOMAIN>
RCPT TO:<listme@dsbl.org>
MAIL FROM:<sales@DOMAIN>
RCPT TO:<listme@dsbl.org>
MAIL FROM:<info@DOMAIN>
RCPT TO:<listme@dsbl.org>
MAIL FROM:<webmaster@DOMAIN>
RCPT TO:<listme@dsbl.org>
MAIL FROM:<listserv@DOMAIN>
RCPT TO:<listme@dsbl.org>
relaytest then tries a variety of SMTP AUTH methods to try to relay a message through the target server.
The envelopes used for these tests are always:
MAIL FROM:<sender@source.com>
RCPT TO:<listme@dsbl.org>
The SMTP AUTH methods tried are as follows:
AUTH LOGIN, user=/webmaster, password=(null)
AUTH LOGIN, user=admin, password=admin
AUTH LOGIN, user=administrator, password=(null)
AUTH LOGIN, user=test, password=test
AUTH NTLM (anonymous)
OPTIONS -v Verbose mode. Details of the SMTP transaction are written to standard output.
AUTHOR
Ian Gulliver <ian@penguinhosting.net>
SEE ALSO dsbl.conf(5), spamtrap(1)
2002-04-03 relaytest(1)