Hai
Please let me know the command in unix(command mode ) from a file that deletes the whole column (not 1st and last column )& replace with numbers starting from 1.
Regards
suneetha. (8 Replies)
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)
Dear All,
I need to delete the first column, which blank in the tab delimited file and i need to print all the other columns with out disturbing the format of the file.
I have tried with the followings and its not working for my case
awk '{$1=""}1' file > newfilecut -d, -f2- dataCan anyone... (6 Replies)
Hi,
Can anyone help:
I want to get the 7th column of a file seperated by ^
Num:^ 1^ testdevice1^10.1.1.1^PT1X23^true^HD^175^up^false^bad
Num:^ 2^ testdevice2^10.1.1.2^ST1X23^true^SN^175^up^false^bad
Expected result:
HD
SN
Appreciate your help. (2 Replies)
Hello,
I have 2 columns (1st column has multiple entries but the corresponding values in the column 2 may be the same or different.) however I want to extract unique values for each entry in column 1 by assigning the max value from column 2
SDF4 -0.211654
SDF4 0.978068
... (1 Reply)
var1 var2 var3 var4 var5 var6....
A G A T G T
G A A A A A
A A A A A A
G A G T A T
let's call this "file1.txt"
we can see that var2 and var5 have the idential values.
I would like to make a script so that if any variables (could be more than 2) have the identical values, i want to... (4 Replies)
Hi All,
I have a fixedwidth file of length 3000. Now i want to copy a column of 4 chars i.e( length 1678-1681) to column 1127 – 1171 to the same file.
Please let me know how can i achive using a single command in fixed width file.
Also source column length is 4 chars and target column length... (4 Replies)
I need to delete the last 11 characters from each number and they are all in the same line (each is in a different column):
-6.89080901827020800000 3.49348891708562325136 1.47988367839905286876 -2.29707635413510400000 -3.49342364708562325136 -4.43758473239905286876 -2.29707635413510400000... (14 Replies)
Hello Team,
My source data (INput) is like below
EPIC1 router EPIC2 Targetdefinition
Exp1 Expres rtr1 Router
SQL SrcQual Exp1 Expres
rtr1 Router EPIC1 Targetdefinition
My output like
SQL SrcQual Exp1 Expres
Exp1 Expres rtr1 Router
rtr1 Router EPIC1 Targetdefinition... (5 Replies)
Discussion started by: sekhar.lsb
5 Replies
LEARN ABOUT PHP
db2_field_num
DB2_FIELD_NUM(3) 1 DB2_FIELD_NUM(3)db2_field_num - Returns the position of the named column in a result setSYNOPSIS
int db2_field_num (resource $stmt, mixed $column)
DESCRIPTION
Returns the position of the named column in a result set.
PARAMETERS
o $stmt
- Specifies a statement resource containing a result set.
o $column
- Specifies the column in the result set. This can either be an integer representing the 0-indexed position of the column, or a
string containing the name of the column.
RETURN VALUES
Returns an integer containing the 0-indexed position of the named column in the result set. If the specified column does not exist in the
result set, db2_field_num(3) returns FALSE.
SEE ALSO db2_field_display_size(3), db2_field_name(3), db2_field_precision(3), db2_field_scale(3), db2_field_type(3), db2_field_width(3).
PHP Documentation Group DB2_FIELD_NUM(3)