I am trying to replace a certain value from one place in a file . In the below file at position 35 I will have 8 I need to modify all 8 in that position to 7
I tried
Code:
awk '{gsub("8","7",$35)}1' infile > outfile ----> not working
sed -i 's/8/7'g' infile --- it is replacing all the values to 7 in the file.
infile:
020000492019010369200000000000000080009999005566005852006266004961000000000000000000000000
020000492019010369200012000809990080000021005566005852006266004961004100004615004490003951
020000492019010369200021131506450080000095005566005852006266004961004301006451006763006043
020000492019010369200033383653250080000121005566005852006266004961009473007622008426007768
020000492019010369200078000082160080000021005566005852006266004961004100004615004490003951
020000492019010369200078742014720080000021005566005852006266004961004100004615004490003951
020000492019010369200078742082950080000099005566005852006266004961002196002760003833002774
020000492019010369200078742104180080000099005566005852006266004961002196002760003833002774
Expected output:
020000492019010369200000000000000070009999005566005852006266004961000000000000000000000000
020000492019010369200012000809990070000021005566005852006266004961004100004615004490003951
020000492019010369200021131506450070000095005566005852006266004961004301006451006763006043
020000492019010369200033383653250070000121005566005852006266004961009473007622008426007768
020000492019010369200078000082160070000021005566005852006266004961004100004615004490003951
020000492019010369200078742014720070000021005566005852006266004961004100004615004490003951
020000492019010369200078742082950070000099005566005852006266004961002196002760003833002774
020000492019010369200078742104180070000099005566005852006266004961002196002760003833002774
Also on a follow up if I want to replace 008 to 009 . 008 is on the same column 33-35. What should I do
Last edited by arunkumar_mca; 02-20-2019 at 11:18 PM..
Hi All,
I have a file which has data in following format:
"Body_Model","2/1/2007","2/1/2007"
"CSCH74","0","61"
"CSCS74","0","647"
"CSCX74","0","3"
"CSYH74","0","299"
"CSYS74","0","2514"
"CSYX74","0","3"
"Body_Model","3/1/2007","3/1/2007"
"CSCH74","0","88"
"CSCS74","0","489"... (3 Replies)
I have the below file ...where some of the column values should replaced with desired values ....below file u can find that 3 column where ever 'AAA' comes should replaced with ' CC '
NOTE : we have to pass the column number ,AAA,CC (modified value) as the parameters to the code.
... (6 Replies)
Can someone tell me how to change the first column in a very large 17k line file from a random 10 digit numeric value to a non numeric value. The format of lines in the file is:
1702938475,SNU022,201004
the first 10 numbers always begin with 170 (6 Replies)
Hello,
I have a file with four columns and I would like to replace values in the second column only.
An arbitrary example is:
100 A 105 B
200 B 205 C
300 C 305 D
400 D 405 E
500 E 505 F
I need to replace the second column as shown below:
... (4 Replies)
Dear all,
I have a file1.pdb in pdb format and a dat file2 containing values, corresponding to the atoms in the pdb file. these values (file2.dat) need to be in the column instead of the 0.00 (file1) values for each atom in file1.pdb .(the red values must be replaced by the blue ones,in order)... (11 Replies)
How could i take an input file and split the numeric values from the alpha values (123 vs abc) to distinc columns, and if the source is blank to keep it blank (null) in both of the new columns:
So if the source file had a column like:
Value:
|1 |
|2.3|
| |
|No|
I would... (7 Replies)
I have one file as it has the following format
File1
S No Site IP Address
1 Australia 192.168.0.1/26
2 Australia 192.168.0.2/26
3 Australia 192.168.0.3/26
I need awk/sed command to replace the column2 value ( under Site) with some other... (8 Replies)
From googling and reading man pages I figured out this sorts the first column by numeric values.
sort -g -k 1,1
Why does the -n option not work? The man pages were a bit confusing.
And what if I want to sort the second column numerically? I haven't been able to figure that out. The file... (7 Replies)
Discussion started by: cokedude
7 Replies
LEARN ABOUT PHP
db2_field_type
DB2_FIELD_TYPE(3) 1 DB2_FIELD_TYPE(3)db2_field_type - Returns the data type of the indicated column in a result setSYNOPSIS
string db2_field_type (resource $stmt, mixed $column)
DESCRIPTION
Returns the data type of the indicated 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 a string containing the defined data type of the specified column. If the specified column does not exist in the result set,
db2_field_type(3) returns FALSE.
SEE ALSO db2_field_display_size(3), db2_field_name(3), db2_field_num(3), db2_field_precision(3), db2_field_scale(3), db2_field_width(3).
PHP Documentation Group DB2_FIELD_TYPE(3)