In the range 4-24 column the values are duplicate some times and I will like to delete the fist occurrence and keep the last only. The file is not sorted and I can sorted because from column 75 to the end the file is increase by time..
I have a file like this
Code:
S 21301.00 21481.00 2 0 915802.1 1846679.3 48.1227 23141
S 21083.00 21397.00 1 0 916712.0 1840909.0 55.7227 42035
S 21081.00 21619.00 2 0 921533.2 1843642.2 72.2227 52203
S 21299.00 22041.00 2 0 927954.1 1853627.3 96.7227 65151
S 21309.00 21861.00 2 0 923928.7 1851604.8 77.3227 2105
S 21313.00 21353.00 2 0 912876.9 1845343.2 36.2227 30120
S 21095.00 21469.00 4 0 918111.1 1842071.9 55.0227 44452
S 21309.00 21861.00 2 0 923411.6 1851708.4 79.2227 40
S 21115.00 21869.00 1 0 926530.0 1847499.1 82.3227 58
S 21321.00 21845.00 1 0 923431.7 1851669.1 79.1227 135
S 21115.00 21871.00 1 0 926560.4 1847521.8 83.3227 153
S 21113.00 21871.00 1 0 926596.1 1847485.5 83.3227 251
S 21115.00 21871.00 1 0 923473.9 1851689.8 77.9227 309
S 21113.00 21873.00 1 0 926640.2 1847501.4 83.2227 403
S 21323.00 21847.00 1 0 923455.8 1851729.7 78.0227 439
and i would like to delete the following lines
Code:
S 21309.00 21861.00 2 0 923928.7 1851604.8 77.3227 2105
S 21115.00 21871.00 1 0 926560.4 1847521.8 83.3227 153
So, my output file should be like this.
Code:
S 21301.00 21481.00 2 0 915802.1 1846679.3 48.1227 23141
S 21083.00 21397.00 1 0 916712.0 1840909.0 55.7227 42035
S 21081.00 21619.00 2 0 921533.2 1843642.2 72.2227 52203
S 21299.00 22041.00 2 0 927954.1 1853627.3 96.7227 65151
S 21313.00 21353.00 2 0 912876.9 1845343.2 36.2227 30120
S 21095.00 21469.00 4 0 918111.1 1842071.9 55.0227 44452
S 21309.00 21861.00 2 0 923411.6 1851708.4 79.2227 40
S 21115.00 21869.00 1 0 926530.0 1847499.1 82.3227 58
S 21321.00 21845.00 1 0 923431.7 1851669.1 79.1227 135
S 21113.00 21871.00 1 0 926596.1 1847485.5 83.3227 251
S 21115.00 21871.00 1 0 923473.9 1851689.8 77.9227 309
S 21113.00 21873.00 1 0 926640.2 1847501.4 83.2227 403
S 21323.00 21847.00 1 0 923455.8 1851729.7 78.0227 439
Hi Canone please provide me solution how can achieve the result below:
File1.txt
$
sweet appleŁ1
scotish
green
$
This is a test1
$
sweet mangoŁ2
asia
yellow
$
This is a test 2
$
sweet apple red (there is no pound symbol here)
germany
green (1 Reply)
Hi All,
I am having following file and I want to delete 1 row last column.
Current File Content:
================
procedure test421 put_line
procedure test321 test421
procedure test521 test321
procedure test621 test521
Expected File Content:
===========================
procedure... (3 Replies)
Hi
I have a input file say abc.dat which contains data as below
name~address~email~ID
john~newyork~john@gmail.com~1500D
steve~sydney~steve@abc.com~3451E
Now if length of name is > 50 or ID is null then the row should rejected to another file say reject.dat along with reason for rejection... (2 Replies)
Hi,
I'm using AIX(ksh shell).
> cat temp.txt
"a","b",0
"c",bc",0
"a1","b1",0
"cc","cb",1
"cc","b2",1
"bb","bc",2
I want the output as:
"a","b","c","bc","a1","b1"
"cc","cb","cc","b2"
"bb","bc"
I want to combine multiple lines into single line where third column is same.
Is... (1 Reply)
Hi all,
I want a perl program to delete the record and its contents from a file if there is no particular line in the record given that all records are separated by a blank line.
For example:
#100
abcd
efgh
hijk
123
klm
#200
abcd
efgh
hijk
klm
So, the pattern here is 123. If... (0 Replies)
Hi All,
I felt tough to frame my question. Any way find my below input. (.CSV file)
SNo, City
1, Chennai
2, None
3, Delhi
4,None
Note that I have many rows ans also other columns beside my City column.
What I need is the below output.
SNo, City
1, Chennai
2, Chennai_new
3, Delhi... (2 Replies)
I am fairly new to programming and trying to resolve this problem. I have the file like this.
CHROM POS REF ALT 10_sample.bam 11_sample.bam 12_sample.bam 13_sample.bam 14_sample.bam 15_sample.bam 16_sample.bam
tg93 77 T C T T T T T
tg93 79 ... (4 Replies)
Hi everyone,
I have a data file in which the data is stored in event blocks. What I would like to get is that the same file with every data row starting with the number of event block. So here is two event blocks from my file:
<event>
-2 -1 0 0 0 501 0.00000000000E+00
... (2 Replies)
Hello Team,
I am stuck in getting the required output in the following case. Please help.
My input file is
aa|08/01/2016
bb|08/15/2016
I wish to convert the file into
aa|epoch time
bb|epoch time
I am using following code: (3 Replies)
Discussion started by: angshuman
3 Replies
LEARN ABOUT CENTOS
spi_modifytuple
SPI_MODIFYTUPLE(3) PostgreSQL 9.2.7 Documentation SPI_MODIFYTUPLE(3)NAME
SPI_modifytuple - create a row by replacing selected fields of a given row
SYNOPSIS
HeapTuple SPI_modifytuple(Relation rel, HeapTuple row, int ncols,
int * colnum, Datum * values, const char * nulls)
DESCRIPTION
SPI_modifytuple creates a new row by substituting new values for selected columns, copying the original row's columns at other positions.
The input row is not modified.
ARGUMENTS
Relation rel
Used only as the source of the row descriptor for the row. (Passing a relation rather than a row descriptor is a misfeature.)
HeapTuple row
row to be modified
int ncols
number of column numbers in the array colnum
int * colnum
array of the numbers of the columns that are to be changed (column numbers start at 1)
Datum * values
new values for the specified columns
const char * Nulls
which new values are null, if any (see SPI_execute_plan for the format)
RETURN VALUE
new row with modifications, allocated in the upper executor context; NULL only if row is NULL
On error, SPI_result is set as follows:
SPI_ERROR_ARGUMENT
if rel is NULL, or if row is NULL, or if ncols is less than or equal to 0, or if colnum is NULL, or if values is NULL.
SPI_ERROR_NOATTRIBUTE
if colnum contains an invalid column number (less than or equal to 0 or greater than the number of column in row)
PostgreSQL 9.2.7 2014-02-17 SPI_MODIFYTUPLE(3)
08-16-2014
