Check/print missing number in a consecutive range and remove duplicate numbers
Hi,
In an ideal scenario, I will have a listing of db transaction log that gets copied to a DR site and if I have them all, they will be numbered consecutively like below.
There will be some scenario where files are not coped for some reason maybe network failure for example so there will be gap in the list of files.
So the list above may be something like below where there is a gap in a supposed to consecutive list.
Does anyone know a quick way of checking for what is the missing number in the consecutive range?
At the moment, what I am doing is I am cutting the list into 3 separate list based on the first character. The first digit is the transaction group, the second digit is the transaction number and the 3rd digit is the db id which is a constant.
Then I am reading each new list, set the first number as a 'base' and then incrementing it by 1, assign it to a variable and then comparing that number with what I read next. If they don't match, the I print that as the missing number or gap. It is a very long tedious process.
I am hoping someone know a trick of checking what is the missing number in the consecutive range and print it.
I don't want to insert the missing number in the existing list, I will be re-directing it to an exception list so I know what transaction log is missing that I will have to re-copy.
Also in some instance, I will have a listing where there will be duplicates in the listing like below
This is where the database log was send to the DR site multiple times. Is there a way to check for which lines are duplicates and how many lines/rows are there?
For example, from the latest listing above, 1_79812_01234567.arc has 3 entries, 2_86756_01234567.arc has 3 entries, 3_82694_01234567.arc has 2 entries and so on.
Any advice will be much appreciated. Thanks in advance.
I need to edit a list of numbers on the following form:
1 1.0
2 1.4
5 2.1
7 1.9
I want:
1 1.0
2 1.4
3 0.0
4 0.0
5 2.1
6 0.0
7 1.9
(i want to add the missing number in column 1 together with 0.0 in column 2).
I guess it is rather trivial but i didn't even manage to read column... (5 Replies)
I have a text file in the following format
....
START
1,1
2,1
3,1
..
..
9,1
10,1
END
....
I want to change to the output to
....
START
1,1
2,1
3,1
.. (4 Replies)
Hi Experts,
Need help on printing of numbers, which are missing in the range.
Pls find the details below
Input
1000000002
1000000007
1234007940
1234007946
Output
1000000003
1000000004
1000000005
1000000006
1234007941 (2 Replies)
I need help with a script that will remove all HTML tags from an HTML document and remove any consecutive duplicate lines, and save it as a text document. The user should have the option of including the name of an html file as an argument for the script, but if none is provided, then the script... (7 Replies)
Hi,
I have an input file of the following style
input.txt
The 4000 at the end indicates the total no. of columns in that row.
I would like to replace all -1s with consecutive 1 and 2 and print the whole line again.
So, the output would be
output.txt
Thanks in advance. (7 Replies)
Hi all,
I have two (2) sets of files that are based on some snapshots of database that I want to merge and insert any missing sequential number.
Below are example representation of these files:
file1:
DATE TIME COL1 COL2 COL3 COL4 ID
01/10/2013 0800 100 ... (3 Replies)
Hello,
I'm trying to remove the duplicate consecutive lines with specific string "WARNING".
File.txt
abc;
WARNING 2345
WARNING 2345
WARNING 2345
WARNING 2345
WARNING 2345
bcd;
abc;
123
123
123
WARNING 1234
WARNING 2345
WARNING 2345
efgh; (6 Replies)
Discussion started by: Mannu2525
6 Replies
LEARN ABOUT HPUX
uusnaps
uusnaps(1M)uusnaps(1M)NAME
uusnaps - sort and embellish uusnap output
SYNOPSIS DESCRIPTION
The commands, including are targeted for removal from HP-UX; see the below.
runs (see uusnap(1M)) and post-processes the output into a more useful form. It sorts output lines in ``Pareto-style'', showing first
those remote systems with the greatest number of files, next files, and then files.
inserts a after the number of files on those lines where is not equal to (2 x + This may be a sign of missing or orphaned transaction
parts. Use to check (see uuls(1)).
adds summary information after all output. The first line is a total of the numbers of and files. The second line contains a grand total
number of transaction files, followed by the number of directory bytes this represents. This is an indication of the true size of the
directory itself if all empty entries were squeezed out. Finally, if it appears that transaction files might be missing or orphaned,
returns the number of missing or excess files.
WARNINGS
Use of commands, including is discouraged because they are targeted for removal from HP-UX. Use ftp(1) or rcp(1) instead.
assumes that each directory entry takes 24 bytes.
SEE ALSO uusnap(1M), uuls(1).
TO BE OBSOLETED uusnaps(1M)