Hi,
I have generated an excel sheet using a shell script. i have converted the output text file to an excel and got the desired output. However, in a particular column in the excel the values of the numbers start with 0.
e.g. 078393343, 00342442, etc.
But, in the resulting excel I get as... (2 Replies)
Hi,
I have generated a report that contains many columns and since I need ir in excel format.. I just renamed te file to excel as follows:
cp vijay.txt vijay.xls
I have just attached this spreadsheet in the mail and I am getting it to my mail id. But, in the output excel, the columns that... (10 Replies)
I have some files created in Excel that have to be saved as .txt files in order to load them into our accounting system. I can save the files as .txt files through Excel, but I then have to open them in TextPad and do a save as to change the Format from PC to UNIX. Is there a way to skip this step... (2 Replies)
Hi,
I have a file which contains the data in the below format and need to develop a script which will give the output in the tabular format.
Could you please advice me.
Folder:
Workflow: version .
Workflow run status:
Workflow run error code:
Schedule time:
Workflow run type: ... (2 Replies)
Hi All,
I have created a Unix Shell script whch creates a *.csv file and export it to Excel.
The problem i am facing is that Users wants one of the AMOUNT field in comma separted values. Example :
if the Amount has the value as 3000000 User wants to be in 3,000,000 format.
This Amount format... (2 Replies)
i need to write script to copy the txt file to excel. (data can be 2000+), data may not be in order
ex:
my name: abc
age: 20
add: xyz
DOB: 17-mar-2010
add1: adf
add2: guioth
my name: cat
age: 35
DOB: 11-oct-2005
city: yeshjl
add: opq
DOB: 17-mar-2010
add1: atg
add2: gth
add3:ert
... (2 Replies)
How can i convert the below data to a simpler format :-
cat tabular.txt
User 1 Details :-
First Name = Tom
Middle Name =
Last Name = Hanks
Age = 40
Address =
User 2 details :-
First Name = Mike
Middle Name =
Last Name = Tyson
Age = 50
Address = (2 Replies)
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)
How to change the format of an excel from exponential to text through UNIX command
We have a pipe delimited file in which one particular A column is a combination of number+text and while converting into
excel using tr command it is generating a exponential data for the A column.
Kindly... (2 Replies)
Hello Guys,
developing a monitoring shell script to have my queue depth count over mail .
here is the sample input file to the script which has all the queue names 1 : DISPLAY QUEUE(*) WHERE (CURDEPTH GT 0)
ZFC8409: Display Queue details.
QUEUE(QL.GVR.ATA.CACHE.01) ... (10 Replies)
Discussion started by: wims
10 Replies
LEARN ABOUT DEBIAN
cldump
cldump(1) User Manuals cldump(1)NAME
cldump - Clarion database extractor
SYNOPSIS
cldump [options] database.dat
DESCRIPTION
cldump extracts the data contained in a Clarion database; Clarion is a Windows IDE similar to Delphi or others, and has its own (simple)
database format.
cldump can extract the data contained in such a database, and export it to CSV, SQL (including the database schema, keys and indexes) or
its own format (this format will give you all the meta information, but isn't easily parsable).
A Clarion database consists in a set of files :
.DAT files contain the data,
.Kxx files contain the key/index data,
.MEM files contain the memo entries associated to the data.
OPTIONS -x n, --decrypt n
Decrypt an encrypted file. Required argument n indicates the location where the key will be retrieved. Valid values are in the range
1 - 4 inclusive. n = 1 usually works.
Decryption happens in-place so KEEP A BACKUP as there is no guarantee the decryption process won't fail. Encrypted files must be
decrypted before they can be dumped.
Note that only the data file and the memo file are decrypted in this process; key/index files are left untouched as cldump doesn't
use them.
-d, --dump-active
Dump active entries only
-D, --dump-data
Dump the actual data (active and deleted entries)
-m, --dump-meta
Dump meta information (no SQL or CSV output format exist for this option)
-f c, --field-separator c
Set the field separator to character c. Only valid for CSV output (see below).
-c, --csv
Dump data or schema in CSV format
-S, --sql
Dump data or schema in SQL format
-s, --schema
Dump database schema
-M, --mysql
Use MySQL specific construct (backticks, ...)
-n, --no-memo
Do not dump memo entries
-U[charset], --utf8[=charset]
Transcode strings and memos from charset to UTF-8 (charset defaults to ISO8859-1; for the list of supported charsets, see iconv
--list)
OUTPUT
cldump outputs the data to stdout or stderr depending on the output format selected, the data to extract and the type of the data (data,
meta data).
BUGS
The SQL output could be improved. Not all the types supported by the Clarion database format are implemented yet (due to lack of test data-
bases using these types of data); see the source code for details.
Please report bugs to jb@jblache.org; if possible, please send patches as the set of test databases I have is very limited.
AUTHOR
cldump was written by Julien BLACHE <jb@jblache.org>.
HOMEPAGE
http://www.technologeek.org/projects/cldump/
Linux November 2010 cldump(1)