Hi all
I am new to shell scripting.
I need to write a shell script that reads each row of an USER_ID colume in a excel file.
the excel has around 10000 rows of data.
Can someone gives me some example or advice what's best way to do this
thanks (11 Replies)
Hi,
I have an excel sheet which has 100000 records. All these records are having 3 columns each with the last column as "Y" or "N". I would like to filter those records which has the value "Y". Can you please let me know how to proceed with that?
Thanks in advance.
-Sri
----------... (8 Replies)
Hi,
Can any one tell me how to put data using shell script to a excel file from text file to other columns of excel file,leaving first column unaffected i.e it should not overwrite data in first column.
Say my text file data is:
15-dec-2008 15-dec-2009
16-dec-2008 16-dec-2009
say my first... (1 Reply)
The scope of the shell/perl script is to read the input text file. Validate the expiry date of each certificate and send the mail to the user. The user takes action to add the new certificate to the storage file and user owns the responsibility to update the input text file with the new certificate... (5 Replies)
Hi.
I wish to add data in a specific excel file on daily basis.However the currect dat's data should always come on top i.e for example should always occupy cell A7,B7,C7 ..
and the data of day before which was earlier on 7th row of each coloumn should move to 8th row..data on 8th row should... (1 Reply)
I have a software which generates excel report with some specific data. The excel file format is .xls (old 2003 format)
The data are in the forms like differenct cells contains numeric, string and alphanumeric data.
The data per cell for specific input data is fixed.
I need to retrive specific... (11 Replies)
Hi folks,
I am working on assignment that captures all the records(2 columns one column contains names and other contain date of birth) from excel sheet stored in a directory and checks for current date and month.
If it matches current date and month then the matched records are printed as... (1 Reply)
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)
Hello All,
I have the following code in PERL to write data to excel sheet.
Can someone please help me about how to append data to an exisitng cell?
For ex in the below given case,Cell 1,1 has Active State PERL
Now I want to add a new line like "prorgamming" without overwritting the... (3 Replies)
Hi,
I am looking for a ready shell script that can help in loading and validating a high volume (around 4 GB) .Dat file . The data in the file has to be validated at each of its column, like the data constraint on each of the data type on each of its 60 columns and also a few other constraints... (2 Replies)
Discussion started by: Guruprasad
2 Replies
LEARN ABOUT DEBIAN
ns_getmimetype
Ns_Mime(3aolserver) AOLserver Library Procedures Ns_Mime(3aolserver)__________________________________________________________________________________________________________________________________________________NAME
Ns_GetMimeType - Return the MIME type of a file
SYNOPSIS
#include "ns.h"
char *
Ns_GetMimeType(char *file)
_________________________________________________________________DESCRIPTION
Ns_GetMimeType(file)
The Ns_GetMimeType function uses the extension of file and looks up the associated MIME type stored internally in the server. Case
is ignored. The return value is of the form "text/html".
AOLserver has a set of predefined file extension to MIME type associations. You can add to these associations by defining file
extension to MIME type associations in the server configuration file in the ns/mimetypes section. If you define a file extension
that already exists in the server, that file extension and MIME type association will be replaced with yours.
If no MIME type association exists for a particular file extension, or there is no file extension, the default and noextension MIME
types are returned, respectively. These default to "*/*" but can be set in the server configuration file.
Here is an example ns/mimetypes section from the server configuration file:
ns_section "ns/mimetypes"
ns_param ".doc" "application/msword"
ns_param ".ppt" "application/vnd.ms-powerpoint"
ns_param ".xls" "application/vnd.ms-excel"
ns_param ".cab" "application/mscabinet"
ns_param ".frl" "application/x-perfpro"
ns_param ".max" "application/vviewer"
ns_param ".mif" "application/x-mif"
ns_param ".frz" "application/x-dffill"
ns_param ".asvg" "image/svg-xml"
ns_param ".asvgz" "image/svg-xml"
ns_param ".svg" "image/svg-xml"
ns_param ".svgz" "image/svg-xml"
ns_param default "*/*"
ns_param noextension "*/*"
SEE ALSO nsd(1), info(n)
KEYWORDS AOLserver 4.0 Ns_Mime(3aolserver)