Selecting rows from a pipe delimited file based on condition
HI all,
I have a simple challenge for you.. I have the following pipe delimited file
I need only the rows which have the 3rd column less than 900. As shown below.
i have a file whose data is like this::
osr_pe_assign|-120|wg000d@att.com|4|
osr_evt|-21|wg000d@att.com|4|
pe_avail|-21|wg000d@att.com|4|
osr_svt|-11|wg000d@att.com|4|
pe_mop|-13|wg000d@att.com|4|
instar_ready|-35|wg000d@att.com|4|
nsdnet_ready|-90|wg000d@att.com|4|... (6 Replies)
Hi
My pipe delimited .txt file contains rows with 10 columns.
Can anyone advise how I output to file only those rows with the letters ‘ci'
as the first 2 characters in the 3rd column ?
Many thanks (4 Replies)
Hi All,
I have space delimited file similar to the one as shown below.. I need to convert it as a pipe delimited, the values inside the pipe delimited file should be as highlighted...
AA ATIU2345098809 009697 005374
BB ATIU2345097809 005445 006518
CC ATIU9685098809 003215 003571
DD... (7 Replies)
I have a file which was pipe delimited, I need to make it tab delimited. I tried with sed but no use
cat file | sed 's/|//t/g'
The above command substituted "/t" not tab in the place of pipe.
Sample file:
abc|123|2012-01-30|2012-04-28|xyz
have to convert to:
abc 123... (6 Replies)
I have a space delimited text file. I want to extract rows where the third column has 0 as a value and write those rows into a new space delimited text file. How do I go about doing that? Thanks! (2 Replies)
Hi guys,
I need to know how i can ignore Pipe '|' if Pipe is coming as a column in Pipe delimited file
for eg:
file 1:
xx|yy|"xyz|zzz"|zzz|12...
using below awk command
awk 'BEGIN {FS=OFS="|" } print $3
i would get xyz
But i want as :
xyz|zzz to consider as whole column... (13 Replies)
I have a file some thing like this:
GN Name=YWHAB;
RC TISSUE=Keratinocyte;
RC TISSUE=Thymus;
CC -!- FUNCTION: Adapter protein implicated in the regulation of a large
CC spectrum of both general and specialized signaling pathways
GN Name=YWHAE;
RC TISSUE=Liver;
RC ... (13 Replies)
Hi, I have a rquirement in unix as below .
I have a text file with me seperated by | symbol and i need to generate a excel file through unix commands/script so that each value will go to each column.
ex:
Input Text file:
1|A|apple
2|B|bottle
excel file to be generated as output as... (9 Replies)
All,
I have a text file(Inputfile.csv) with millions of rows and 100 columns. Check the sample for 2 columns below.
Key,Check
A,1
A,2
A,
A,4
B,0
B,1
B,2
B,3
B,4
....
million rows.
My requirement is to delete all the rows corresponding to all the keys which ever has at least one... (4 Replies)
I have a file as below
Emp1|FirstName|MiddleName|LastName|Address|Pincode|PhoneNumber
1234|FirstName1|MiddleName2|LastName3| Add1 || ADD2|123|000000000
2345|FirstName2|MiddleName3|LastName4|
Add1 || ADD2|
234|000000000
OUTPUT :
... (1 Reply)
Discussion started by: styris
1 Replies
LEARN ABOUT DEBIAN
dh_makeclilibs
DH_MAKECLILIBS(1) Debhelper for CLI (Common Language Infrastructure) DH_MAKECLILIBS(1)NAME
dh_makeclilibs - automatically create clilibs file
SYNOPSIS
dh_makeclilibs [debhelper options] [-r] [-V[dependancies]] [-mminversion] [-lnextincompatible] [-Xitem]
DESCRIPTION
dh_makeclilibs is a debhelper program that automatically scans for versioned CIL (.NET) assemblies, and generates a clilibs file for the
libraries it finds.
By default, dh_makeclilibs scans the .dll files in the package directories and writes the discovered compatibility data (major/minor,
build, token) to "clilibs" files in the appropriate packages.
However, if a file like debian/package.clilibs is found, this one will be installed and no scanning is performed.
OPTIONS -V, -Vdependancies
--version-info, --version-info=dependancies
By default, the clilibs file generated by this program does not make packages depend on any particular version of the package
containing the assembly. It may be necessary for you to add some version dependency information to the clilibs file. If -V is
specified with no dependency information, the current version of the package is plugged into a dependency that looks like "packagename
(>= packageversion)". If -V is specified with parameters, the parameters can be used to specify the exact dependency information needed
(be sure to include the package name).
Beware of using -V without any parameters; this is a conservative setting that always ensures that other packages' shared library
dependencies are at least as tight as they need to be, so that if the maintainer screws up then they won't break. The flip side is that
packages might end up with dependencies that are too tight and so find it harder to be upgraded.
-mminversion
Like -V, but specifies only the version string, the package name comes from the package that is actually processed. This option is more
flexible if you try to set a range of valid versions for different assembly packages coming from one source package.
-lnextincompatible
Specifies the (expected) version of this package when the compatibility to the current assemblies will break.
-r An experimental option to automaticaly guess the next incompatible upstream version and insert them (like working with -l and -m
options, see above). Do not expect the guessed values to be always correct - normally, the usualy assumed version string has the form
generation.major.minor where versions with changes in "minor" are compatible and "major" versions break with compatibility.
-Xitem, --exclude=item
Exclude files that contain "item" anywhere in their filename or directory from being treated as shared libraries.
--internal-mono
Uses the Mono runtime in . (used for bootstrapping Mono packages)
EXAMPLES
dh_makeclilibs
Assuming this is a package named libfoobar0.9x-cil, generates a clilibs file that looks something like:
libfoobar 1.0.2345.0_23a12f34 libfoobar0.9x-cil
dh_makeclilibs -V
Assuming the current version of the package is 0.93-3, generates a clilibs file that looks something like:
libfoobar 1.0.2345.0_23a12f34 libfoobar0.9x-cil (>= 0.93-3)
dh_makeclilibs -V 'libfoobar0.9x-cil (>= 0.92)'
Generates a clilibs file that looks something like:
libfoobar 1.0.2345.0_23a12f34 libfoobar0.9x-cil (>= 0.92)
Assuming that your package creates libfoobar-cil and liblafasel-cil, which are compatible to 0.92 versions but the upstream is going to
break compatibility in the next version, 0.94:
dh_makeclilibs -m 0.92 -l 0.94
Generates clilibs file that looks something like:
libfoobar 1.0.2345.0_23a12f34 libfoobar-cil (>= 0.92), libfoobar-cil (<< 0.94)
and
liblafasel 1.0.2345.0_23a12f34 liblafasel-cil (>= 0.92), liblafasel-cil (<< 0.94)
SEE ALSO debhelper(7)
This program is a part of cli-common-dev.
KNOWN BUGS
Will possibly not work correctly with DH_COMPAT levels 1 and 2.
AUTHOR
Mirco Bauer <meebey@meebey.net>, Eduard Bloch <blade@debian.org>, inspired by dh_makeshlibs by Joey Hess <joeyh@debian.org>
perl v5.14.2 2012-01-17 DH_MAKECLILIBS(1)