10-01-2007
Can you get me the script of comparing data in two sheets.
Say for eg
column A,,,,,, for sheet 1
column B,,,,,, for sheet 2
I want all the columns of sheet 1 should be compared with sheet 2 (both the sheet are having same columns & structure)
Wherever data is mismatching it should give me the details in any 3rd sheet .
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Folks!
I am a MacUser and am trying to learn Unix for the last few months.
I will explain in detail what I am trying to do, and apreciate you help if you can teach me even if it is a single comand line inside the script.
I own a small company, where I manufacture special gypsums and... (5 Replies)
Discussion started by: fundidor
5 Replies
2. AIX
Hi All,
I want to read username and lastupdate only from /etc/security/passwd and write the same data to another file:
The data in /etc/security/passwd will be in this form for example:
For more details : http://www.unet.univie.ac.at/aix/files/aixfiles/passwd_security.htm#A1219924
smith:... (0 Replies)
Discussion started by: me_haroon
0 Replies
3. Shell Programming and Scripting
UNIX shell script (Bourne shell syntax) called
admin_script. This script is described below as a usage summary:
admin_script
Note: if no options are specified, a menu is displayed which allows
users to perform one of the following tasks and then exit. If
incorrect options are provided,... (1 Reply)
Discussion started by: nadman123
1 Replies
4. UNIX for Dummies Questions & Answers
Hello,
I have done some BASIC shell scripting/PERL scripting before so I am familiar with the languages. I am not really sure which one would lend itself better to the application I have to write.
I am required to scan the message logs for possible break in attempts. If I use shell scripting... (2 Replies)
Discussion started by: mojoman
2 Replies
5. Shell Programming and Scripting
Hi All,
I have written the following script. I have just repeated some commands, and I am sure there is a more better way to do it. I hope I one of gurus here will help me make it in a better shape. Here is the script:
#! /bin/sh
sed -i -e "s/test2.xxx/test3.xxx/" -e "s/output2/output3/"... (2 Replies)
Discussion started by: faizlo
2 Replies
6. Shell Programming and Scripting
I am adapting an Open Step ping server script to Ubuntu 8.10 and one section of my script isn't working
# if there are servers that just went down or came back up, notify
# with high importance
if ; then
echo notifying of servers that are up again or just now down
notify high
# if there... (2 Replies)
Discussion started by: gbxfan
2 Replies
7. AIX
If I need delete some disk,
for i in hdisk1 hdisk2 hdisk3 hdisk4
do
rmdev -dl $i
done
if I have more than 100 hdisks, how to write a script like that to delete them? (6 Replies)
Discussion started by: rainbow_bean
6 Replies
8. Shell Programming and Scripting
Hi there :rolleyes:
I have a folder called backup
it is path is: ~/backup
Inside this folder, there are four files:
~/backup/test1.cpp
~/backup/test2.cpp
~/backup/test3.cpp
~/backup/PATHS.TXT
The fourth file PATHS.TXT contains the original paths for the three files. This is the... (4 Replies)
Discussion started by: domain
4 Replies
9. IP Networking
Hi,
We have smb client running on two of the linux boxes and smb server on another linux system. During a backup operation which uses smb, read of a file was allowed while write to the same file was going on.Also simultaneous writes to the same file were allowed.Following are the settings in the... (1 Reply)
Discussion started by: swatidas11
1 Replies
10. Shell Programming and Scripting
Hi All,
I have written the follwing script to take the backup of the file every day
along with the date.
DATE=`date +%Y%m%d`
export DATE
cp var/hr/hr333m.txt cp var/hr/payments/hr333m_$DATE.txt
The file name as follows after taking the backup.
hr333m_20110630.txt
Could you... (3 Replies)
Discussion started by: ajaykumarkona
3 Replies
LEARN ABOUT OPENSOLARIS
script
script(1) User Commands script(1)
NAME
script - make record of a terminal session
SYNOPSIS
script [-a] [filename]
DESCRIPTION
The script utility makes a record of everything printed on your screen. The record is written to filename. If no file name is given, the
record is saved in the file typescript. See WARNINGS.
The script command forks and creates a sub-shell, according to the value of $SHELL, and records the text from this session. The script ends
when the forked shell exits or when Control-d is typed.
OPTIONS
The following option is supported:
-a Appends the session record to filename, rather than overwriting it.
NOTES
script places everything that appears on the screen in filename, including prompts.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
|CSI |Enabled |
+-----------------------------+-----------------------------+
SEE ALSO
attributes(5)
WARNINGS
script can pose a security risk when used in directories that are writable by other users (for example, /tmp), especially when run by a
privileged user, that is, root. Be sure that typescript is not a link before running script.
SunOS 5.11 30 Jan 2004 script(1)