Help with shell script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help with shell script
# 1  
Old 10-19-2014
Oracle Help with shell script

Code:
#Check if the argument is numeric
isNumeric()
{
        numericExpression='^[0-9]+$'
        if ! [[ $1 =~ $numericExpression ]]
        then
                echo 1;
        else
                echo 0;
        fi
}

getColumnData()
{
	echo `echo $1|cut -d "," -f1,2 --output-delimiter " "`
}

containsSegment()
{
	if [[ $1 =~ "LSNCS808" ]] || [[ $1 =~ "LSNCS097" ]] || [[ $1 =~ "LSNCS148" ]]
	then
		echo 0;
	else
		echo 1;
	fi
}
FOLDER=.
CURRENT_TIMESTAMP=$(date '+%Y-%m-%d-%H%M%S')
EXTENSION=DAT
SEGMENT_FILE=${FOLDER}/SEGMENT-${CURRENT_TIMESTAMP}.${EXTENSION}
NON_SEGMENT_FILE=${FOLDER}/NONSEGMENT-${CURRENT_TIMESTAMP}.${EXTENSION}

# Assuming the first column in the record is always numeric and it is the header of the record
# any line not following the above pattern will be treated as the data belong to the header record
# Skipping the first line in the file
echo " Processing the file $1..."
sed 1d $1 |while read line
do
	firstCol=(`getColumnData $line`)
	isRecordHeader=`isNumeric ${firstCol[0]}`;
	if [[ $isRecordHeader =~ "0" ]] 
	then
		if [[ `containsSegment ${firstCol[1]}` =~ "0" ]]		
		then
			#The data has to be appended to the segment file
			filetoAppend=$SEGMENT_FILE;
		else
			#the data has to be appended to the non segment file
			filetoAppend=$NON_SEGMENT_FILE;
		fi
		echo $line >>"$filetoAppend"
	else
		echo $line >>"$filetoAppend"
	fi
done 

echo " Finished processing the file $1..."
echo " Generated the following files: $SEGMENT_FILE, $NON_SEGMENT_FILE"


I have the above script with me..
Now the change i am looking for is I need the column names to be added in SEGMENT_FILE and NON SEGMENT_FILE..
I have the below solution but dont know exactly to place the below lines

You need to just create both the files at the beginning of the execution
Code:
touch $SEGMENT_FILE
touch $NON_SEGMENT_FILE

Then append the first line from the csv file

Code:
sed '1!d' $1 >> $SEGMENT_FILE
sed '1!d' $1 >> $NON_SEGMENT_FILE


Last edited by DukeNuke2; 10-19-2014 at 03:11 PM..
This User Gave Thanks to ramyags For This Post:
# 2  
Old 10-19-2014
Is this homework?
# 3  
Old 10-19-2014
Oracle

no..I need solution a bit urgently
# 4  
Old 10-19-2014
"Urgent" is a difficult word in these fora.

Not sure if I understand your requirement correctly, but you might want to place
Code:
sed 1q $1 | tee $NON_SEGMENT_FILE >$SEGMENT_FILE

right before your existing sed command. Drop the touches and the sed '1!d's
This User Gave Thanks to RudiC For This Post:
# 5  
Old 10-19-2014
Quote:
Originally Posted by RudiC
"Urgent" is a difficult word in these fora.

Not sure if I understand your requirement correctly, but you might want to place
Code:
sed 1q $1 | tee $NON_SEGMENT_FILE >$SEGMENT_FILE

right before your existing sed command. Drop the touches and the sed '1!d's
The above suggestion worked perfectly all right..

I have an other requirement.
With the above script I will have 2 csv files $SEGMENT_FILE and $NON_SEGMENT_FILE.
Now with the $SEGMENT_FILE which is a csv file,I need to generate two more csv files based on the value in column 6 i.e F.
If the value in column 6 is 'VS KSDS' move the values to csv file VSAM_SEQUENTIAL and place the csv file at path /VSAM
Else if the value in column 6 is space move the values to csv file SEQ_SEQUENTIAL and place the csv file at path /SEQ

Please help me with a script for this
# 6  
Old 10-19-2014
Flow control might branch you to the following code if you don't show what have you tried on this of your last requirement.
Code:
if [[ -z "$script" || -z "$effort" ]]; then
    echo "help" 2>&1 > /dev/null
    echo "urgent" 2>&1 > /dev/null
fi

# 7  
Old 10-19-2014
Sorry i dint get wat you are try to telling
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Shell script newbie- how to generate service log from shell script

Hi, I am totally a newbie to any programming languages and I just started an entry level job in an IT company. One of my recent tasks is to create a script that is able to show the log file of linux service (i.e. ntpd service) lets say, if I run my script ./test.sh, the output should be... (3 Replies)
Discussion started by: xiaogeji
3 Replies

2. Shell Programming and Scripting

Pass C shell array to another C shell script(csh) and shell(sh)

Dear Friends, Please help me on this my script name is send.csh In this i have written the statement like this set args = ( city state country price ) I want to pass this array to another c shell called receiver.csh. and i want to use it in this c shell or how to pass to... (2 Replies)
Discussion started by: SA_Palani
2 Replies

3. Shell Programming and Scripting

How to write config shell script to pass variables in master shell script?

Dear Unix gurus, We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
Discussion started by: dba1981
1 Replies

4. UNIX for Dummies Questions & Answers

How to write Config shell script to pass variables in master shell script?

Dear Unix gurus, We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
Discussion started by: dba1981
1 Replies

5. Shell Programming and Scripting

Unable to pass shell script variable to awk command in same shell 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 | awk... (2 Replies)
Discussion started by: Ashunayak
2 Replies

6. Shell Programming and Scripting

Correct shell script to Call One shell script from another shell script

Hi All, I have new for shell scripting. Problem : I have one scrip at serv1 and path of server is /apps/dev/provimage/scripts and script name:extract_ancillary.bat. I need to call this script at server2(my working server) and execute at server2 . Please let me know how to build the... (5 Replies)
Discussion started by: Vineeta Nigam
5 Replies

7. Shell Programming and Scripting

call another shell script and pass parameters to that shell script

Hi, I basically have 2 shell scripts. One is a shell script will get the variable value from the user. The variable is nothing but the IP of the remote system. Another shell script is a script that does the job of connecting to the remote system using ssh. This uses a expect utility in turn. ... (2 Replies)
Discussion started by: sunrexstar
2 Replies

8. Shell Programming and Scripting

How to use ssh execute other shell script on other host (shell script include nohup)?

i want use ssh on the host01 to execute autoexec.sh on the host02 like following : host01> ssh host02 autoexec.sh autoexec.sh include nohup command like follwing : nohup /home/jack/deletedata.sh & after i execute ssh host02 autoexec.sh one the host01. i can't found deletedata.sh... (1 Reply)
Discussion started by: orablue
1 Replies

9. Shell Programming and Scripting

invoking a shell script inside cgi shell script

Hi, I have an HTML form through which I get some text as input. i need to run a shell script say script.sh inside a perl-cgi script named main_cgi.sh on the form input. I want to write the contents of the form in a file and then perform some command line operations like grep, cat on the text... (2 Replies)
Discussion started by: smriti_shridhar
2 Replies

10. Shell Programming and Scripting

How to Run a shell script from Perl script in Parent shell?

Hi Perl/UNIX experts, I have a problem in running a shell script from my perl script (auto.pl). I run the perl script using perl auto.pl from the shell prompt The shell script picks the files in "input" folder and procesess it. The shell script blue.sh has this code. export... (16 Replies)
Discussion started by: hifake
16 Replies
Login or Register to Ask a Question