06-08-2005
Check this out...
There are somethings which you need to re-write. I will say what those are, at the end.
#! /bin/sh
while read line
do
emdc_value=${emdc_value}" "`echo $line | awk -F"[ ]*" '{ printf $1 }'`
done < emdc.table
for f in $emdc
do
sqlldr usr/passwd control=data.ctl data=$f
done
emdc.table contains
emp_name
------------
emp1
emp2
emp3
In the awk part of the script, you will need to modify the argument passed to printf. Right now I am assuming that in line 1, emp1 is the first field; line 2 , emp2 is the first field. Also the other assumption, the delimiters between the different fields of each line is space.
You will need to change those to suit your emdc.table configuration.
Havent tested it. Didnt have an input file.
Post the results if the script breaks somewhere.
Vino
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Suppose there are multiple files containing certain text "abc". How to print the name of all such files with a single command from unix prompt?
Thanks in advance (6 Replies)
Discussion started by: skyineyes
6 Replies
2. UNIX for Dummies Questions & Answers
Hello,
I'm looking for a bit of help. Im trying to search a file for lines that contain white spaces at the end of the lines. This is what I'm using where $param is the path and file name and it redirects the output to a txt file :
echo | grep -n ' $' $param >> $2
Is it possible to have... (8 Replies)
Discussion started by: gintreach
8 Replies
3. UNIX for Dummies Questions & Answers
Hi
I would like to know how to search through a directory and pull out files that has a specific pattern in the filename. For example if the filename has "bsc" in it, then that file must be moved to another directory where I will perform some operations on it. I know grep can be used, but I'm... (17 Replies)
Discussion started by: ladyAnne
17 Replies
4. UNIX for Dummies Questions & Answers
Hello all,
i have tons of files in folder named like this (yyyymmdd):
bookcollection20100729
bookcollection20100730
bookcollection20100731
bookcollection20100801
bookcollection20100802
etc.
I need to find files with date range in there names lets say from 2010.07.30 - 2010.08.02
... (10 Replies)
Discussion started by: Whit3H0rse
10 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I have got some 10 filenames stored in a file or displayed in the console as a result of some query i made.. Now I need to open each of these files and search for a pattern in these 10 files.. Can someone help me with this?
Thanks,
Jean (9 Replies)
Discussion started by: jeanjkj
9 Replies
6. Shell Programming and Scripting
Hi,
I have a file containing list of strings like
i:
Pink
Yellow
Green
and I have file having list of file names in a directory
j :
a
b
c
d
Where j contains of a ,b,c,d are as follows
a:
Pink (3 Replies)
Discussion started by: madabhg
3 Replies
7. Shell Programming and Scripting
Hi guys,
I'm trying to search for several strings, which I have in a .txt file line by line, on another file.
So the idea is, take input.txt and search for each line in that file in another file, let's call it rules.txt.
So far, I've been able to do this, to search for individual strings:
... (1 Reply)
Discussion started by: starriol
1 Replies
8. Shell Programming and Scripting
Hi,
We are doing some migration work. The same files may exist in different partition/mountpoints. We may place it in a single place, hence we don't want any duplicates...we will rename the file names if we know the files which has duplicates(by file name)).
It would be nice if a script... (3 Replies)
Discussion started by: saravanapandi
3 Replies
9. Shell Programming and Scripting
I have two files:
file 1:
hello.com neo.com,japan.com,example.com
news.net xyz.com, telecom.net, highlands.net, software.com
example2.com earth.net, abc.gov.uk
file 2:
neo.com
example.com
abc.gov.uk
file 2 are the search keys to search in file 1 if any of the search key is... (3 Replies)
Discussion started by: csim_mohan
3 Replies
10. Shell Programming and Scripting
Hi guys,
I have a text file named file1.txt that is formatted like this:
001 , ID , 20000
002 , Name , Brandon
003 , Phone_Number , 616-234-1999
004 , SSNumber , 234-23-234
005 , Model , Toyota
007 , Engine ,V8
008 , GPS , OFF
and I have file2.txt formatted like this:
... (2 Replies)
Discussion started by: An0mander
2 Replies
LEARN ABOUT PHP
phardata.extractto
PHARDATA.EXTRACTTO(3) 1 PHARDATA.EXTRACTTO(3)
PharData::extractTo - Extract the contents of a tar/zip archive to a directory
SYNOPSIS
bool PharData::extractTo (string $pathto, [string|array $files], [bool $overwrite = false])
DESCRIPTION
Extract all files within a tar/zip archive to disk. Extracted files and directories preserve permissions as stored in the archive. The
optional parameters allow optional control over which files are extracted, and whether existing files on disk can be overwritten. The sec-
ond parameter files can be either the name of a file or directory to extract, or an array of names of files and directories to extract. By
default, this method will not overwrite existing files, the third parameter can be set to true to enable overwriting of files. This method
is similar to ZipArchive.extractTo(3).
PARAMETERS
o $pathto
- Path to extract the given files to
o $files
- The name of a file or directory to extract, or an array of files/directories to extract
o $overwrite
- Set to TRUE to enable overwriting existing files
RETURN VALUES
returns TRUE on success, but it is better to check for thrown exception, and assume success if none is thrown.
ERRORS
/EXCEPTIONS
Throws PharException if errors occur while flushing changes to disk.
EXAMPLES
Example #1
A PharData.extractTo(3) example
<?php
try {
$phar = new PharData('myphar.tar');
$phar->extractTo('/full/path'); // extract all files
$phar->extractTo('/another/path', 'file.txt'); // extract only file.txt
$phar->extractTo('/this/path',
array('file1.txt', 'file2.txt')); // extract 2 files only
$phar->extractTo('/third/path', null, true); // extract all files, and overwrite
} catch (Exception $e) {
// handle errors
}
?>
SEE ALSO
Phar.extractTo(3).
PHP Documentation Group PHARDATA.EXTRACTTO(3)