Hi,
May I know, if a pipe separated File is large, what is the best method to calculate the unique row count of 3rd column and get a list of unique value of the 3rdcolum?
Thanks in advance! (20 Replies)
I'm loading multiple delimited files into an Oracle DB using sqlldr on Unix. I would like to get only the most recent record per each unique key. There may be multiple updates for each key, but I only want the most recent one.
There is a date column in my delimited files, so I'm using cat to... (2 Replies)
if i am in /tmp file, and i have a few DIRs under /tmp. i want to find the biggest and most recent files (from 7 days ago) in /tmp and subfolders. (3 Replies)
Input file
---------
12:name1:|host1|host1|host2|host1
13:name2:|host1|host1|host2|host3
14:name3:
......
Required output
---------------
12:name1:host1(2)|host1(1)
13:name2:host1(2)|host2(1)|host3(1)
14:name3:
where (x) - Count how many times field appears in last column
... (3 Replies)
Hello, i develop a shell unix program and i have a csv file. every time we have 5 identical lines in the first 3 columns in the fourth column can be different and the 5th too. In the 5th I have a date in yyyy / mm / dd. I want to do a sort on the 5 lines and keep only the line where there is the... (7 Replies)
I have a file with contents below
123,502
123,506
123,702
234,101
235,104
456,104
456,100
i want to sort such that i get a unique value in column A, and for those with multiple value in A, i want the lowest value in B.
output should be
123,502
234,101
235,104
456,100 (3 Replies)
I have another file with three columns A,B,C as below
123,1,502
123,2,506
123,3,702
234,4,101
235,5,104
456,6,104
456,7,100
i want to sort such that i get a unique value in column A, and for those with multiple value in A, i want the lowest value in C.
output should be
Code:... (3 Replies)
I would like to print unique lines without sort or unique. Unfortunately the server I am working on does not have sort or unique. I have not been able to contact the administrator of the server to ask him to add it for several weeks. (7 Replies)
Hello Team,
I need your help on the following:
My input file a.txt is as below:
3330690|373846|108471
3330690|373846|108471
0640829|459725|100001
0640829|459725|100001
3330690|373847|108471
Here row 1 and row 2 of column 1 are identical but corresponding column 2 value are... (4 Replies)
Hi,
I have an input file that I have sorted in a previous stage by $1 and $4. I now need something that will take the first record from each group of data based on the key being $1
Input file
1000AAA|"ZZZ"|"Date"|"1"|"Y"|"ABC"|""|AA
1000AAA|"ZZZ"|"Date"|"2"|"Y"|"ABC"|""|AA... (2 Replies)
Discussion started by: Ads89
2 Replies
LEARN ABOUT DEBIAN
backup_volinfo
BACKUP_VOLINFO(8) AFS Command Reference BACKUP_VOLINFO(8)NAME
backup_volinfo - Displays a volume's dump history from the Backup Database
SYNOPSIS
backup volinfo -volume <volume name> [-localauth]
[-cell <cell name>] [-help]
backup voli -v <volume name>
[-l] [-c <cell name>] [-h]
DESCRIPTION
The backup volinfo command displays a dump history of the specified volume, reporting information such as the date on which the volume was
dumped and the tapes that contain it. Include the ".backup" extension on the volume name if the backup version of the volume was dumped.
OPTIONS -volume <volume name>
Names the volume for which to display the dump history. Include the ".backup" or ".readonly" extension if the backup or read-only
version of the volume was dumped.
-localauth
Constructs a server ticket using a key from the local /etc/openafs/server/KeyFile file. The backup command interpreter presents it to
the Backup Server, Volume Server and VL Server during mutual authentication. Do not combine this flag with the -cell argument. For more
details, see backup(8).
-cell <cell name>
Names the cell in which to run the command. Do not combine this argument with the -localauth flag. For more details, see backup(8).
-help
Prints the online help for this command. All other valid options are ignored.
OUTPUT
The output includes a line for each Backup Database dump record that mentions the specified volume, order from most to least recent. The
output for each record appears in a table with six columns:
dumpID
The dump ID of the dump that includes the volume.
lvl The depth in the dump hierarchy of the dump level at which the volume was dumped. A value of 0 indicates a full dump. A value of 1 or
greater indicates an incremental dump made at the specified depth in the dump hierarchy.
parentid
The dump ID of the dump's parent dump. A value of 0 indicates a full dump, which has no parent; in this case, the value in the "lvl"
column is also 0.
creation date
The date and time at which the Backup System started the dump operation that created the dump.
clone date
For a backup or read-only volume, the time at which it was cloned from its read/write source. For a read/write volume, the same as the
value in the "creation date" field.
tape name
The name of the tape containing the dump: either the permanent tape name, or an AFS tape name in the format
volume_set_name.dump_level_name.tape_index where volume_set_name is the name of the volume set associated with the initial dump in the
dump set of which this tape is a part; dump_level_name is the name of the dump level at which the initial dump was backed up;
tape_index is the ordinal of the tape in the dump set. Either type of name can be followed by a dump ID in parentheses; if it appears,
it is the dump ID of the initial dump in the dump set to which this appended dump belongs.
EXAMPLES
The following example shows part of the dump history of the Backup volume "user.smith.backup":
% backup volinfo -volume user.smith.backup
DumpID lvl parentID creation date clone date tape name
924600000 1 924427600 04/20/1999 05:20 04/20/1999 05:01 user_incr_2 (924514392)
924514392 1 924427600 04/19/1999 05:33 04/19/1999 05:08 user_incr_2
924427600 0 0 04/18/1999 05:26 04/18/1999 04:58 user_full_6
. . . . . . . .
. . . . . . . .
PRIVILEGE REQUIRED
None
SEE ALSO backup(8), backup_dumpinfo(8), backup_volrestore(8)COPYRIGHT
IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.
This documentation is covered by the IBM Public License Version 1.0. It was converted from HTML to POD by software written by Chas
Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.
OpenAFS 2012-03-26 BACKUP_VOLINFO(8)