convert Text to Excel Post: 302068705

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert to excel

Hi to all the tycoons of Shell programming!! I am getting a csv report out of a query and the report is delimited with '|' symbol. I would like to convert this csv report into an xls column wise.. Let me show u an example as below Say a.csv looks like below Number|Description|Cycle|Date...

2. Shell Programming and Scripting

Convert each field to excel

Hi Folks!! I would like to convert each and every output of my query to the excel column wise. Let me give you an example The first attachment (cr.jpg) is the one which i am getting out of a query and the fields are delimited with a '|' (pipe) symbol. I would like to convert each field into a...

3. Shell Programming and Scripting

how to convert fields from a text file to excel columns

i have this file which has the following contents: ,-0.3000 ,-0.3000 ,-0.3000 ,-0.9000 ,-0.9000 ,-0.9000 i would like to get this: -0.3-0.9-0.3-0.9-0.3-0.9 so far i am trying: awk '{for(i=1; i<=NF; i++) {printf("%f\n",$i)}}' test1 > test2 any help...

4. UNIX for Advanced & Expert Users

how to convert text/csv to excel

Hello All, I have a sql report with 50 columns and 1000 rows result in a file ( txt / csv). is there is any way that we can move them to excel in KSH. Thanks, Sateesh

5. Shell Programming and Scripting

How to convert excel file to csv file or text file?

Hi all, I need to find a way to convert excel file into csv or a text file in linux command. The reason is I have hundreds of files to convert. Another complication is the I need to delete the first 5 lines of the excel file before conversion. so for instance input.xls description of...

6. Shell Programming and Scripting

Need to convert delimited text file in UNIX to an Excel file

Dear Users , Need to convert delimited text files in UNix server to an Excel file and move the excel file to Windows environment. Am trying to automate the whole process. Can anyone share the ideas,if they have done similar ones before...Thanks -Meera

7. Shell Programming and Scripting

Need to convert text file into Excel sheet

:cool:Hi, Iam new to this Scripts and forum too. Plz excuse if may i ask silly questions now and further.. Prob: i need to convert txt files data into excel sheet. Suppose if i have hour-wise data in txt file1 and file2 like file1 file2 00: 140 00: 235 01: 160 01:415...

8. Shell Programming and Scripting

Need help to write a shell script to convert text file to excel file.

Hi Everyone, I want your help to write a script which will take text file as input and on the basis of delimiter ":"script will create excel sheet. Example input: IpAdress:InstanceName:Port:ServerName 10.255.255.1:abc:2232:xyz_abc Output should be an excel sheet like below: Column...

9. UNIX for Beginners Questions & Answers

Convert Excel File (xls) to tab delimited text file on AIX

Hi i have a problem in my job i try to convert an excel file (xls extention) to text file (tab delimited), but no result with this comand cat xxx.xls > xxx.txt Do you have eny idea? PS: sorry for my english Thanks!!

10. Shell Programming and Scripting

Convert excel to tab

Hello, I have an excel sheet (.xlsx), with 11 worksheets. I need to run my bash scripts on the 1st worksheet and write the output to the 2nd worksheet. I am currently manually converting the worksheet into a tab delimited to run the script and then pasting it back to excel. Is there a way to do...

LEARN ABOUT DEBIAN

otl2html

otl2html(1)						      General Commands Manual						       otl2html(1)

NAME

       otl2html - converts vimoutliner outline to HTML

SYNOPSIS

       otl2html [filename]

DESCRIPTION

       This manual page documents briefly the otl2html Python script.

       otl2html is a is a python(1) script that converts a vimoutliner(1) outline to HTML.

       otl2html script called just with filename of the processed outline will produce HTML document on standard output.

OPTIONS

       -p     Presentation: slide show output for use with HtmlSlides.

       -D     First-level is divisions (<div> </div>) for making pretty web pages.

       -s     sheet Use the specified style sheet with a link.

       -S     sheet Include the specified style sheet in-line the output.  For encapsulated style.

       -T     The first line is not the title. Treat it as outline data

       -c     Hide comments (line with [ as the first non-whitespace character.  Ending with ] is optional.

       -C     copyright  Override  the internal copyright notice with the one supplied in the quoted string following this flag.  Single or double
	      quotes can be used.

       -v     Print version (RCS) information.

       -H     Show the file syntax help.

SEE ALSO

       vim(1), python(1)

AUTHOR

       This manual page was written by Matej Cepl <matej@ceplovi.cz>, for the Debian GNU/Linux system (but may be used by others).

								   March 5, 2005						       otl2html(1)