Sponsored Content
Top Forums Shell Programming and Scripting reading data from excel using shell script Post 302155808 by porter on Saturday 5th of January 2008 09:43:22 PM
Old 01-05-2008
This can be done with "IFS=," and "while read A B C D E ..."

What database are you using?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Reading data from a file through shell script

There is one Text file data.txt. Data within this file looks like: a.sql b.sql c.sql d.sql ..... ..... want to write a shell script which will access these values within a loop, access one value at a time and store into a variable. can anyone plz help me. (2 Replies)
Discussion started by: Dip
2 Replies

2. Shell Programming and Scripting

Filter data in Excel sheet using Shell Script

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)
Discussion started by: bhanusri83
8 Replies

3. Shell Programming and Scripting

how to put data using shell script to a excel file

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)
Discussion started by: siri_886
1 Replies

4. UNIX for Advanced & Expert Users

put data in excel file using shell script

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)
Discussion started by: kanus
1 Replies

5. Shell Programming and Scripting

Reading the data from CSV and performing search through shell script

Hello, I am working on building a script that does the below actions together in my Linux server. 1) First, have to read the list of strings mentioned in CSV and store it in the shell script 2) Second, pick one by one from the string list, and search a particular folder for files that... (2 Replies)
Discussion started by: vikrams
2 Replies

6. Shell Programming and Scripting

Export data from database in Excel sheet with the help of Shell script and automated the report

Export data from database in Excel sheet with the help of Shell script and automated the report every day in the mornig. (1 Reply)
Discussion started by: neeraj617
1 Replies

7. Shell Programming and Scripting

Need help on inserting data from text file to excel using shell script

Hi, Please help me on this. I want to insert data from text file to excel using shell script nawk -v r=4 -v c=4 -v val=$a -F, 'BEGIN{OFS=","}; NR != r; NR == r {$c = val; print}' "file.csv" I used above one to insert $a value in 4th row, 4th column in an excel file.csv and it... (3 Replies)
Discussion started by: suman.frnz
3 Replies

8. Shell Programming and Scripting

How to write text file data to excel using UNIX shell script?

Hi All, I have the requirement in unix shell script. I want to write the "ls -ltr" command out put to excel file as below. Input :text file data : drwxr-xr-x 5 root root 4096 Oct 2 12:26 drwxr-xr-x 2 apx aim 4096 Nov 29 18:40 drwxr-xr-x 5 root root 4096 Oct 2 12:26 drwxr-xr-x... (10 Replies)
Discussion started by: Balasankar
10 Replies

9. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies

10. Shell Programming and Scripting

Reading a column from excel using shell script in Linux environment

Hi all I am new to shell scripting. I need to read the 1st column and last of the excel file in linux environment. Can some one help me with examples (3 Replies)
Discussion started by: Vigneshj28
3 Replies
XrmMergeDatabases(3X11) 					     MIT X11R4						   XrmMergeDatabases(3X11)

Name
       XrmMergeDatabases, XrmGetFileDatabase, XrmPutFileDatabase, XrmGetStringDatabase, XrmDestroyDatabase - manipulate resource databases

Syntax
       void XrmMergeDatabases(source_db, target_db)
	  XrmDatabase source_db, *target_db;

       XrmDatabase XrmGetFileDatabase(filename)
	  char *filename;

       void XrmPutFileDatabase(database, stored_db)
	  XrmDatabase database;
	  char *stored_db;

       XrmDatabase XrmGetStringDatabase(data)
	  char *data;

       void XrmDestroyDatabase(database)
	  XrmDatabase database;

Arguments
       data	 Specifies the database contents using a string.

       database  Specifies the database that is to be used.

       filename  Specifies the resource database file name.

       source_db Specifies the resource database that is to be merged into the target database.

       stored_db Specifies the file name for the stored database.

       target_db Specifies a pointer to the resource database into which the source database is to be merged.

Description
       The function merges the contents of one database into another.  It may overwrite entries in the destination database.  This function is
       used to combine databases (for example, an application specific database of defaults and a database of user preferences).  The merge is
       destructive; that is, the source database is destroyed.

       The function opens the specified file, creates a new resource database, and loads it with the specifications read in from the specified
       file.  The specified file must contain lines in the format accepted by If it cannot open the specified file, returns NULL.

       The function stores a copy of the specified database in the specified file.  The file is an ASCII text file that contains lines in the for-
       mat that is accepted by

       The function creates a new database and stores the resources specified in the specified null-terminated string.	is similar to except that
       it reads the information out of a string instead of out of a file.  Each line is separated by a new-line character in the format accepted
       by

       If database is NULL, returns immediately.

See Also
       XrmGetResource(3X11), XrmInitialize(3X11), XrmPutResource(3X11), XrmUniqueQuark(3X11)
       X Window System: The Complete Reference, Second Edition, Robert W. Scheifler and James Gettys

															   XrmMergeDatabases(3X11)
All times are GMT -4. The time now is 01:07 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy