Dear community,
maybe I'm asking the moon , but I'm scratching my head to find a solution for it.
I have a file called query.out (coming from Oracle query), the file is like this:
What I would like to do is remove unneeded rows and chars (like CRLF) and have the following output to simplify my post analysis:
So, in the final output file I would like to have two lines reported in one row and other rows deleted (like --------------).
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)
I have a file like below and want to use awk to solve this problem. The record separator is ">". I want to look at each record section enclosed within ">". Find the row with the 2nd and 3rd columns being 0, such as
10 0 0
I need to take the first number which in this case is 10. Then... (15 Replies)
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)
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)
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)
I'm trying to move a large folder to an external drive but some files have these weird chars that the external drive won't accept.
Does anyone know any command of any bash script that will look through a given folder and remove any weird chars? (4 Replies)
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)
Running SunOs 5.6. Solaris.
I've been able to remove all special characters from a fixed length file which appear in the first column but as a result all subsequent columns have shifted to the left by the amount of characters deleted.
It is a space separated file. Line 1 in input file is... (6 Replies)
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 DEBIAN
isdnconf
ISDNCONF(1) Linux System Utilities ISDNCONF(1)NAME
isdnconf - manipulate or read ISDN phone number config files.
SYNOPSIS
isdnconf
DESCRIPTION
isdnconf can manipulate or read the file /etc/isdn/callerid.conf as well as ~/.isdn. Entries can be added or removed from these files.
Additionally, entries can be searched for and displayed in a way similar to grep. An entry can be an own MSN ([MSN]) or a phone number
([NUMBER]).
You can use this program to build your own phonebook. These files are used by many of the other ISDN utilities that use phone numbers, to
display a number symbolicly instead of as a plain number.
OPTIONS
Note: usage of the options -A and -D is dangerous! The complete structure of the file may be changed, and all comments are removed! Make
backups of your data files before trying these.
COMMAND OPTIONS:
-A Add a new entry, which is read from standard input. The following values are asked for (here with examples):
Alias: Fred
Number: 0815/441777
SI: 0
Zone: 4
Interface: -
Flags: I|O
Program: /usr/local/bin/ring
User: uucp
Group: user
Interval:
Time: 8-20
Flags: (control-D here indicates end of flags)
Alias: (control-D here indicated end of entries)
If you want another [Flags] entry, simply enter the data for another program for this number at the point where the control-D was given
above.
If you want to add another number, simply enter the data for the next number at the Alias prompt.
You can also pipe the data into this program; the input data then must correspond to the prompts that the program gives! Note that you
can only add one number at a time then (there's no way of telling isdnconf that you want to stop giving Flags info and start giving the
next Alias info).
-D Delete one or more entries which match the data options given. How to supply the data to match is discussed below (see DATA OPTIONS).
-V version: display the program's version and terminate.
If both -A and -D are given together, isdnconf will terminate, as this is not a valid combination.
If neither -A nor -D is given, then isdnconf will display entries which match the data given.
DATA OPTIONS: (none applicable for -A)
-n 'number'
number: match the given number. It can contain wildcards.
-a 'alias'
alias: match the given alias name. The name can contain wildcards. Note: due to a bug, use '?' instead of '-'.
-t 'SI'
SI: match the given service indicator.
-c 'code'
code: match the area code of the phone number. Only usable for displaying (not for -A nor -D).
-i ignore case for the -n and -a options.
-w word: the parameters for -n and -a must match the whole value, not just a substring.
Examples (here for -n):
"*34*" matches 123456, 345677, 1234
"34*" matches 34567, 34111 but not 1234
"34??" matches 3411, 3456
"34" matches only 34
Without the -w option, these would match:
"*34*" matches 123456, 345677, 1234
"34*" matches 123456, 345677, 1234, 34567, 34111
"34??" matches 123456, 345677, 1234, 3411, 3456
"34" matches 123456, 345677, 1234, 3411, 3456, 34567
-d and: by default the values given to options -n, -a and -t will be combined with a logical OR. If these should be combined with a logi-
cal AND (which is probably what most people expect!) you must use this -d option. In this case you can only supply each of the -n, -a
and -t options exactly once.
OTHER OPTIONS:
-q quiet: when using the -A or -D commands, the output is suppressed. When not using the -A or -D commands, only the alias of the match-
ing number is shown, or just the number in case the alias is not found.
-m MSN: when used in combination with the -A command, instructs isdnconf to create a new MSN entry; the default is to create a new NUMBER
entry. Only the values alias, number, SI, zone and interface are applicable to an MSN entry.
The following two options do not apply to the -A and -D commands. They only change the output format.
-s short: only display the alias and the number.
-l long: also display the programs to run ([START]).
-f 'filename'
file: usually isdnconf uses the /etc/isdn/callerid.conf and the ~/.isdn files. If isdnconf should be applied to another file, use this
option.
-g global: only applies to the -A and -D commands. Instead of editing ~/.isdn, /etc/isdn/callerid.conf is edited.
-1 first: only delete or display the first entry.
-M isdnmon: used internally by isdnmon to get alias info.
AUTHOR
Andreas Kool <akool@isdn4linux.de>
manpage adapted from the README by Paul Slootman <paul@isdn4linux.de>
SEE ALSO callerid.conf(5), isdnlog(8)isdn4k-utils-3.25 1998/12/29 ISDNCONF(1)