11-15-2009
Thanks buddy
![Smilie Smilie](https://www.unix.com/images/smilies/smile.gif)
one more thing. How can i add a new line before the third line (Which is PRESERVE BLANKS) so the new file will look like this
LOAD DATA
INFILE '/home/scott/XXX.dat'
<New Line>
PRESERVE BLANKS
.............
.............
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I'm a newbi in shell script. Here what I want to do:
FileA:
bor bor bor
xxxx
bib bib bi
FileB:
something something
something
I want to replace string "xxxx" in FileA with contents of FileB.
i tried with sed:
fileb=`cat FileB`
reg=xxxx
file=FileA (4 Replies)
Discussion started by: afatguy
4 Replies
2. Shell Programming and Scripting
Hi,
I want to replace _F* by _F in a xml file. what is the sed command.
I have tried sed "s/_F$/_F/g" or sed "s/_F*/_F/g" , but it does not work. thx
file content
<TAG>KC_FOU</TAG>
<TAG>KC_FABC</TAG>
<TAG>KC_FABCDG</TAG>
desire output
<TAG>KC_F</TAG>
<TAG>KC_F</TAG>
<TAG>KC_F</TAG> (6 Replies)
Discussion started by: godfreyyip
6 Replies
3. Shell Programming and Scripting
Our system is receiving one feed from the third party.
One of the field in the flat file is ID which id from position 19 to 27. In some cases this ID is coming as 9 zeros (000000000) or 1 right padded zero. ( 0)
For these specific records I want to replace fthis field with blank... (3 Replies)
Discussion started by: varunrbs
3 Replies
4. Shell Programming and Scripting
Hi,
My requirement is to find a text and replace it with another in a XML file.
I am new to Unix,Please provide some suggestion to achieve.
Find:
<Style ss:ID="ColumnHeader1">
Replace with:
<Style ss:ID="ColumnHeader1">
<Borders>
<Border ss:Position="Bottom"... (4 Replies)
Discussion started by: cnraja
4 Replies
5. Shell Programming and Scripting
Hello,
I need to do one thing that my script creates the file
touch release.SPLASH_12_03_00_RC01.txt
Now I want to update that file with some content e.g
splashbuild::SPLASH_12_17_00_RC02.zip
Thanks (1 Reply)
Discussion started by: anuragpgtgerman
1 Replies
6. Shell Programming and Scripting
I have a file myfile with only one value 1000.I am using it in a shell script.Each time i run the script,the file shud get incremented by 1. I have used the below code for incrementing the value-
curr=`cat myfile`
echo $curr
curr=`expr $curr + 1`
But i am not sure how to save this replaced... (2 Replies)
Discussion started by: saga20
2 Replies
7. Shell Programming and Scripting
Hi,
I am having trouble while using 'sed' with reading files. Please help. I have 3 files. File A, file B and file C. I want to find content of file B in file A and replace it by content in file C.
Thanks a lot!!
Here is a sample of my question.
e.g. (file A: a.txt; file B: b.txt; file... (3 Replies)
Discussion started by: dirkaulo
3 Replies
8. Shell Programming and Scripting
Hi,
I am having a files in my directory like this:
2014 1049_file1.txt
2014 1050_file2.txt
2014 1110_file3.txt
2014 1145_file4.txt
2014 2049_file5.txt
I need to replace the above file names like this without changing the content of filename:
file1.txt
file2.txt
file3.txt... (10 Replies)
Discussion started by: rohit_shinez
10 Replies
9. Shell Programming and Scripting
Hi everybody!
i have a lot of files where i filter out data.
#!/bin/bash
f=sample_*.Spe
for i in $f `eval echo ls sample_*.Spe`
do
if test -f "$i"
then
awk 'FNR==8 ||FNR==10 || (FNR>=13 && FNR<=268) {print $1}' $i > test$i.txt
paste test$i.txt test_f.txt > test_f.txt
... (5 Replies)
Discussion started by: IMPe
5 Replies
10. Shell Programming and Scripting
Hi,
Right now there is a file called 'qm.ini' which is owned by mqm:mqm and I am trying to replace a line from this file with something else and save.
I am using the below perl command to replace and save within a shell script with a different user called 'mqadm' which is also part of mqm... (1 Reply)
Discussion started by: bdpl
1 Replies
LOAD(7) SQL Commands LOAD(7)
NAME
LOAD - load a shared library file
SYNOPSIS
LOAD 'filename'
DESCRIPTION
This command loads a shared library file into the PostgreSQL server's address space. If the file has been loaded already, the command does
nothing. Shared library files that contain C functions are automatically loaded whenever one of their functions is called. Therefore, an
explicit LOAD is usually only needed to load a library that modifies the server's behavior through ``hooks'' rather than providing a set of
functions.
The file name is specified in the same way as for shared library names in CREATE FUNCTION [create_function(7)]; in particular, one can rely
on a search path and automatic addition of the system's standard shared library file name extension. See in the documentation for more
information on this topic.
Non-superusers can only apply LOAD to library files located in $libdir/plugins/ -- the specified filename must begin with exactly that
string. (It is the database administrator's responsibility to ensure that only ``safe'' libraries are installed there.)
COMPATIBILITY
LOAD is a PostgreSQL extension.
SEE ALSO
CREATE FUNCTION [create_function(7)]
SQL - Language Statements 2010-05-14 LOAD(7)