Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Shell script to find specific file name and load data
Top Forums Shell Programming and Scripting Shell script to find specific file name and load data Post 302496909 by Chubler_XL on Tuesday 15th of February 2011 05:06:44 PM
Old 02-15-2011
If you have bash shell you could try something like this:

Code:
#!/bin/bash
FOLDER=./folder
TABLEA="File1|File2|File3"
TABLEB="File 4|File5|File6"
cd $FOLDER
shopt -s extglob
for file in *
do
    case $file in
       @($TABLEA))
           echo "Load $file into table A"
           # Process file here
       ;;  
       @($TABLEB))
           echo "Load $file into table B"
           # Process file here
       ;;  
    esac
done


eg:
Code:
$ ls folder
File 4  File1  File6

$ ./doload.sh
Load File 4 into table B
Load File1 into table A
Load File6 into table B

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script to Load data into the database using a .csv file and .ctl file

Since i'm new to scripting i'm findind it difficult to code a script. The script has to be an executable with 2 paramters passed to it.The Parameters are 1. The Control file name(.ctl file) 2. The Data file name(.csv file) Does anybody have an idea about it? :confused: (3 Replies)
Discussion started by: Csmani
3 Replies

2. Shell Programming and Scripting

shell script to read data from text file and to load it into a table in TOAD

Hi....can you guys help me out in this script?? Below is a portion text file and it contains these: GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001 GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001 GEF001 000093625 MKL005675 000001... (1 Reply)
Discussion started by: pallavishetty
1 Replies

3. Web Development

script to load data from csv file

hello i want a script to load the data line by line from a csv file into a mysql table (3 Replies)
Discussion started by: srpa01red
3 Replies

4. Shell Programming and Scripting

Simple shell script to find and print data

Hi, I have a log file containing data on emails sent. Looks a bit like this for one email: Content-Type: text/plain; charset="UTF-8" Date: 12 Jun 2008 14:04:59 +0100 From: from@email.com Subject: xcf4564xzcv To: recip@email.co.uk Size = 364 Jun 12 14:04 smtp_234sldfh.tmp I need to... (5 Replies)
Discussion started by: terry2009
5 Replies

5. Shell Programming and Scripting

C Shell problem: using a key from one file to find data in another

I've never written scripts (just switched from Ada to C++). I have a book that's over my head and a few examples, other then that I'm floundering. Everything here at work is being done in C Shell. None of the C++ programmers are experienced in shell scripting. I have a data file with the... (2 Replies)
Discussion started by: bassmaster
2 Replies

6. Shell Programming and Scripting

Korn/bash Script to monitor a file a check for specific data

Hi, Im trying to write this script but im stuck on it, basicaly what i want to do is to write a code to verify a log file ( apache log file for example ) and for each new line with specific data , then, output this new line for another file: full ex: output of the server.log is (... (4 Replies)
Discussion started by: Thales.Claro
4 Replies

7. Shell Programming and Scripting

Perl script to Archive the data file after the load

I have written a perl scripts which loads the data. Now i want to modify the script, to Archive the Input file after the successful load of data. Can anyone please share it and help me .... Thanks. (2 Replies)
Discussion started by: msrahman
2 Replies

8. Shell Programming and Scripting

why do we need UNIX shell script to load data into Oracle database

Hello everyone, I am new to shell scripting/ loading data into a database. I want to load data into Oracle database using SQL loader. Can some one please explain why do we need unix shell script to load the data into the database? Also can someone please explain what has to be in that script?... (5 Replies)
Discussion started by: new_prog
5 Replies

9. Shell Programming and Scripting

How to read file and load data into a script as variable

I need to read a text file that contain columns of data, i need to read 1st column as a function to call, and others are the data i need to get into a ksh script. I am quite new to ksh scripting, i am not very sure how to read each row line by line and the data in each columns of that line, set... (3 Replies)
Discussion started by: gavin_L
3 Replies

10. Homework & Coursework Questions

Write a shell script for SQL loader to load data into a staging table

Hi, I'm new to Linux. I'm working on a database, and need to load data in a database table (which I already created) using shell script. The table has two columns - Acct_number (not nullable) and date (timestamp). I'm not able to write a shell script for that. Can any one help me? ... (3 Replies)
Discussion started by: saisudeep
3 Replies

LEARN ABOUT DEBIAN

rdf::query::plan::load

RDF::Query::Plan::Load(3pm)				User Contributed Perl Documentation			       RDF::Query::Plan::Load(3pm)

NAME

       RDF::Query::Plan::Load - Executable query plan for LOAD operations.

VERSION

       This document describes RDF::Query::Plan::Load version 2.908.

METHODS

       Beyond the methods documented below, this class inherits methods from the RDF::Query::Plan class.

       "new ( $url, $graph )"
       "execute ( $execution_context )"
       "next"
       "close"
       "url"
	   Returns the URL to load data from.

       "namedgraph"
	   Returns the optional graph name to load the data with.

       "distinct"
	   Returns true if the pattern is guaranteed to return distinct results.

       "ordered"
	   Returns true if the pattern is guaranteed to return ordered results.

       "plan_node_name"
	   Returns the string name of this plan node, suitable for use in serialization.

       "plan_prototype"
	   Returns a list of scalar identifiers for the type of the content (children) nodes of this plan node. See RDF::Query::Plan for a list of
	   the allowable identifiers.

       "plan_node_data"
	   Returns the data for this plan node that corresponds to the values described by the signature returned by "plan_prototype".

       "graph ( $g )"
       "is_update"
	   Returns true if the plan represents an update operation.

AUTHOR

	Gregory Todd Williams <gwilliams@cpan.org>

perl v5.14.2							    2012-01-31					       RDF::Query::Plan::Load(3pm)
All times are GMT -4. The time now is 11:28 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy