06-22-2010
As a rule of thumb, only Excel understands Excel. All Microsoft trumpeted about open document formats was pure baloney -- it's still a proprietary binary blob, wrapped in an open container format but still a proprietary binary blob.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Can anyone tell the option to change the file type in unix.
i.e. if a file is in csv(Comma Separating Values) format, it should be changed to xls(ordinary MS-Excel) format. But renaming command is not changing to correct file format.
Thanks in advance,
Milton. (1 Reply)
Discussion started by: miltony
1 Replies
2. Shell Programming and Scripting
I need to convert an excel file into a text file
and an excel file into a CSV file..
any code to do that is appreciated
thanks (6 Replies)
Discussion started by: bandar007
6 Replies
3. UNIX for Advanced & Expert Users
Hi All,
I wrote a script to extract data from Oracle DB and place it in a text file , and I have coverted .txt file into comma seperated .csv file and I sent it to my mail box .
I can get .xls file in my inbox.I am getting all data in same column and in different rows , without column... (1 Reply)
Discussion started by: krthkmuthu
1 Replies
4. Shell Programming and Scripting
find . -type f -name "*.sql" -print|xargs perl -i -pe 's/pattern/replaced/g'
this is simple logic to find and replace in multiple files & folders
Hope this helps.
Thanks
Zaheer (0 Replies)
Discussion started by: Zaheer.mic
0 Replies
5. Shell Programming and Scripting
HI,
Please find the text below. I receive a .csv file on server. I need the comma(,) in the second column to be replaced by a semi-colon( ; ).
How to do it. Please help.
Sample text:
"1","lastname1,firstname1","xxxxxx","19/10/2009","23/10/2009","0","N","Leave"... (2 Replies)
Discussion started by: libin4u2000
2 Replies
6. UNIX for Dummies Questions & Answers
I think I know the answer to this :rolleyes: but thought I'd ask anyway. You never know.
Does anyone know of a program or utility that will run on any unix platform and convert Microsoft Excel files to ascii/plain text files that unix can understand ?
Thanks in advance.
Floyd (3 Replies)
Discussion started by: fwellers
3 Replies
7. Shell Programming and Scripting
hello
I have browsed for the similar requirement i found this
https://www.unix.com/shell-programming-scripting/40163-xls-csv-conversion.html
but my problem is i have multiple tabs in xls file having same metadata
I want to convert it into single csv file
any ways to do it pls... (5 Replies)
Discussion started by: joshiamit
5 Replies
8. Shell Programming and Scripting
Hi All,
Random question, how would you convert a data file from a list like so:
12345
12346
12347
12348
12349
12350
... <snip 100+ lines> ...
to comma separated X columns across:
12345,12346,12347
12348,12349,12350
Why would you want to do this? The background to this is a... (2 Replies)
Discussion started by: craigp84
2 Replies
9. Shell Programming and Scripting
I have a flat file (template) where I want to replace variables based upon a value in another file (csv).
The variables in the template are named %VAR_X_z%
The values are in the csv file and X is field 0 of each line and y field 1 and up.
Example of the csv:
Badidas, 13.00, 12.00, 11.00,... (8 Replies)
Discussion started by: biscayne
8 Replies
10. Shell Programming and Scripting
i have installed CENTOS in VMware. I want the linux command to run in CENTOS.
The command is to select data's from Event table(our table name) convert into .xls and mail every 2hrs. Can you please help me in writing this script.
Thanks,
Shobana (1 Reply)
Discussion started by: shobana praveen
1 Replies
LEARN ABOUT SUSE
debugfs_create_blob
DEBUGFS_CREATE_BLOB(9) The debugfs filesystem DEBUGFS_CREATE_BLOB(9)
NAME
debugfs_create_blob - create a debugfs file that is used to read a binary blob
SYNOPSIS
struct dentry * debugfs_create_blob(const char * name, mode_t mode, struct dentry * parent, struct debugfs_blob_wrapper * blob);
ARGUMENTS
name
a pointer to a string containing the name of the file to create.
mode
the permission that the file should have
parent
a pointer to the parent dentry for this file. This should be a directory dentry if set. If this parameter is NULL, then the file will
be created in the root of the debugfs filesystem.
blob
a pointer to a struct debugfs_blob_wrapper which contains a pointer to the blob data and the size of the data.
DESCRIPTION
This function creates a file in debugfs with the given name that exports blob->data as a binary blob. If the mode variable is so set it can
be read from. Writing is not supported.
This function will return a pointer to a dentry if it succeeds. This pointer must be passed to the debugfs_remove function when the file is
to be removed (no automatic cleanup happens if your module is unloaded, you are responsible here.) If an error occurs, NULL will be
returned.
If debugfs is not enabled in the kernel, the value -ENODEV will be returned. It is not wise to check for this value, but rather, check for
NULL or !NULL instead as to eliminate the need for #ifdef in the calling code.
COPYRIGHT
Kernel Hackers Manual 2.6. July 2010 DEBUGFS_CREATE_BLOB(9)