Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Validating XSL sheet data in Unix Data file Post 302255395 by ravijunghare on Thursday 6th of November 2008 10:23:12 AM
Old 11-06-2008
Validating XSL sheet data in Unix Data file

Dear All,

Need your help.
In my day to day activities I have to validate/search Excel Sheet data (eg.say Application No. 0066782345) data into the Unix environment file whether the same data is present in that file or not.
There are hundreds of records coming in excel file and I am doing grep 0066782345 <file_name> in unix for each record.

Could you pls help to do this task in one shot in Unix file for all diff application Number present in excel file?

Thanks in Adv.
Ravi
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

validating data

I have a file like the following aaaaa00005bbbbb aaaaa00108bbbbb The code "00005" and "00108" need to be validated and the list of valid codes are stored in a database. While I loop through the file, should call a sql statement for every records to do the validation? or is... (1 Reply)
Discussion started by: joanneho
1 Replies

2. UNIX for Dummies Questions & Answers

How can import data files to XL sheet.

Hi, I have the file(F1.XL) in Unix Box. it's updating every 1hr. I would like to import f1.xl to Windows excel sheet, when i need see the reports. can any one clarify, is there any VB script for importing data from UNIX, like sql connection.... thanks (1 Reply)
Discussion started by: koti_rama
1 Replies

3. UNIX for Advanced & Expert Users

how to read the data from an excel sheet and use those data as variable in the unix c

I have 3 columns in an excel sheet. c1 c2 c3 EIP_ACCOUNT SMALL_TS_01 select A.* from acc; All the above 3 col shoud be passed a variable in the unix code. 1.How to read an excel file 2.How to pass these data as variable to the unic script (1 Reply)
Discussion started by: Anne Grace
1 Replies

4. UNIX for Dummies Questions & Answers

how to fill the name of the spread sheet as a cell's data

In open office spreadsheet, i would like to fill a cell with the name of the spread sheet. That is if the file name of spread sheet is, team.ods, then i have to fill a specific cell with that name 'team'. How to do that ? I have more spread sheets to be created, so i want it to be done... (0 Replies)
Discussion started by: thegeek
0 Replies

5. Shell Programming and Scripting

HOWTO create in UNIX a Microsoft Excel-Sheet (with data from Oracle)

Hi HOWTO create in UNIX a Microsoft Excel sheet (with data from Oracle). At the moment I am making CSV files (using SQL statemens with || ';'), but search for more advanced formatting. Don't wish to use Perl. cheers (4 Replies)
Discussion started by: slashdotweenie
4 Replies

6. Shell Programming and Scripting

validating data in columns and writing them to new file

I have a file that contains records in the below format: 23857250998423948239482348239580923682396829682398094823049823948 23492780582305829852095820958293582093585823095892386293583203248 23482038509825098230958235234230502958205983958235820358205892095... (10 Replies)
Discussion started by: shellhelp
10 Replies

7. Shell Programming and Scripting

Copy Data from CSV file to Excel Sheet using Perl

Hi All, Firstly I will like to wish A Happy New Year to all. Now my issue is I have one csv file say(data.csv) and one excel file say(result.xls) The result.xls contains two sheet name Sheet1 and Sheet2, Now What I am trying to do is to First I want to delete that data of Sheet2 if present any,... (6 Replies)
Discussion started by: adisky123
6 Replies

8. UNIX for Dummies Questions & Answers

Load UNIX data into excel sheet

Hi, i have some data in a temporary file in Unix (the data is taken from the result of an SQL query). Now i want to dump that data into an excel sheet. How to do that. Someone please advise. Thanks Regards, Vinit (3 Replies)
Discussion started by: vinit raj
3 Replies

9. UNIX for Dummies Questions & Answers

UNIX data to be updated to ms excel sheet

hi, i wanted to add unix data to be updated to the excel sheet. (3 Replies)
Discussion started by: rupesh.bombale
3 Replies
crypto(7)						   Erlang Application Definition						 crypto(7)

NAME
crypto - The Crypto Application DESCRIPTION
The purpose of the Crypto application is to provide message digest and DES encryption for SMNPv3. It provides computation of message digests MD5 and SHA, and CBC-DES encryption and decryption. CONFIGURATION
The following environment configuration parameters are defined for the Crypto application. Refer to application(3erl) for more information about configuration parameters. debug = true | false <optional> : Causes debug information to be written to standard error or standard output. Default is false . OPENSSL LIBRARIES
The current implementation of the Erlang Crypto application is based on the OpenSSL package version 0.9.7 or higher. There are source and binary releases on the web. Source releases of OpenSSL can be downloaded from the OpenSSL project home page, or mirror sites listed there. The same URL also contains links to some compiled binaries and libraries of OpenSSL (see the Related/Binaries menu) of which the Shining Light Productions Win32 and OpenSSL pages are of interest for the Win32 user. For some Unix flavours there are binary packages available on the net. If you cannot find a suitable binary OpenSSL package, you have to fetch an OpenSSL source release and compile it. You then have to compile and install the library libcrypto.so (Unix), or the library libeay32.dll (Win32). For Unix The crypto_drv dynamic driver is delivered linked to OpenSSL libraries in /usr/local/lib , but the default dynamic linking will also accept libraries in /lib and /usr/lib . If that is not applicable to the particular Unix operating system used, the example Makefile in the Crypto priv/obj directory, should be used as a basis for relinking the final version of the port program. For Win32 it is only required that the library can be found from the PATH environment variable, or that they reside in the appropriate SYS- TEM32 directory; hence no particular relinking is need. Hence no example Makefile for Win32 is provided. SEE ALSO
application(3erl) Ericsson AB crypto 2.0.2.1 crypto(7)
All times are GMT -4. The time now is 07:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy