Search Results

nawk 'FNR > 3 {printf("%s%c", $0, OFS)}END{print ""}' "$1" > "$1".out && mv "$1
".out "$1"

what is FNR? or printf("%s%c",$0, OFS)}?

sorry..im lost...

thanks alot kduffin :)

thanks alot for the link! :)

thanks for your great help..erm can you explain to me the coding?? so that i can use that for further extraction of other xml files....

hi.. i got this error when i try this code..
awk: syntax error near line 1
awk: bailing out near line 1

Sorry to trouble you guys again.....but i encounter this problem:
My textfile contains this:
2006-01-12 01:12:08,290 [ExecuteThread: '1' for queue: 'default'] INFO - The XML message...

thanks very much !

well i have this file here:

<XML>
<pregate xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<system_c>HPREGATE</system_c>
<trans_c>HSPG</trans_c>
...

thanks for the codes :)

sorry for the trouble......
i have this file that contains the following:
00:00:21 Queue key, Queue Name=[GMS_Q,jms/citos/gms/HssQueue]
00:00:21 Sending Message :<EXGC-EXGU...

Oh yes! finally....thanks for your wonderous help......u are genius..

oh its related.. i get the outputrecord.txt from the command u give earlier...
i used the sed coding you give which is
sed -n -e '/<record /{N;s_.*\(<record .*<\/record>\)_\1_p;}' in.txt
and i...

ok..the file extracted is called outputrecord.txt and it contain this
2005-12-05 10:53:34,663 [ExecuteThread: '0' for queue: 'default'] INFO - etb is null
<record...

thanks for the coding......
however the output still contains a line that i need to delete..any idea?
<record...

linuxpenguin..i tried your code...but it doesnt work too..

i got this problem :[/tmp]$: not found

thanks vino :)

thanks vino for your help :)

sorry to trouble u guys again...
i have this document here called record.txt and it contains this:
2005-12-05 10:53:17,551 [ExecuteThread: '0' for queue: 'default'] INFO - message received......

thanks :) however i need to put this in a script so i try to write this down:

`sed -e 's_^.\{,2\}:.\{,2\}:.\{,2\} .*<pregate_<pregate_g' p.txt > sample.modified`

however i get this msg :
sed:...

I have this xml file which is call p.txt and it contains the follwing:
16:13:56 Msg send to Queue=[<pregate xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<system_c>HPREGATE</system_c>...

hi ygor :P yes im using oracle..thanks for you effort in helping me with this scripts..you totally understand my problem..thanks...

ok..thanks...i get it..thanks so much for great help....... :) :) :) :) :) :) :)

thanks...it works now...i get this...
SQL*Loader: Release 9.2.0.5.0 - Production on Thu Dec 15 10:59:41 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Commit point...

hi..mona..i changed it to ...control=test.cfg data=$1 ...... this in my load.script...and i get this error....
syntax error at 'data' following '='
Syntax error on command-line