01-06-2010
Hello patrick,
I am glad that I was able to help you.
you are most welcome.
Take care,
Regards.
Gaurav.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I am processing a file and would like to delete duplicate records as indicated by one of its column. e.g.
COL1 COL2 COL3
A 1234 1234
B 3k32 2322
C Xk32 TTT
A NEW XX22
B 3k32 ... (7 Replies)
Discussion started by: risk_sly
7 Replies
2. Shell Programming and Scripting
Dear friends,
I have a pipe delimited file having 5 columns.
However the column no-3 is having extra new line characters as the data owing to owing , I am having issues.
Ideally my file should have only newline termination at the end of each record and not within column data of any of... (1 Reply)
Discussion started by: sureshg_sampat
1 Replies
3. Shell Programming and Scripting
Input
data_10 SSA
data_2 TYUE
data_3 PEOCV
data_6 SSAT
data_21 SSA
data_19 TYUEC
data_14 TYUE
data_15 SSA
data_32 PEOCV
.
.
Desired Output
data_10 SSA
data_2 TYUE
data_3 PEOCV
data_6 SSAT
data_19 TYUEC (9 Replies)
Discussion started by: patrick87
9 Replies
4. Shell Programming and Scripting
Hello. I was wondering if anyone could help. I have a file containing a large table in the format:
marker1 marker2 marker3 marker4
position1 position2 position3 position4
genotype1 genotype2 genotype3 genotype4
with marker being a name, position a numeric... (2 Replies)
Discussion started by: davegen
2 Replies
5. UNIX for Dummies Questions & Answers
Hello, I'm trying to delete duplicates when there are more than 10 duplicates, based on the value of the first column.
e.g.
a 1
a 2
a 3
b 1
c 1
gives
b 1
c 1
but requires 11 duplicates before it deletes.
Thanks for the help
Video tutorial on how to use code tags in The UNIX... (11 Replies)
Discussion started by: informaticist
11 Replies
6. Shell Programming and Scripting
I have a data file in the format of
1234 xxx
1234 xxx
1234 xxx
1234 xxxI want to be able to calculate the following -
COLUMN1+((LINENUMBER-1)/365)
The output needs to preserve the 2nd column -
1234 xxx
1234.00274 xxx
1234.00548 xxx
What is the best way to do this? I am somewhat... (9 Replies)
Discussion started by: ncwxpanther
9 Replies
7. Shell Programming and Scripting
Good day all.
Using basic UNIX/Linux tools, how would you delete a line based on a character found in column 1?
For example, if the CITY name contains an 'a' or 'A', delete the line:
New York City; New York
Los Angeles; California
Chicago; Illinois
Houston; Texas
Philadelphia;... (3 Replies)
Discussion started by: BRH
3 Replies
8. Shell Programming and Scripting
Dear members, I need to filter a file based on the 8th column (that is id), and does not mather the other columns, because I want just one id (1 line of each id) and remove the duplicates lines based on this id (8th column), and does not matter wich duplicate will be removed.
example of my file... (3 Replies)
Discussion started by: clarissab
3 Replies
9. Shell Programming and Scripting
Hi,
I have a file with many sections in it. Each section is separated by a blank line.
The first line of each section would determine if the section is duplicate or not.
if the section is duplicate then remove the entire section from the file.
below is the example of input and output.... (5 Replies)
Discussion started by: ahmedwaseem2000
5 Replies
10. Shell Programming and Scripting
Hi guys,
I need to append new data at the end of each line of the files. This new data is based on substring (3rd fields) of last column.
Input file xxx.csv:
U1234|1-5X|orange|1-5X|Act|1-5X|0.1 /sac/orange 12345 0
U5678|1-7X|grape|1-7X|Act|1-7X|0.1 /sac/grape 5678 0... (5 Replies)
Discussion started by: null7
5 Replies
XPATH(1p) User Contributed Perl Documentation XPATH(1p)
NAME
xpath - a script to query XPath statements in XML documents.
SYNOPSIS
xpath [-s suffix] [-p prefix] [-q] -e query [-e query] ... [file] ...
DESCRIPTION
xpath uses the XML::XPath perl module to make XPath queries to any XML document. The XML::XPath module aims to comply exactly to the XPath
specification at "http://www.w3.org/TR/xpath" and yet allows extensions to be added in the form of functions.
The script takes any number of XPath pointers and tries to apply them to each XML document given on the command line. If no file arguments
are given, the query is done using "STDIN" as an XML document.
When multiple queries exist, the result of the last query is used as context for the next query and only the result of the last one is
output. The context of the first query is always the root of the current document.
OPTIONS
-q
Be quiet. Output only errors (and no separator) on stderr.
-s suffix
Place "suffix" at the end of each entry. Default is a linefeed.
-p prefix
Place "prefix" preceding each entry. Default is nothing.
BUGS
The author of this man page is not very fluant in english. Please, send him (fabien@tzone.org) any corrections concerning this text.
See also XML::XPath(3pm).
SEE ALSO
XML::XPath(3pm).
HISTORY
This module is copyright 2000 Fastnet Software Ltd. This is free software, and as such comes with NO WARRANTY. No dates are used in this
module. You may distribute this module under the terms of either the Gnu GPL, or under specific licencing from Fastnet Software Ltd.
Special free licencing consideration will be given to similarly free software. Please don't flame me for this licence - I've put a lot of
hours into this code, and if someone uses my software in their product I expect them to have the courtesy to contact me first.
Full support for this module is available from Fastnet Software Ltd on a pay per incident basis. Alternatively subscribe to the Perl-XML
mailing list by mailing lyris@activestate.com with the text:
SUBSCRIBE Perl-XML
in the body of the message. There are lots of friendly people on the list, including myself, and we'll be glad to get you started.
Matt Sergeant, matt@sergeant.org
This man page was added as well as some serious modifications to the script by Fabien Ninoles <fabien@debian.org> for the Debian Project.
perl v5.10.1 2009-12-30 XPATH(1p)