Sponsored Content
Top Forums UNIX for Beginners Questions & Answers How to change the format of an Excel from exponential to text through UNIX command? Post 302984206 by drl on Saturday 22nd of October 2016 07:20:13 AM
Old 10-22-2016
Hi.

Dong a Google search for the words in the title How to change the format of an excel from exponential to text through UNIX command? provides about 500K results, among them, the (very) similar thread csv - How do I stop Excel from converting value 0503E000 to 5.03E+02 automatically? - Super User along with some solutions.

Best wishes ... cheers, drl
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to format excel sheets in UNIX??

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)
Discussion started by: Vijay06
2 Replies

2. Shell Programming and Scripting

Issues in the Format in excel file generated from unix machine

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)
Discussion started by: Vijay06
10 Replies

3. HP-UX

Conver Excel file to another format ( text)

I can convert a excel file to another format , for example text type ( TXT) whit anoter caracter from delimiter a rows ??? I can change the default delimiter " | " ( or space ) of cell to another caracter ( for example @@ or ## ) without change the other space ??? (6 Replies)
Discussion started by: ZINGARO
6 Replies

4. UNIX for Dummies Questions & Answers

Save Excel file as .txt in UNIX format

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)
Discussion started by: jroyalty
2 Replies

5. Shell Programming and Scripting

Retaining the Unix CSV format in Excel format while exporting

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)
Discussion started by: rawat_me01
2 Replies

6. Shell Programming and Scripting

exponential format

awk -F"\t" -vv1=$name 'BEGIN{OFS="\t"} {gsub ("http://www."v1".com","",$6);print $1"\t-\t-","",$6,$7,$9,$2,$14,$15"\t""Apache=-\t-",$8*1000000"\t-\t-\t-\tdeflate=-\trmt=-"}' file.txt > a.txt file.txt 144.130.7.153 www.chi.com - 18/Jul/2010:00:00:00 +0000 GET... (3 Replies)
Discussion started by: sandy1028
3 Replies

7. Shell Programming and Scripting

How to change date format in 'last' command?

hi.. i am new to here. can anybody tell me how can we change the date format in the 'last' command. EX- on running last command i am getting -- rruat pts/12 172.18.40.101 Tue May 3 12:59 still logged in rruat pts/10 blr2-3f-239.asco Tue May 3 12:59 - 13:09 ... (2 Replies)
Discussion started by: thearpit
2 Replies

8. Shell Programming and Scripting

Problem with numbers in exponential format

Hi I have a shell scribt with some numbers in exponential format, for example, "1.23456789E +01" Now I would like to bring these numbers into a format without the E. Can someone help me Thanks Flo ---------- Post updated at 10:07 AM ---------- Previous update was at 09:14 AM... (1 Reply)
Discussion started by: sbfly
1 Replies

9. UNIX for Advanced & Expert Users

How to export Result to Excel Tabular format from UNIX?

Hi I am working on a script in which I am firing a query on database through Unix and getting the result set. I want to export that in an excel file. I am able to do so nut the result are exported horizontally one below the other. Can anyone plss help me out in exporting the Result in Tabular... (4 Replies)
Discussion started by: Saritau3
4 Replies

10. 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
jim_convert(1)						      General Commands Manual						    jim_convert(1)

NAME
jim_convert, jdic2txt, jsy2vjetxt, jsy2wxtxt, txt2jdic, vje2jsytxt, wx2jsytxt - Convert Japanese text and dictionary files between the JSY, WX, and VJE input methods SYNOPSIS
/usr/i18n/bin/jdic2txt [-v] [jsy-dictionary-filename] /usr/i18n/bin/jsy2vjetxt [jsy-text-filename] [vje-text-filename] /usr/i18n/bin/jsy2wxtxt [jsy-text-filename] [wx-text-filename] /usr/i18n/bin/txt2jdic [[-a] jsy-dictionary-filename] /usr/i18n/bin/vje2jsytxt [vje-text-filename] [jsy-text-filename] /usr/i18n/bin/wx2jsytxt [wx-text-filename] [jsy-text-filename] OPTIONS
Prints conversion statistics to stderr. Appends conversion results to an existing dictionary rather than creating a new dictionary. OPERANDS
Specifies the name of a JSY dictionary file. Specifies the name of a text file in JSY format. Specifies the name of the text file in VJE format. Specifies the name of a text file in WX format. DESCRIPTION
Three Japanese input methods are used on a Tru64 UNIX system: the JSY input method (Compaq), the WX input method (A.I. Soft Company), and the VJE input method (VACS Company). Software for the JSY input method is available in optional Tru64 UNIX subsets for Japanese language support. Software for the other two Japanese input methods is included only with the Japanese Tru64 UNIX product that is sold in Japan. Each of these input methods uses a specialized dictionary for conversion between Kana and Kanji characters. This fact makes it difficult for users to migrate their personal dictionaries from one input method to another, or to create a customized dictionary from a text source file for an existing dictionary. The converters described on this reference page help support customization and migration of private user dictionaries for Kana-Kanji conversion. The converters described on this reference page can be used in combination with utilities supplied with third-party software to migrate Kana-Kanji dictionaries from one input method to another. For the jsy2vjetxt, jsy2wxtxt, vje2jsytxt, and wx2jsytxt converters, both file operands are optional. If neither file is specified, stdin and stdout are used as input and output. If only one file is specified, that file is used as input and stdout is used as output. For the jdic2txt converter, stdin is used as input if the dictionary operand is omitted. The conversion results are always sent to stdout. For the txt2jdic converter, stdin is used as input. If the dictionary file argument is omitted, results are sent to stdout. The following diagrams show how the process for text file and dictionary conversion differs, depending on the input method format. In these diagrams, wx3ent and wx31st are utilities packaged with the WX input method software, and vuty is a utility packaged with the VJE input method software. The following diagrams show the process for converting dictionaries to text files using the same input method format: Text file in JSY format -> txt2jdic -> JSY dictionary JSY dictionary -> jdic2txt -> Text file in JSY format Text file in WX format -> wx3ent -> WX dictionary WX dictionary -> wx31st -> Text file in WX format Text file in VJE format -> vuty -> VJE dictionary VJE dictionary -> vuty -> Text file in VJE format The following diagrams show the process for converting text files from one input method format to another: Text file in JSY format -> jsy2wxtxt -> Text file in WX format Text file in JSY format -> jsy2vjetxt -> Text file in VJE format Text file in WX format -> wx2jsytxt -> Text file in JSY format Text file in VJE format -> vje2jsytxt -> Text file in JSY format The following diagrams show the process for converting dictionaries from one input method to another: JSY dict. -> jdic2txt -> jsy2wxtxt -> wx3ent -> WX dict. JSY dict. -> jdic2txt -> jsy2vjetxt -> vuty -> VJE dict. WX dict. -> wx31st -> wx2jsytxt -> txt2jdic -> JSY dict. VJE dict. -> vuty -> vje2jsytxt -> txt2jdic -> JSY dict. FILES
Directory where converters reside. SEE ALSO
Japanese(5) jim_convert(1)
All times are GMT -4. The time now is 09:59 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy