02-28-2007
Sed
Hi I have a problem with a sed script to change oracle sqlldr ctl files
I need to change a decode statement which works if there is only on occourance in a file if there are more it only chages the last one. how do I process all and the write the file out
------------------------------------------------
set -vx
CTL=`grep to_date *.ctl | grep decode | cut -f1 -d':'`
echo $CTL
for i in $CTL
do
COL=`grep to_date $i | grep decode | awk '{print $1}' | cut -f1 -d":"`
echo $COL
for n in $COL
do
FROM="decode(substr(:$n,2,1),' ',null,to_date(:"$n", 'dd/mm/yyyy')"
TO="to_date(decode(substr(:$n,2,1),' ',null,:$n),'dd/mm/rrrr')"
sed 's!'"$FROM"'!'"$TO"'!' $i > $i.out
done
done
------------------------------------------------------------
data.ctl
---------------options (errors=99)
load data
infile 'DATA.TXT'
append
into table TEST
fields terminated by ','
(
FSTCLN_DOB "decode(substr(:FSTCLN_DOB,2,1),' ',null,to_date(:FSTCLN_DOB, 'dd/mm/yyyy'))",
FSTCLN_BOB "decode(substr(:FSTCLN_BOB,2,1),' ',null,to_date(:FSTCLN_BOB, 'dd/mm/yyyy'))",
)
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Write a sed script to extract the year, rank, and stock for the most recent 10 years available in the file top10_mktval.csv, and output in the following format:
------------------------------
YEAR |RANK| STOCK
------------------------------
2007 | 1 | Exxon... (1 Reply)
Discussion started by: beibeiatNY
1 Replies
2. Shell Programming and Scripting
Execution of the following segment is giving the error -
Script extract:-
OUT=$DATADIR/sol_rsult_orphn.bcp
TMP1=${OUT}_tmp1
TMP=${OUT}_tmp
( isql -w 400 $dbConnect_OPR <<EOF
select convert(char(10), s.lead_id)
+'|'
+ s.pho_loc_type,
";",
s.sol_rsult_cmnt,
";",
+'|'+ s.del_ind... (3 Replies)
Discussion started by: kzmatam
3 Replies
3. Shell Programming and Scripting
Hello and thx for reading this
I'm using sed to remove only the leading spaces in a file
bash-280R# cat foofile
some text
some text
some text
some text
some text
bash-280R#
bash-280R# sed 's/^ *//' foofile > foofile.use
bash-280R# cat foofile.use
some text
some text
some text... (6 Replies)
Discussion started by: laser
6 Replies
4. Shell Programming and Scripting
i made a script to update a lot of xml files. to save me some time. Ran it and it replaced all the the files with a 0kb file. The problem i was having is that I am using sed to change xml node <doc_root>. The problem with this is it has a / in the closing xml tag and the stuff inside will also have... (4 Replies)
Discussion started by: timgolding
4 Replies
5. Shell Programming and Scripting
Hi all,
First off, Thank you all for the knowledge I have gleaned from this site!
Deleting Records from a text file... sed paragraphs
The following code works nearly perfect, however each time it is run on the log file it adds a newline at the head of the file, run it 5 times, it'll have 5... (1 Reply)
Discussion started by: Festus Hagen
1 Replies
6. UNIX for Dummies Questions & Answers
I'm not sure if the problem I'm seeing is an artifact of sed or simply a beginner's mistake. Here's the problem: I want to add a zero-width space following each underscore between XML tags. For example, if I had the following xml:
<MY_BIG_TAG>This_is_a_test</MY_BIG_TAG>
It should look like... (8 Replies)
Discussion started by: rhetoric101
8 Replies
7. Shell Programming and Scripting
How do i replace a string using sed into the same file without creating a intermediate file? (7 Replies)
Discussion started by: gomes1333
7 Replies
8. Shell Programming and Scripting
My need is :
Want to change
docBase="/something/something/something"
to
docBase="/only/this/path/for/all/files"
I have some (about 250 files)xml files.
In FileOne it contains
<Context path="/PPP" displayName="PPP" docBase="/home/me/documents" reloadable="true" crossContext="true">... (1 Reply)
Discussion started by: linuxadmin
1 Replies
9. Shell Programming and Scripting
Hi,
I am running a script sample.sh in bash environment .In the script i am using sed and awk commands which when executed individually from terminal they are getting executed normally but when i give these sed and awk commands in the script it is giving the below errors :-
./sample.sh: line... (12 Replies)
Discussion started by: satishmallidi
12 Replies
10. Shell Programming and Scripting
I am learning SED and just following the shell scripting book, i have trouble understanding the grep and sed statement,
Question : 1
__________
/opt/oracle/work/antony>cat teledir.txt
jai sharma 25853670
chanchal singhvi 9831545629
anil aggarwal 9830263298
shyam saksena 23217847
lalit... (7 Replies)
Discussion started by: Antony Ankrose
7 Replies
LEARN ABOUT CENTOS
edac-ctl
EDAC-CTL(8) EDAC admin utility EDAC-CTL(8)
NAME
edac-ctl - EDAC admin utility
SYNOPSIS
edac-ctl [OPTION]...
DESCRIPTION
The edac-ctl program is a perl(1) script which performs some useful administration tasks for EDAC (Error Detection and Correction) drivers.
OPTIONS
--help Display a brief usage message.
--mainboard
Print mainboard vendor and model for this hardware, if available. This option requires that the dmidecode(8) utility be installed,
and must be run as root.
--status
Print the status of EDAC drivers (loaded or unloaded).
--register-labels
Register motherboard DIMM labels into EDAC driver sysfs files. This option uses the detected mainboard manufacturer and model num-
ber in combination with a "labels database" found in any of the files under /etc/edac/labels.d/* or in the labels.db file at
/etc/edac/labels.db. An entry for the current hardware must exist in the labels database for this option to do anything.
--print-labels
Display the configured labels for the current hardware, as well as the current labels registered with EDAC.
--labeldb=DB
Specify an alternate location for the labels database.
SEE ALSO
edac(3), edac-util(1)
edac-utils-0.16-1 2009-01-30 EDAC-CTL(8)