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
frontend-spec
FRONTEND-SPEC(7) FRONTEND-SPEC(7)
NAME
frontend-spec - interface between jw and its frontends
DESCRIPTION
jw(1) calls frontends like frontends/docbook to get the informations specific to a given input format. The frontend knows which information
to return from the first command line parameter. It gets all necessary data via environment variables ready to use.
This document describes that command line parameter and those environment variables.
The frontend should return 0 if there weren't any problem, and return a positive value otherwise.
VARIABLES
$1
The command line parameter, specifying which information to return. It can take the following values:
centralized-catalog
The frontend must return the DTD-specific centralized catalog name. Centralized catalogs normally reside in /etc/sgml and
provide the location of all the catalog files useful for handling this input type (the catalog for the DTD, the catalog for
the stylesheets, the catalog for the entities, ...)
style-sheet
The frontend must return the filename of the style sheet to be used for this document type and with the chosen backend.
SGML_CATALOGS_DIR
The directory where the centralized catalogs reside. It is normally /etc/sgml.
(This variable is valid only while determining the centralized catalog to use.)
SGML_BASE_DIR
The base directory of the SGML system. It is normally /usr/share/sgml.
(This variable is valid only while determining the style sheet to use.)
SGML_FILE
The name of the file to convert.
(This variable is valid only while determining the centralized catalog to use.)
SGML_TYPE
The type of the backend to use, whether it produces output files to be displayed online or to be printed out. It can take the value
html or print.
(This variable is valid only while determining the style sheet to use).
SGML_STYLESHEETS
The desired custom stylesheet type, either none or default. If none, the frontend must return the file name of the style sheet pro-
vided by the system beneath the docbook-utils. If default, the frontend must return the custom stylesheet provided by the docbook-
utils.
(This variable is valid only while determining the style sheet to use).
SGML_XML
The metalanguage of the file to convert, either sgml or xml.
(This variable is valid only while determining the centralized catalog to use).
FILES
SEE ALSO
backend-spec(7)
AUTHORS
Jochem Huhmann <joh@revier.com>
12 September 2012 FRONTEND-SPEC(7)