06-14-2011
Excel manipulation
I have a .csv file, when i open it in excel sheet the content is getting displayed in scientific notation (E+e.) , now inorder to remove tht i have appended ' (single quote) infront of the number. This is working fine. But when i open in excel the ' single quote is appearing before the number. My requirement is not to get the ' (single quote) in the output when opened in excel
Any suggestions plz
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
hi,
i have got a table with n number of rows and 2 columns..how can i get get 1 row at a time using any unix command without copying to any file?
Thanks and Regards
vivek.s (13 Replies)
Discussion started by: vivekshankar
13 Replies
2. Shell Programming and Scripting
Hi,
I am trying to find a way to read an excel work book with multiple worksheets.
And write each worksheet into a new excel file using perl. My environment is Unix.
For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create... (2 Replies)
Discussion started by: sandeep78
2 Replies
3. Shell Programming and Scripting
Hi,
I want to delete the null values that are present in all the columns except the last column
$ cat x.csv
baseball,NULL,8798765,Most played,0,5,12367,NULL,NULL,98,67,Reason is not sufficient
baseball,NULL,8928192,Most played,0,4,76893,NULL,RAW,54,78,NULL
baseball,NULL,5678945,Most... (6 Replies)
Discussion started by: scripter12
6 Replies
4. Shell Programming and Scripting
Legends,
Please help me to get the following
I have a file abc.txt with the following contents
12
13
14
15
And, i want to get the output to a variable like below
12,13,14,15 ....
How do i do this?
Regards,
san
Please use code tags when posting data and code samples! (5 Replies)
Discussion started by: sdosanjh
5 Replies
5. UNIX for Dummies Questions & Answers
Hello again Unix.com,
Just wondering if i can generate with a script:
got http://upload.com/1/1.txt
How can I download files:
http://upload.com/1/1.txt
http://upload.com/2/2.txt
to
http://upload.com/1000/1000.txt
Is there any way to auto-generate links? (2 Replies)
Discussion started by: galford
2 Replies
6. Shell Programming and Scripting
I am trying to create a program where user can input data in certain excel cells using user interface on internet....the programming is on perl and server is unix
But when i parse data into excel the formatting of sheets is turned to default and all macro coding removed.
What to do...Please... (7 Replies)
Discussion started by: mud_born
7 Replies
7. Shell Programming and Scripting
All,
I have an excel sheet Excel1.xls that has some entries.
I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls
These may be in different workbooks. They are totally independent made by 2 different users.
I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies
8. Shell Programming and Scripting
Hi Folks,
Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are
1excel.xslx
2excel.xslx
3excel.xslx
now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Discussion started by: punpun66
3 Replies
9. Shell Programming and Scripting
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. OS X (Apple)
i have a string that am looking to extract all characters following 3 consecutiv numbers.
Example my string is J1705PEAN038TDMN, i need to get TDMN
My string can have multiple 3 consecutive numbers, i need what follows last occurance (9 Replies)
Discussion started by: gigagigosu
9 Replies
LEARN ABOUT OPENDARWIN
lessecho
LESSECHO(1) General Commands Manual LESSECHO(1)
NAME
lessecho - expand metacharacters, such as * and ?, in filenames on Unix systems.
SYNOPSIS
lessecho [-ox] [-cx] [-pn] [-dn] [-a] file ...
DESCRIPTION
This manual page documents briefly the lessecho command. This manual page was written for the Debian GNU/Linux distribution because the
original program does not have a manual page.
lessecho is a program that simply echos its filename arguments on standard output. But any argument containing spaces is enclosed in
quotes.
OPTIONS
A summary of options are included below.
-ox Specifies "x" to be the open quote character.
-cx Specifies "x" to be the close quote character.
-pn Specifies "n" to be the open quote character, as an integer.
-dn Specifies "n" to be the close quote character, as an integer.
-a Specifies that all arguments are to be quoted. The default is that only arguments containing spaces are quoted.
SEE ALSO
less(1)
AUTHOR
This manual page was written by Thomas Schoepf <schoepf@debian.org>, for the Debian GNU/Linux system (but may be used by others).
Less was written by Mark Nudelman <markn@greenwoodsoftware.com>
LESSECHO(1)