I know this is a complicated question but I will try to illustrate it with some data. I have a data file that looks like the following:
I want to look at the first column and delete lines where the value on the first column is not repeated at least 6 times (in 6 different rows) throughout the text file. For example, there are 6 rows which start with 1341 or 1350 so I would keep those rows. But there are only 2 rows which start with 1362, so that row would be deleted. In the end my output would look like this:
Thanks a lot!
Last edited by joeyg; 06-28-2011 at 03:04 PM..
Reason: Please wrap scripts and data with CodeTags - makes easier to see & cut/paste
I am getting some spaces between the two lines(rows) in file.i want delete that empty rows in the file
example
1 abc xyz
2 def jkl
like i am having lots of rows in a file i want to delete the spce between the two rows give any... (7 Replies)
Hello,
I am supposed to process about 100 csv files. But these files have some extra lines at the bottom of the file. these extra lines start with a header for each column and then some values below. These lines are actually a summary of the actual data and not supposed to be processed. These... (8 Replies)
Hi Guys,
I need help in modifying a large text file containing more than 1-2 lakh rows of data using unix commands. I am quite new to the unix language
the text file contains data in a pipe delimited format
sdfsdfs
sdfsdfsd
START_ROW
sdfsd|sdfsdfsd|sdfsdfasdf|sdfsadf|sdfasdf... (9 Replies)
Fruit : Price : Quantity
apple : 20 : 40
chiku : 40 :30
Hey guys, i have written a code using sed to delete a specific char which is being typed in. But the problem i am having is , how can i expand my coding to actually allow it do delete the whole row. For example,... (21 Replies)
I have this space delimited large text file with more than 1,000,000+ columns and about 100 rows. I want to delete all the cells that consist of just 2 (leave 2's that are not by themselves intact):
File before modification
aa bb cc 2 NA100 dd
aa b1 c2 2 NA102 de
File after modification... (1 Reply)
Hi,
I have a tab delimited text file where I want to delete all rows that have the same string for column 1. How do I go about doing that? Thanks!
Example Input:
aa 1
aa 2
aa 3
bb 4
bc 5
bb 6
cd 8
Output:
bc 5
cd 8 (4 Replies)
Hi,
I'm trying to search for some number and from that line, i need to delete the 5th line exactly.
Eg:
Consider below as text file data:
10000
a
b
c
d
e
.
.
.
10000
w
q
t (8 Replies)
Discussion started by: Gautham
8 Replies
LEARN ABOUT HPUX
leave
leave(1) General Commands Manual leave(1)NAME
leave - remind you when you have to leave
SYNOPSIS
[hhmm]
DESCRIPTION
The command waits until the specified time, then reminds you to leave. You are reminded 5 minutes and 1 minute before the actual time, at
the time, and every minute thereafter. When you log off, exits.
The time of day is in the form hhmm, where hh is a time in hours (which can range from 0 through 11 or 0 through 24 hours), and mm is the
number of minutes after the specified hour. If the value of hh is greater than 11 (24-hour clock time), the specified value is reduced by
12 to a new value in the range of 0 through 11, thus ensuring that the alarm time is always set to activate within the next 12 hours. For
example, if hhmm is 1350 and the current time is 4:00 PM (1600), the 1350 value is changed to 150 and the alarm is set for 1:50 AM, nine
hours and 50 minutes later. On the other hand, if it is 9:00 AM and hhmm is specified as 2200 (10:00 PM), the value used is converted to
1000 and the alarm is set for one hour later instead of 13 hours as specified.
If no argument is provided, prompts with
A reply of newline causes to exit; otherwise the reply is assumed to be a time. This form is suitable for inclusion in a or file.
The command ignores interrupts, quits, and terminate signals. To get rid of it you should either log off or use giving its process ID.
EXAMPLES
The command
sends an alarm (a beep) to your terminal to remind you that you have to leave at 12:04 and reminds you that you are late at one minute
intervals after 12:04.
WARNINGS
The command checks to see if a user has logged out by checking the file every 100 seconds. If a user logs out and logs back in to the same
tty before makes its periodic check, may not know that the user has logged out.
AUTHOR
was developed by the University of California, Berkeley.
FILES SEE ALSO calendar(1).
leave(1)