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 DEBIAN
otl2html
otl2html(1) General Commands Manual otl2html(1)
NAME
otl2html - converts vimoutliner outline to HTML
SYNOPSIS
otl2html [filename]
DESCRIPTION
This manual page documents briefly the otl2html Python script.
otl2html is a is a python(1) script that converts a vimoutliner(1) outline to HTML.
otl2html script called just with filename of the processed outline will produce HTML document on standard output.
OPTIONS
-p Presentation: slide show output for use with HtmlSlides.
-D First-level is divisions (<div> </div>) for making pretty web pages.
-s sheet Use the specified style sheet with a link.
-S sheet Include the specified style sheet in-line the output. For encapsulated style.
-T The first line is not the title. Treat it as outline data
-c Hide comments (line with [ as the first non-whitespace character. Ending with ] is optional.
-C copyright Override the internal copyright notice with the one supplied in the quoted string following this flag. Single or double
quotes can be used.
-v Print version (RCS) information.
-H Show the file syntax help.
SEE ALSO
vim(1), python(1)
AUTHOR
This manual page was written by Matej Cepl <matej@ceplovi.cz>, for the Debian GNU/Linux system (but may be used by others).
March 5, 2005 otl2html(1)