Passing parameter from one file to shell script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Passing parameter from one file to shell script
# 1  
Old 10-29-2008
Passing parameter from one file to shell script

Hi All,

I have a 2 files. File1 i am generating using an ETL tool, which is a comman seperated delimited file which contains country code & load date.
everytime, this country code will be updated from a table. It might be AB or BA & ld_date will be for which date we need to load the file.

In file2.sh script which is doing feed validation test for the feed file, i need to pass this country code & load date.

File1
====
COUNTRYCODE,LD_DATE
AB,20081210

File2.sh
======
echo $1 $2

Can someone tell me if it is possible to pass in this manner. Because i need to call File2.sh thru ETL tool. so i cannot manually change the parameter daily. I need to pass this parameter dynamically for each run.
# 2  
Old 10-29-2008
Hammer & Screwdriver It appears to make sense

Take a look at the following. I inserted the "2*" into the script just to verify/show what was doing the echo.

> cat file1
COUNTRYCODE,LD_DATE
AB,20081210

> cat file2.sh
echo "2*" $1 $2

> while read var1 var2; do file2.sh $var1 $var2; done <file1
2* COUNTRYCODE,LD_DATE
2* AB,20081210
# 3  
Old 10-29-2008
Hi joeyg,

Thanks for your input.

But what i want is... it must be like...

./file2.sh AB 20081210

while executing above code, i am not getting what i wanted.

Thank for ur help
# 4  
Old 10-29-2008
Question

What are you getting for output?
It looks like it should be fine.

Last edited by joeyg; 10-29-2008 at 09:01 AM.. Reason: corrected spelling
# 5  
Old 10-29-2008
Hi Joeyg,

I found the answer.

file1
====
COUNTRYCODE,LD_DATE
AB,20081210

file2.sh
======
#!/bin/sh
var1=`sed '1d' File1 | cut -d, -f1`
var2=`sed '1d' File1 | cut -d, -f1`

echo $var1
echo $var2
# 6  
Old 10-29-2008
Hammer & Screwdriver

OK, I see what you are doing... eliminating the header row with the sed command.
Although I think your var2 should be a cut with an f2 -- you want the second entry on that line. Right?
# 7  
Old 10-29-2008
yes, u r right sorry for typo.....
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Passing parameter with single quote to shell script

Hello All, I am trying below +++++++++ #/bin/bash set -x Host=$1 Port=$2 User=$3 Pass=$4 Warning=$5 Critical=$6 SCRIPT_LOC=/opt/agent/ Parameters="'""hostname=$Host&""port=$Port&""username=$User&""password=$Pass&""jvm=UsedMemory,$Warning,$Critical""'" echo $Parameters... (10 Replies)
Discussion started by: sundari127
10 Replies

2. UNIX for Dummies Questions & Answers

Passing shell script parameter value to awk command in side the script

I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist. diff=$1$2.diff id=$2 new=new_$diff echo "My id is $1" echo "I want to sync for user account $id" ##awk command I am using is as below cat $diff |... (1 Reply)
Discussion started by: Sarita Behera
1 Replies

3. Shell Programming and Scripting

Passing a parameter from a shell script to sqlplus

Hi All, I'm new to Linux and scripting, apologies in advance for 'stupid' questions. Please help... Im writing a script that calls a sqlplus script but the sqlplus requires inputs and i cant seem to get this to work. here is my code. #!/bin/sh TERM=vt100 export TERM... (4 Replies)
Discussion started by: Mahomed
4 Replies

4. Shell Programming and Scripting

Passing parameter to script, and split the parameter

i am passing input parameter 'one_two' to the script , the script output should display the result as below one_1two one_2two one_3two if then echo " Usage : <$0> <DATABASE> " exit 0 else for DB in 1 2 3 do DBname=`$DATABASE | awk -F "_" '{print $1_${DB}_$2}` done fi (5 Replies)
Discussion started by: only4satish
5 Replies

5. Shell Programming and Scripting

Passing string as a input parameter for a shell script

Hi i have a shell script which needs a string as an input parameter. How to pass the string param as an input? In command line am running the script. for e.g., a="who is a buddy?" sh sample.sh $a Inside the script i get this input param as $1 but only the value "who" is accepted... (12 Replies)
Discussion started by: vidhyaS
12 Replies

6. Shell Programming and Scripting

Passing Parameter containing space in between to Shell Script

Hi, I have one shell script which use two parameter however one of its parameter have space in between. eg. a.sh 20110114 b c d here b c d is one parameter I used 'b c d' but its not giving correct result. Also i tried b\c\d but this one also didnt work. Any help would be... (5 Replies)
Discussion started by: diehard
5 Replies

7. SCO

Parameter passing to dot shell script

OS SCO Open Server 6.0 MP4 I am trying to change the value of a enviornment variable thru a script and want to pass a parameter on the commande line, If I hard code the value inside the script the script changes the enviornment variable . mytest where my test is MYVAR=$1 export MYVAR... (6 Replies)
Discussion started by: atish0
6 Replies

8. AIX

Passing a parameter to a shell script?

I would like to run a compress script on files in certain directories. My compress_script.sh is just basically compress file* In order for me to use this I have to copy it into each directory and run it. How can I state the directory on the command line with the compress script so it... (2 Replies)
Discussion started by: NycUnxer
2 Replies

9. Shell Programming and Scripting

passing parameter 4m shell script to a DB stored procedure

hi all please tell me how to pass parameters 4m shell script to a DataBase stored procedure. To be specific i have sybase DB. i mean i want the syntax of the command.. how to connect to DB, pass user id and password, pass the required parameter to SP.. .. need ur help frnds.. hema (0 Replies)
Discussion started by: hema2026
0 Replies

10. Shell Programming and Scripting

passing parameter from Shell-script to Sql-script

Dear Friends, Please help me to achieve the following: I want to pass one parameter from Shell-script to Sql-script. Example: My ShellScript.sh is calling report.sql like this: /bin/sqlplus /reports.sql And My report.sql is calling many Stored-Procedures like this: exec... (0 Replies)
Discussion started by: subodhbansal
0 Replies
Login or Register to Ask a Question