Sponsored Content
Top Forums Shell Programming and Scripting Remove duplicated records and update last line record counts Post 303032048 by Don Cragun on Sunday 10th of March 2019 06:29:06 AM
Old 03-10-2019
Quote:
Originally Posted by nezabudka
Hi Don, thanks for the explanation.
Code:
awk 'BEGIN {FS=OFS=","} /^T/ {$2=length(A)} !A[$0]++'

Hi nezabudka,
Always glad to help.

This is another interesting way to do it. Unfortunately, the standards do not specify the behavior of the awk length built-in function when given an array name as an argument. This use is described on the GNU gawk man page and works in BSD awk version 20070501 (but is not documented in the BSD awk man page) that is installed on macOS Mojave (version 10.14.3).

I have no idea whether or not this will work (as an undocumented feature) on green_k's Solaris system in /usr/xpg4/bin/awk or nawk. I also do not know if gawk is installed on green_k's system.
This User Gave Thanks to Don Cragun For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

remove duplicated xml record in a file under unix

Hi, If i have a file with xml format, i would like to remove duplicated records and save to a new file. Is it possible...to write script to do it? (8 Replies)
Discussion started by: happyv
8 Replies

2. Shell Programming and Scripting

remove duplicated columns

hi all, i have a file contain multicolumns, this file is sorted by col2 and col3. i want to remove the duplicated columns if the col2 and col3 are the same in another line. example fileA AA BB CC DD CC XX CC DD BB CC ZZ FF DD FF HH HH the output is AA BB CC DD BB CC ZZ FF... (6 Replies)
Discussion started by: kamel.seg
6 Replies

3. Shell Programming and Scripting

Help to Add and Remove Records only from first line/last line

Hi, I need help with a maybe total simple issue but somehow I am not getting it. I am not able to etablish a sed or awk command which is adding to the first line in a text and removing only from the last line the ",". The file is looking like follow: TABLE1, TABLE2, . . . TABLE99,... (4 Replies)
Discussion started by: enjoy
4 Replies

4. Shell Programming and Scripting

Sending e-mail of record counts in 3 or more files

I am trying to load data into 3 tables simultaneously (which is working fine). Then when loaded, it should count the total number of records in all the 3 input files and send an e-mail to the user. The script is working fine, as far as loading all the 3 input files into the database tables, but... (3 Replies)
Discussion started by: msrahman
3 Replies

5. Shell Programming and Scripting

Split a single record to multiple records & add folder name to each line

Hi Gurus, I need to cut single record in the file(asdf) to multile records based on the number of bytes..(44 characters). So every record will have 44 characters. All the records should be in the same file..to each of these lines I need to add the folder(<date>) name. I have a dir. in which... (20 Replies)
Discussion started by: ram2581
20 Replies

6. UNIX for Dummies Questions & Answers

Hardcoding & Record counts in a file

HI , I am having a huge comma delimiter file, I have to append the following four lines before the starting of the file through a shell script. FILE NAME = TEST_LOAD DATETIME = CURRENT DATE TIME LOAD DATE = CURRENT DATE RECORD COUNT = TOTAL RECORDS IN FILE Source data 1,2,3,4,5,6,7... (7 Replies)
Discussion started by: shruthidwh
7 Replies

7. Shell Programming and Scripting

New file should store all the 7 existing filenames and their record counts and ftp th

Hi, I need help regarding below concern. There is a script and it has 7 existing files(in a path say,. usr/appl/temp/file1.txt) and I need to create one new blank file say “file_count.txt” in the same script itself. Then the new file <file_count.txt> should store all the 7 filenames and... (1 Reply)
Discussion started by: pr293
1 Replies

8. Shell Programming and Scripting

How to Remove the new line character inbetween a record

I have a file, in which a single record spans across multiple lines, File 1 ==== 14|\n leave request \n accepted|Yes| 15|\n leave request not \n acccepted|No| I wanted to remove the '\n charecters. I used the below code (foudn somewhere in this forum) perl -e 'while (<>) { if... (1 Reply)
Discussion started by: machomaddy
1 Replies

9. Shell Programming and Scripting

How to remove duplicated lines?

Hi, if i have a file like this: Query=1 a a b c c c d Query=2 b b b c c e . . . (7 Replies)
Discussion started by: the_simpsons
7 Replies

10. Shell Programming and Scripting

Join files, omit duplicated records from one file

Hello I have 2 files, eg more file1 file2 :::::::::::::: file1 :::::::::::::: 1 fromfile1 2 fromfile1 3 fromfile1 4 fromfile1 5 fromfile1 6 fromfile1 7 fromfile1 :::::::::::::: file2 :::::::::::::: 3 fromfile2 5 fromfile2 (4 Replies)
Discussion started by: CHoggarth
4 Replies
nsupdate(1)						      General Commands Manual						       nsupdate(1)

NAME
nsupdate - Dynamic DNS update utility SYNOPSIS
keyfile | udpretries] timeout] udptimeout] [filename] DESCRIPTION
submits Dynamic DNS update requests to a name server, as defined in RFC 2136. This allows resource records to be added to or removed from a zone without manually editing the zone file. A single update request can contain requests to add or remove more than one resource record. Zones that are under dynamic control via or a DHCP server should not be edited by hand. Manual edits could conflict with dynamic updates and cause data to be lost. The resource records that are dynamically added or removed with have to be in the same zone. Requests are sent to the zone's master server. This is identified by the field of the zone's record. Transaction signatures can be used to authenticate the Dynamic DNS updates. These use the resource record type described in RFC 2845 or the SIG(0) record described in RFC 2535 and RFC 2931. relies on a shared secret that should only be known to and the name server. Cur- rently, the only supported encryption algorithm for is which is defined in RFC 2104. Once other algorithms are defined for applications will need to ensure they select the appropriate algorithm as well as the key when authenticating each other. For instance, suitable and statements would be added to so that the name server can associate the appropriate secret key and algorithm with the IP address of the client application that will be using authentication. SIG(0) uses public key cryptog- raphy. To use a SIG(0) key, the public key must be stored in a record in a zone served by the name server. does not read Options Operate in debug mode. This provides tracing information about the update requests that are made and the replies received from the name server. Provide the shared secret needed to generate a record for authenticating Dynamic DNS update requests. With this option, reads the shared secret from the file key- file, whose name is of the form For historical reasons, the file must also be present. This option is mutually exclusive with the option. may also be used to specify a SIG(0) key used to authenticate Dynamic DNS update requests. In this case, the key specified is not an key. Set the number of UDP retries. The default is 3. If set to zero only one update request will be made. Set the maximum time in seconds a update request can take before it is aborted. The default is 300 seconds. Zero can be used to disable the timeout. Set the UDP retry interval in seconds. The default is 3 seconds. If set to zero the interval will be computed from the timeout interval and number of UDP retries. Use a TCP connection to send update requests to the name server. By default, uses UDP to send update requests. This may be preferable when a batch of update requests is made. Generate a signature from keyname and secret. keyname is the name of the key, and secret is the base-64-encoded shared secret. The use of the option is discouraged because the shared secret is supplied as a command line argument in clear text. This may be visible in the output from ps(1) or in a history file maintained by the user's shell. Operands filename A file of commands, as described in the section. The default is standard input. Input Format reads commands from filename or standard input. Each command is supplied on exactly one line of input. Some commands are for administra- tive purposes; others are either update instructions or prerequisite checks on the contents of the zone. The checks set conditions that some name or set of resource records (RRset) either exists or is absent from the zone. These conditions must be met if the entire update request is to succeed. Updates will be rejected if the tests for the prerequisite conditions fail. Every update request consists of zero or more prerequisites and zero or more updates. This allows a suitably authenticated update request to proceed if some specified resource records are present or missing from the zone. The command or a blank input line causes the accumu- lated commands to be sent as one Dynamic DNS update request to the name server. The Commands The command formats and their meaning are as follows: Lines beginning with a semicolon are comments and are ignored. Sends all dynamic update requests to the name server servername. When no statement is provided, sends updates to the master server of the correct zone. The field of that zone's record identifies the master server for that zone. port is the port number on servername where the dynamic update requests are sent. If no port number is specified, the default DNS port number of 53 is used. Sends all dynamic update requests using the local address. When no statement is provided, sends updates using an address and port chosen by the system. port can additionally be used to make requests come from a specific port. If no port number is specified, the system assigns one. Specifies that all updates are to be made to the zone zonename. If no statement is provided, attempts to determine the correct zone to update, based on the rest of the input. Specifies the default class. If no class is specified, the default class is Specifies that all updates are to be TSIG-signed using the keyname keysecret pair. The command overrides any key specified on the command line with or Requires that no resource record of any type exists with name domain-name. Requires that domain-name exists (has as at least one resource record of any type). Requires that no resource record exists of the specified type, class, and domain-name. If class is omitted, (Internet) is assumed. Requires that a resource record of the specified type, class, and domain-name must exist. If class is omitted, (Internet) is assumed. The data from each set of prerequisites of this form sharing a common type, class, and domain-name are combined to form a set of RRs (resource records). This set of RRs must exactly match the set of RRs existing in the zone at the given type, class, and domain-name. The data are written in the standard text representation of the resource record's RDATA. Deletes any resource records named domain-name. If type and data are provided, only matching resource records will be removed. The Internet class is assumed if class is not supplied. Adds a new resource record with the specified ttl, class and data. Displays the current message, containing all the prerequisites and updates specified since the last operation. Sends the current message. This is equivalent to entering a blank line. Displays the answer. EXAMPLES
The examples below show how could be used to insert and delete resource records from the zone. Notice that the input in each example con- tains a trailing blank line so that a group of commands are sent as one dynamic update request to the master name server for Example 1 Any A records for are deleted. An A record for with IP address 172.16.1.1 is added. The newly-added record has a 1 day TTL (86400 sec- onds) Example 2 The prerequisite condition gets the name server to check that there are no resource records of any type for If there are, the update request fails. If this name does not exist, a for it is added. This ensures that when the record is added, it cannot conflict with the long-standing rule in RFC 1034 that a name must not exist as any other record type if it exists as a (The rule has been updated for DNSSEC in RFC 2535 to allow records to have and records.) WARNINGS
The key is redundantly stored in two separate files. This is a consequence of using the DST library for its cryptographic operations, and may change in future. AUTHOR
was developed by the Internet Systems Consortium (ISC). FILES
Used to identify default name server. Base-64 encoding of key created by Base-64 encoding of key created by SEE ALSO
dnssec-keygen(1), named(1M). Requests for Comments (RFC): 1034, 2104, 2136, 2137, 2535, 2845, 2931, available online at available online at available from the Internet Systems Consortium at BIND 9.3 nsupdate(1)
All times are GMT -4. The time now is 09:26 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy