Need help(SH script)


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need help(SH script)
# 1  
Old 03-06-2008
Need help(SH script)

Hello everyone,
I want to remove these signs like ">" and "<" which is visible in output file and requirement
is to develop a script to dispay the result in this format.

Inserted records
nbvxbb=dsf
bcbbbv=bfbv
dfjkfdj=bvfl

Deleted records
bvvfkbfdkb=vk afc
fdbvblvb=bvalds


modified records
bbbbv=blafciu
fdvbsfb=bchaf

My script is working but code i had developed to have this kind of output is not getting displayed.
Could you plz look into this code and suggest
me some modifications as per my required output format.

###########code########################

cat $1 | cut -d'|' -f 4,9 |sort >Temp1.txt
cat $2 | cut -d'|' -f 4,9 |sort >Temp2.txt

sdiff -s Temp1.txt Temp2.txt | fgrep ">" | awk -F "|" ' { print $1, "=" , $2>>"Resultantfile.txt" }'

sdiff -s Temp1.txt Temp2.txt | fgrep "<" | awk -F "|" ' { print $1, "=" , $2>>"Resultantfile.txt" }'

sdiff -s Temp1.txt Temp2.txt | awk '{ print $3}' | awk -F "|" ' { print $1, "=" , $2>>"Resultantfile.txt" }'

#################################################
OUTPUT FILE

COMPARISON BETWEEN OLD VALORIZATION FILE AND THE NEW VALORIZATION FILE/n
Newly inserted records are as follows
> @abcdefg@ = mnopq
> @hsdfkur@ = /exec/applis
Deleted records in the new file are as follows
@bkabdfh.core.admin.soft_dir@ = /exec/applis/bkbdV/ sdb/current/sof <
@arebfw.core.admin.unix_user@ = bdsbbsadf <
Modified records are as follows
=
=
@ bdasbhdfbhjksdbkfbkwer@ = blhalibfhfoiuhrefiu
@jvsaiuwlfdfffds@ = ndsfm xzchjbndsc
=
=
dESIRED OUTPUT

Newly inserted records are as follows
@abcdefg@ = mnopq
@hsdfkur@ = /exec/applis
Deleted records in the new file are as follows
@bkabdfh.core.admin.soft_dir@ = /exec/applis/bkbdV/ sdb/current/sof
@arebfw.core.admin.unix_user@ = bdsbbsadf
Modified records are as follows
@ bdasbhdfbhjksdbkfbkwer@ = blhalibfhfoiuhrefiu
@jvsaiuwlfdfffds@ = ndsfm xzchjbndsc


Any sort of help will be appreciated ..is goin to be useful for me.
Thanks in advance

Regards
Shahid Smilie
# 2  
Old 03-06-2008
Try this:

Code:
$ cat file
COMPARISON BETWEEN OLD VALORIZATION FILE AND THE NEW VALORIZATION FILE/n
Newly inserted records are as follows
> @abcdefg@ = mnopq
> @hsdfkur@ = /exec/applis
Deleted records in the new file are as follows
@bkabdfh.core.admin.soft_dir@ = /exec/applis/bkbdV/ sdb/current/sof <
@arebfw.core.admin.unix_user@ = bdsbbsadf <
Modified records are as follows
=
=
@ bdasbhdfbhjksdbkfbkwer@ = blhalibfhfoiuhrefiu
@jvsaiuwlfdfffds@ = ndsfm xzchjbndsc
=
=

$ awk 'NR==1||NF==1{next}{gsub("> ","");gsub(" <","")}1' file
Newly inserted records are as follows
@abcdefg@ = mnopq
@hsdfkur@ = /exec/applis
Deleted records in the new file are as follows
@bkabdfh.core.admin.soft_dir@ = /exec/applis/bkbdV/ sdb/current/sof
@arebfw.core.admin.unix_user@ = bdsbbsadf
Modified records are as follows
@ bdasbhdfbhjksdbkfbkwer@ = blhalibfhfoiuhrefiu
@jvsaiuwlfdfffds@ = ndsfm xzchjbndsc

Regards
# 3  
Old 03-06-2008
Thanks a lot Franklin .Its working excellent.Thanks a lot.


Regards
Shahid BakshiSmilie
Login or Register to Ask a Question

Previous Thread | Next Thread

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to block first bash script until second bash script script launches web server/site?

I'm new to utilities like socat and netcat and I'm not clear if they will do what I need. I have a "compileDeployStartWebServer.sh" script and a "StartBrowser.sh" script that are started by emacs/elisp at the same time in two different processes. I'm using Cygwin bash on Windows 10. My... (3 Replies)
Discussion started by: siegfried
3 Replies

2. Shell Programming and Scripting

Shell script works fine as a standalone script but not as part of a bigger script

Hello all, I am facing a weird issue while executing a code below - #!/bin/bash cd /wload/baot/home/baotasa0/sandboxes_finance/ext_ukba_bde/pset sh UKBA_publish.sh UKBA 28082015 3 if then echo "Param file conversion for all the areas are completed, please check in your home directory"... (2 Replies)
Discussion started by: ektubbe
2 Replies

3. UNIX for Dummies Questions & Answers

Calling a script from master script to get value from called script

I am trying to call a script(callingscript.sh) from a master script(masterscript.sh) to get string type value from calling script to master script. I have used scripts mentioned below. #masterscript.sh ./callingscript.sh echo $fileExist #callingscript.sh echo "The script is called"... (2 Replies)
Discussion started by: Raj Roy
2 Replies

4. Shell Programming and Scripting

Script will keep checking running status of another script and also restart called script at night

I am using blow script :-- #!/bin/bash FIND=$(ps -elf | grep "snmp_trap.sh" | grep -v grep) #check snmp_trap.sh is running or not if then # echo "process found" exit 0; else echo "process not found" exec /home/Ketan_r /snmp_trap.sh 2>&1 & disown -h ... (1 Reply)
Discussion started by: ketanraut
1 Replies

5. Shell Programming and Scripting

create a shell script that calls another script and and an awk script

Hi guys I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file. #!/bin/sh echo " $2 $3 $4 $5 $6 $7 isql -w400 -U$2 -S$5 -P$3 << xxx use $4 go print"**Changes to the table... (0 Replies)
Discussion started by: magikminox
0 Replies
Login or Register to Ask a Question