I have a file with occurances of the string "TO_DATE(<number here>,'J')" at random places. I need minus 2400000 from the number and replace the string with "convert(date, dateadd(dd, <new number here>,'16 Nov 1858')".
I'm finding this difficult as the string isn't necessarily in the same places all the time and I'm not sure how to go about taking the number out and performing a calculation on it
Some examples of the original file are:
So in the first example I need to take the 2446160 out and minus 2400000 from it, then replace the whole "TO_DATE(...)" with "convert(date, dateadd(dd, <new number here>,'16 Nov 1858')"
I've been looking at using sed and maybe even grep and cut but I'm stumped.
Last edited by Franklin52; 12-08-2010 at 09:43 AM..
Reason: Please use code tags, thank you
Corrected in earlier post [add if condition]. That should give right result now.
Not much familierity with nawk yet. Others may tell if anything better is there.
Hi,
I need someone's help in writing correct perl code.
I implemented following code for "multiple search strings replaced with single string".
=========================================================
#!/usr/bin/perl
my $searchStr = 'register_inst\.write_t\(' |... (2 Replies)
My task is to copy all files from many directories in one. The big problem i encounter is that some files in different directory have the same names. Is they are way to copy the files that have same names in a sub directory ( need to preserve the name of the files unchanged )
I have list with... (6 Replies)
Hi,
I am trying to generate list of employees from emp table who joined yesterday.
emp.sh
YEST=$(date --date='1 day ago' +%Y-%m-%d)
cat emp.sql | mysql -u <user> -p<pass> -h <host> -P <port> -D <dbname> > emp.csv
emp.sql
select * from employee where join_date = '$YEST';
I expected... (3 Replies)
Hi experts,
As i am a novice unix player...so need help for the below query...banged my head from quite a while...:confused:
i have a set of html files, in which i need to search for string "Page"(case sensitive) and then replace the same with some numeric code ,say, "XXX1234".
Here in... (2 Replies)
Source data:
"123","aaa bbb CCC","12000"
"134","HHH,bbc","13000"
i have a delimited file. i want to replace with the pipe.The sed command is not working for replacing a delimeter.
Command :
sed s/\,/\|/g filename
Output : When i run the command it is replacing the columns value... (7 Replies)
I have a log file that display the serial output coming from different places. Sometime the string in search gets clobbered with the other strings and consequently change form. For example:
serial ouput:
--------------
hello world!
done with network
configuring asic registers
comJan 1... (2 Replies)
Hi All,
To avoid race condition, instead of using mutex, semaphore, spinlock etc.... Is there any other mechanism by which we can avoid race condition in an multi-threading environment.
-Thanks (6 Replies)
hello, I must've screwed something here..
I just had hdisk0 replaced by IBM.. now it shows up as hdisk2 instead.
Before doing that, I've had it split from hdisk1, and reduced from rootvg.
Just did a rmdev -dl hdisk2.. ran cfgmgr, but still shows up as hdisk2 instead of hdisk0.. help! (2 Replies)
I've searched the forum and google, but can't see an answer to this simple problem. Here's my small test script:
#!/bin/csh
echo "enter a number:"
read num
echo "you entered $num"
set num = `expr $num + 1`
echo new value is $num
can someone show me how to do this calculation? note that... (4 Replies)