Help needed in Shell Script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help needed in Shell Script
# 1  
Old 10-24-2007
Help needed in Shell Script

Hi



I have the following columns in my input file which is sorted on ColA



colA colB colC colD colE



The data is such that for a single colA it can have multiple values of other columns, for eg the data can be



colA colB colC colD colE

1 1 1 1 1

1 2 1 1 1

1 3 1 1 1

1 4 1 1 1

1 5 1 1 1

2 1 1 1 1

2 2 1 1 1

2 3 1 1 1

2 4 1 1 1

2 5 1 1 1





I need to check the records based on ColA, for value of ColA(1) I need to check the other columns for the next value of colA(2) and so on. If other columns (col B,C,D,E) match exactly for all the colA values then I need to pass only on record to output file.

I need to check whether all the records with value of ColA as 1 matched with the all the records with Value of ColA as value other than 1





Basically, I need to compare the current and previous complete records (consisting of 5 columns). If they match, then I have to pass only one such occurrence of the record.



Consider the second scenario

colA colB colC colD colE

1 1 1 1 1

1 2 1 1 1

1 3 1 1 1

1 4 1 1 1

1 5 1 1 1

2 1 1 1 1

2 2 1 1 1

2 3 1 1 1





In this case even though the columns B, C, D, E match for different values of ColA but not all the rows of ColA with value 1 matched with the colA with Value 2, so in this case I need to output file 2 records each for different values of ColA.



Any idea how do I go about this
# 2  
Old 10-24-2007
check the uniq command if it solves your problem
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script - help needed

I want to take out the Z1 value from the lscfg outpu and use the below command to get it lscfg -vl hdisk0 | grep "Device Specific.(Z1)" | awk -F. '{print $NF}' # lscfg -vpl hdisk0 . . Device Specific.(Z0)........0000063268181002 Device Specific.(Z1)........020064a . And it works,... (2 Replies)
Discussion started by: moorthikv
2 Replies

2. Shell Programming and Scripting

Help needed with shell script

Hi, I have trouble building the logic for the following, could anyone please help me out with this: Im working on a wrapper script to check for input files (in a specific directory) and pass the input files along with the options as parameters to the main script.The options vary depending ... (2 Replies)
Discussion started by: stunnerz_84
2 Replies

3. UNIX for Dummies Questions & Answers

Help needed with Shell script

Hi I want a script which should basically do 1. If the size of the file is 0kb, send email to some list od ppl 2. if the size of the file is other than 0kb send email to someother list... Pls help (2 Replies)
Discussion started by: win4luv
2 Replies

4. Shell Programming and Scripting

Help Needed on shell script

#!/bin/sh #Displaying every argument while ; do echo Moving file $0; shift; done exit 0; For the above script i get the below o/p when 2 arguments are passed when invoking the script dmlFileCopy.sh: line 3: Can you let me know how to rectify the error? (2 Replies)
Discussion started by: Anand86
2 Replies

5. Shell Programming and Scripting

Help needed with Shell script

Hi all, I need to modify the below highlighted piece to perform the below task. Please let me know as i am not able to figure out a way to do this. || FILENAME=$(date +"$FILENAME") if ; then do_log FATAL "FILENAME needs to be set if SWITCH2=0" exit 1 fi... (3 Replies)
Discussion started by: stunnerz_84
3 Replies

6. Shell Programming and Scripting

Help needed in shell script

i am trying to read an existing xml file and find an element in the xml file of following format <home.dir value="/local/mnt/homes/docs"/> I am trying to take a command line argument to my shell script whose value should replace /local/mnt/homes/docs in xml document. Can you please point me how... (3 Replies)
Discussion started by: viswas
3 Replies

7. Shell Programming and Scripting

Help with Shell Script Needed

Hi all, I'm a newbie. I'm thinking of making a shell script which will list a directory for *.csv files and merge all the files into a single file called data.csv. However, i have no idea how to. What i do currently is to manually issue the following command to merge multiple CSV files into... (1 Reply)
Discussion started by: infinity2030
1 Replies

8. Shell Programming and Scripting

help needed for a shell script

i need to search the starting line example we have -sh shl-js-gd i need to search only starting -sh not the other i have used cmd cat filename | grep '-' but it will check for complete - in the file please help me to search only starting - thank u revenna (0 Replies)
Discussion started by: revenna
0 Replies

9. Shell Programming and Scripting

Help needed for Shell Script.....

Hello Friends, Can you pls advice me on the following requirement: What we'd like to achieve is the following: - having a password.properties file which contains some passwords, e.g. BOT_PASSWORD=dog.name - in the configuration file, insert as the password value something like... (0 Replies)
Discussion started by: pulkit
0 Replies

10. UNIX for Dummies Questions & Answers

shell script Help Needed!!

Hi guys-- Here is the interesting problem.. I have a folder, which has a couple of xml files like ( could be anywhere under the sub folders) ABCD_NA.xml XAYSGD_SC.xml CBV_CA.xml etc I need to peek in each of these xml's and see that the pattern before the _ and after the _ are there... (0 Replies)
Discussion started by: smallu
0 Replies
Login or Register to Ask a Question