12-04-2009
some better input test data would be nice.
personally, i see no relationship between your initial paragraph ( 10 0 0 ), your test data input and then your output.
Otherwise, this sounds like a fairly straightforward awk script.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a '|' delimited file and want to remove all the records from the file if the date is greater than a year from sysdate. The layout of the file is as below -
xxxxxxxxxxxxxx|yyyyyy|zzzzzz|2009-12-27-00:00| 000000000|N
xxxxxxxxxxxxxx|yyyyyy|zzzzzz|2010-01-03-00:00| 000000000|N... (4 Replies)
Discussion started by: Max_2503
4 Replies
2. Shell Programming and Scripting
Hi,
I am not sure if this has already been asked (I tried the search but the search was too broad). Basically I want to remove rows based on another file.
So file1 looks like this (tab seperated):
HHN 3 5 5
HUJ 2 2 1
JJJ 3 1 1
JUN 2 1 3
I have another file (file2)... (2 Replies)
Discussion started by: kylle345
2 Replies
3. Shell Programming and Scripting
Sorry I made a mistake in my last post (output is suppose to be the opposite). Here is a revised post.
Hi,
I am not sure if this has already been asked (I tried the search but the search was too broad). Basically I want to remove rows based on another file.
So file1 looks like this (tab... (3 Replies)
Discussion started by: kylle345
3 Replies
4. Shell Programming and Scripting
Hi I need a way of removing rows from a txt file that are older than 30 days from today, going by the date in column 2, below is an example from my file. I have tried awk but don't have enough knowledge. I would really appreciate some help.
41982,15/07/2010,H833AB/0,JZ,288... (6 Replies)
Discussion started by: firefox2k2
6 Replies
5. Shell Programming and Scripting
Dear community,
maybe I'm asking the moon :rolleyes:, but I'm scratching my head to find a solution for it. :wall:
I have a file called query.out (coming from Oracle query), the file is like this:
ADDR TOTAL
-------------------- ----------
TGROUPAGGR... (16 Replies)
Discussion started by: Lord Spectre
16 Replies
6. Shell Programming and Scripting
Hello Everyone,
I am trying to find a way to take a .csv file with 7 columns and a ton of rows (over 600,000) and remove the entire row if the cell in forth column is blank.
Just to give you a little background on why I am doing this (just in case there is an easier way), I am pulling... (3 Replies)
Discussion started by: MrTuxor
3 Replies
7. Shell Programming and Scripting
Hello,
I am trying to eliminate rows where the first field is duplicated, leaving the row where the last field is "NET".
Data file:
345234|22.34|LST
546543|55.33|LST
793929|98.23|LST
793929|64.69|NET
149593|49.22|LST
Desired output:
345234|22.34|LST
546543|55.33|LST... (2 Replies)
Discussion started by: palex
2 Replies
8. Shell Programming and Scripting
Hello
I have a file with contents like this...
Part1 Field2 Field3 Field4 (line1)
Part2 Field2 Field3 Field4 (line2)
Part3 Field2 Field3 Field4 (line3)
Part1 Field2 Field3 Field4 (line4)
Part4 Field2 Field3 Field4 (line5)
Part5 Field2 Field3 Field4 (line6)
Part2 Field2 Field3 Field4... (7 Replies)
Discussion started by: ekbaazigar
7 Replies
9. UNIX for Dummies Questions & Answers
Background:
I have a file of thousands of potential SSR primers from Batch Primer 3.
I can't use primers that will contain the same sequence ID or sequence as another primer.
I have some basic shell scripting skills, but not enough to handle this.
What you need to know:
I need to remove the... (1 Reply)
Discussion started by: msatseqs
1 Replies
10. Shell Programming and Scripting
Hi,
I have a requirement where I need to delete given number of top and bottom rows in a flat file which has new line as its delimiter.
For ex: if top_rows=2 & bottom_rows=1
Then in a given file which looks like:
New York
DC
LA
London
Tokyo
Prague
Paris
Bombay
Sydney... (7 Replies)
Discussion started by: calredd
7 Replies
LEARN ABOUT CENTOS
lgroupmod
lgroupmod(1) General Commands Manual lgroupmod(1)
NAME
lgroupmod - Modify an user group
SYNOPSIS
lgroupmod [OPTION]... group
DESCRIPTION
Modifies the user group with name group.
OPTIONS
-A, --admin-add=list
Add users in comma-separated list among group's administrators.
-a, --admin-remove=list
Remove users in comma-separated list from group's administrators. Removing users that are not currently among group's administra-
tors silently succeeds.
-g, --gid=gid
Change group's group ID to gid.
-i, --interactive
Ask all questions when connecting to the user database, even if default answers are set up in libuser configuration.
-L, --lock
Lock group. This prevents users from using the group password with newgrp(1) to become a member of group.
-M, --member-add=list
Add users in comma-separated list among group's members.
-m, --member-remove=list
Remove users in comma-separated list from group's members. Removing users that are not currently among group's members silently
succeeds.
-n, --name=name
Rename group to name.
-P, --plainpassword=password
Set group's password to password. Note that the password can be viewed while running lgroupmod using tools such as ps(1).
-p, --password=encrypted
Set group's password to the password represented by the hash encrypted. Note that the hash can be viewed while running lgroupmod
using tools such as ps(1).
-U, --unlock
Unlock group.
EXIT STATUS
The exit status is 0 on success, nonzero on error.
libuser Jan 11 2005 lgroupmod(1)