02-09-2010
can you show us what you have tried?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
A file content have
1 1:-0.289433 2:0.833778 3:0.314471 4:-0.289433 5:-0.81876 6:-0.456693 7:-0.17511 8:-0.644555 9:-0.00666341 10:-1.13603
I will like to have that column into row with numbers to be printed (red color) only after colon
output shud be like that
-0.289433... (1 Reply)
Discussion started by: cdfd123
1 Replies
2. Shell Programming and Scripting
Hi,
I have a file named col.txt
1.000
2.000
3.000
4.000
5.000
6.000
7.000
8.000
I should get this
1.000 5.000
2.000 6.000
3.000 7.000 (10 Replies)
Discussion started by: G0Y
10 Replies
3. Shell Programming and Scripting
Getting tired of cut-and-paste...so I thought I would post a question.
how do I change this column output to a single row?
from this:
# vgdisplay -v /dev/vgeva05 | grep dsk | awk '{print $3}'
/dev/dsk/c6t0d5
/dev/dsk/c11t0d5
/dev/dsk/c15t0d5
/dev/dsk/c18t0d5
/dev/dsk/c7t0d5... (8 Replies)
Discussion started by: mr_manny
8 Replies
4. Shell Programming and Scripting
Hi,
I have a file like this
50 1 2 1374438
50 1 2 1682957
50 5 2 1453574
50 10 2 1985890
100 1 2 737307
100 5 2 1660204
100 10 2 2148483
and I want to convert this by... (1 Reply)
Discussion started by: gvj
1 Replies
5. Shell Programming and Scripting
Input file A.txt :-
C2062 -117.6 -118.5 -117.5
C5145 0 0 0
C5696 0 0 0
Output file B.txt
C2062 X -117.6
C2062 Y -118.5
C2062 Z -117.5... (4 Replies)
Discussion started by: asavaliya
4 Replies
6. Shell Programming and Scripting
Hi,
i need to convert
SG_ERP1
SG_ERP2
SG_ERP3
in to:
SG_ERP1 SG_ERP2 SG_ERP3
It's possibile? (16 Replies)
Discussion started by: elilmal
16 Replies
7. Shell Programming and Scripting
Hi,
I have the following file,
chr1 100 200 20
chr1 201 300 22
chr1 220 345 23
chr1 230 456 33.5
chr1 243 567 90
chr1 345 600 20
chr1 430 619 21.78
chr1 870 910 112.3
chr1 914 920 12
chr1 930 999 13
My output would be
peak1 20 22 23 33.5 90
peak2 20 21.78 112.3 12 13
Here the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies
8. Shell Programming and Scripting
Dear Perl users,
Could you help me how to convert from row to column if I've a case below:
Linux 2014_01_24 CPU 10
Linux 2014_01_24 MEM 20
UNIX 2014_01_24 CPU 30
UNIX 2014_01_24 MEM ... (6 Replies)
Discussion started by: askari
6 Replies
9. Shell Programming and Scripting
Hi Folks,
I am using db2 command -> db2 list tablespace show detail
Tablespace ID = 10
Name = TSCDDHLMSUM
Type = Database managed space
Contents = All permanent data.... (5 Replies)
Discussion started by: ckwan
5 Replies
10. Shell Programming and Scripting
Hi
FileA.txt
E_TIM 16,
ETE 15,
EOND 26,
EEC 81,
E_1 un,
E_2 un,
E_3 un,
E_4 284,
E_TIM 17,
ETE 15,
EOND 29,
EEC 82,
E_1 un,
E_2 un,
E_3 un,
E_4 249, (6 Replies)
Discussion started by: asavaliya
6 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)