I need to replace a value in a particular column with a substitution variable(date value) and modified value of the current column value in the same position.
i need to insert date value(whiic is obtained from another record and stored in a variable $dt=20110702) at 6th column(123456) and also modify the current value as 123XXX789.
i need to modify my below code with AWK so that i can substitute the date value (which is stored in a variable $dt) in the 6th column
The file is a huge file and i do not want to open the file and change each line while i need to do some tweeking in the existing code to incorporate this change.Any help is greatly appreciated.
Last edited by vbe; 07-11-2011 at 12:18 PM..
Reason: code tags please
Hi all
I have a script as follows :-
#!/usr/bin/ksh
IDT=`date +"%OH%M%S"`
while true
do
echo ${IDT}
sleep 1
done
I need the time to show me the current runtime value for the time, however this returns the time as at the start of the script.
Any ideas.
Thanks
JH (4 Replies)
Hi,
I have a program in which i have to substitute a TAG in a file with the value of a variable.
Code Snippet:
----------------
myvar=1234
sed 's/_TAG_/$myvar/' infile outfile
When I run this command, the _TAG_ in the "infile" is substituted with "$myvar" but NOT the value "1234"... (1 Reply)
Hi all u brilient people on the forum...
I am trying to call the variable value in awk command for search pattern /start/,/stop/ but i am nt able to do this ....
wat i did is ..i have created two variable YESTERDAY and TODAY and passed the y'day n 2'days dates in it...like this
... (14 Replies)
Hello, wondering if anybody may be help me. This is the output of a file, from which I need to display a number of fields regarding which users are using licences for two applications we run. Lines which end with "(linger: 1800)" denote licence use for one application and lines which don't contain... (8 Replies)
Hello Exprets,
I have a requirement where i have to subtitue a word with another word.
$eachline| sed 's/*$//'
a) $eachline will hold a value a path
for example
user/oracle/Test_admin/myfolder/bakup/part_bkptemp_part_bkp_repeated/list.txt
b)
$eachline| sed 's/*$//'
will give me the... (3 Replies)
Hi all,
Hope someone can help me out here.
I have this BASH script (see below)
My problem lies with the variable path.
The output of the command find will give me several fields. The 9th field is the path. I want to captured that and the I want to filter this to a specific level.
The... (6 Replies)
Hi All,
OS HPUX 11.11
I am using following script to take controlfile backup. I have used SID variable to hold "ffin1" value, which I again subsitute in "'/db/ffin1/home/oraffin1/$SID_$wdate.ctl'" command. Well, after running this, SID variable does not subsittue it's value, while wdate... (6 Replies)
Hi guys,
I'm trying to figure out how to use a shell variable inside my sed command.
I just want to remove a certain part of a path. I've tried three different combinations and none of them work. Here are the three combinations:
echo $file | sed 's/'$test'//'
echo $file | sed "s/$test//"... (7 Replies)
Hey guys,
I know that title is a mouthful - I'll try to better explain my struggles a little better...
What I'm trying to do is:
1. Query a db and output to a file, a list of column data.
2. Then, for each line in this file, repeat these values but wrap them with:
ITEM{
... (3 Replies)
I am using script for substitute one variable with another variable like below...
below code works fine...
sed 's/'$sub_fun'/'$To_sub'/g'
But when i run the same code from the script getting below errors..
sed: -e expression #1, char 7: unterminated `s' command
please help....... (2 Replies)
Discussion started by: pamu
2 Replies
LEARN ABOUT PHP
db2_field_scale
DB2_FIELD_SCALE(3) 1 DB2_FIELD_SCALE(3)db2_field_scale - Returns the scale of the indicated column in a result setSYNOPSIS
int db2_field_scale (resource $stmt, mixed $column)
DESCRIPTION
Returns the scale 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 an integer containing the scale of the specified column. If the specified column does not exist in the result set,
db2_field_scale(3) returns FALSE.
SEE ALSO db2_field_display_size(3), db2_field_name(3), db2_field_num(3), db2_field_precision(3), db2_field_type(3), db2_field_width(3).
PHP Documentation Group DB2_FIELD_SCALE(3)