Search Results

Much appreciated. Starting to get to grips with all this

If I don't include g will only the first instance be changed?
Essentially I want to change:

INSERT INTO PH1_TX_LOAD VALUES ('TX-78731-AABSS:4182-4','RH: GUIDE TO...

Hello again,

I'm trying to change the following line:


INSERT INTO PH1_TX_LOAD VALUES ('TX-78731-AABSS:4182-4','RH: GUIDE TO TENNIS',TO_DATE('18-JUN-2001:00:00:00',...

Sorry to bring this up again. What does the \1 mean in the substituted string in the following code? :


sed "s/'\([0-9][0-9]*\)'/\1/g"


Also why is it necessary to use two [0-9] for the...

Thanks that does work

It doesn't appear to take out the quotation e.g.:


INSERT INTO PRICE VALUES
('100871',4.8,3.2,TO_DATE(2447528,'J'),TO_DATE(2447862,'J'))
go



still is the same

sed "s/'\([-+]\{0,1\}[0-9][0-9.]*\)'/\1/g" file works but i was wondering why the other sed command gives me the following error:


sed "'s/\'([0-9][0-9]*)\'/$1/g'" newscript2

Unrecognized...

Thanks, I get the error:

syntax error at line 2: `(' unexpected

also can I ask why `sed 's/\'([0-9])*\'/$1/g' input file` would not work?

I have a file with some numbers having single quotes around them which I want to remove.

i.e. '923930' -> 23930

If it can be done without using sed thats fine. I have tried with sed but...

Thats correct. It does actually work, I was just using the wrong input file

Excellent, that works. Thanks anurag

---------- Post updated at 10:54 AM ---------- Previous update was at 10:15 AM ----------

Just a final note on this, the replaced string needs to be...

Thanks, that works for the most part although -2400000 seems to be replaced in strange places and the calculation hasn't been done eg:

INSERT INTO PRICE VALUES -2400000
...

Thanks for the reply.
I'm not sure if awk works on this system, I get the errors:
awk: syntax error near line 1
awk: bailing out near line 1

even awk {print $0} doesn't seem to work

Hi,

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...

Sorry for the late reply. Thanks for all that it really helps and my bash scripting is coming along great now, learning so much everyday its a great feeling. I'm sure I'll be back at some point with...

Thank you very much, that works great now.
One more question, I don't quite understand why this line is used:
echo $owner | grep ${perm} > /dev/null

Why are curly brackets used and why is the...

Ahh I see. I suppose another way would be to use loads of if statements then?

Hi there,

I've been having some frustrating problems with a permissions script. Basically I want it to to determine what permissions the owner, group and everybody has for the file passed in....