Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: searching for filenames with search strings in another file
Top Forums Shell Programming and Scripting searching for filenames with search strings in another file Post 74138 by pathanjalireddy on Wednesday 8th of June 2005 04:47:43 AM
Old 06-08-2005
CPU & Memory searching for filenames with search strings in another file
Hi,

I have 5 files in a directory.

emp1_usage.txt
emp2_usage.txt
emp3_usage.txt
emp4_usage.txt
emp5_usage.txt

I am using sqlldr to get the contents of the above 5 files and store it in a temp table and update my original table using temp table.

for f in *emp*.txt
do
sqlldr usr/passwd control=data.ctl data=$f
done


Now, the problem i got is:

I have a table called 'emdc' in which one column has the values:

emp_name
------------
emp1
emp2
emp3

I should dynamically check what are the values in the emdc table and pass to the sqlldr those file-names which have the values in the emdc table.

Let me explain Clearly:

I should now process only emp1_usage.txt, emp2_usage.txt, emp3_usage.txt into the sqlloader.

The script should automatically check for the values in emdc table and process only the 3 files among the 5 files present in the directory.

Please send me the snippet of the code.

Thanks in advance...........
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Searching filenames containing certain text???

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

Searching a file with exclusion in the search

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

Searching for specific filenames

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

Searching by date range from filenames

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

Searching for a pattern from filenames stored in a file

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

Grep and replace multiple strings in a file with multiple filenames in a file

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

Searching for a list of strings in a file with Python

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

Searching same filenames in different partitions

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

Searching the content of one file using the search key of another file

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

Read in search strings from text file, search for string in second text file and output to CSV

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 DEBIAN

xclip-copyfile

XCLIP-COPYFILE(1)					      General Commands Manual						 XCLIP-COPYFILE(1)

NAME

       xclip-copyfile, xclip-cutfile, xclip-pastefile - copy and move files via the X clipboard

SYNOPSIS

       xclip-copyfile [-p] FILES...

       xclip-cutfile [-p] FILES...

       xclip-pastefile

DESCRIPTION

       xclip-copyfile copies files into the X clipboard, recursing into directories.

       xclip-cutfile copies the files, but also deletes them afterwards.

       -p     preserve path formation

       xclip-pastefile pastes the files out of the clipboard

EXAMPLES

       Copying a file to a remote host

       [maggie.lkpg.cendio.se ~]$ echo "A file created on ${HOSTNAME}" > file1
       [maggie.lkpg.cendio.se ~]$ xclip-copyfile file1
       [sofie.homeip.net ~/doc]$ xclip-pastefile
       file1
       [sofie.homeip.net ~/doc]$ cat file1
       A file created on maggie.lkpg.cendio.se

       Copying an entire tree structure

       [sofie.homeip.net ~]$ xclip-copyfile doc
       [maggie.lkpg.cendio.se ~/tmp]$ xclip-pastefile
       doc/
       doc/letter-mom-april.txt
       doc/file1
       doc/letter-dad-march.txt

       Copying files with preserved path information

       [maggie.lkpg.cendio.se ~]$ xclip-copyfile -p /etc/sysconfig/grub
       tar: Removing leading `/' from member names
       [sofie.homeip.net ~/tmp]$ xclip-pastefile
       etc/sysconfig/grub
       [sofie.homeip.net ~/tmp]$ ls etc/sysconfig/grub
       etc/sysconfig/grub

       Moving files

       [sofie.homeip.net ~]$ ls letter-brother-may.txt
       letter-brother-may.txt
       [sofie.homeip.net ~]$ xclip-cutfile letter-brother-may.txt
       [sofie.homeip.net ~]$ ls letter-brother-may.txt
       ls: cannot access letter-brother-may.txt: No such file or directory
       [sofie.homeip.net ~]$ cd doc
       [sofie.homeip.net ~/doc]$ xclip-pastefile
       letter-brother-may.txt

AUTHORS

       This  manual  page  was written by Maximilian Gass <mxey@cloudconnected.org> for the Debian project. It may be used for everything else, of
       course.

																 XCLIP-COPYFILE(1)
All times are GMT -4. The time now is 11:40 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy