How to change the format of an Excel from exponential to text through UNIX command?
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 help to convert a file without generating the exponential value.
Input:
Output:
UNIX script used for this convertion is shown below:
Moderator's Comments:
Please use CODE tags as required by forum rules!
Last edited by RudiC; 10-18-2016 at 11:19 AM..
Reason: Added CODE tags.
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 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)
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 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)
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)
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)
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)
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
LEARN ABOUT OPENSOLARIS
thumbnail
thumbnail(1) User Commands thumbnail(1)NAME
thumbnail - create a TIFF file with thumbnail images
SYNOPSIS
thumbnail [options] input.tif output.tif
DESCRIPTION
The thumbnail command shows how to use the SubIFD tag (#330) to store thumbnail images. thumbnail copies a TIFF Class F facsimile file to
the output file and, for each image, an 8-bit grayscale thumbnail sketch. The output file contains the thumbnail image with the associated
full-resolution page linked below with the SubIFD tag.
By default, thumbnail images are 216 pixels wide by 274 pixels high. Pixels are calculated by sampling and filtering the input image with
each pixel value passed through a contrast curve.
OPTIONS
The following options are supported:
-c Specify a contrast curve to apply when generating the thumbnail images. By default, pixel values are passed through a lin-
ear contrast curve that simply maps the pixel value ranges. Alternative curves are as follows:
exp50 50% exponential curve
exp60 60% exponential curve
exp70 70% exponential curve
exp80 80% exponential curve
exp90 90% exponential curve
exp pure exponential curve
linear linear curve
-h Specify the height of thumbnail images in pixels.
-w Specify the width of thumbnail images in pixels.
OPERANDS
The following operands are supported:
input.tif The name of the input TIFF file.
output.tif The name of the output file.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWTiff |
+-----------------------------+-----------------------------+
|Interface stability |Uncommitted |
+-----------------------------+-----------------------------+
SEE ALSO tiffdump(1), tiffgt(1), tiffinfo(1), libtiff(3)NOTES
There are no options to control the format of the saved thumbnail images.
Updated by Breda McColgan, Sun Microsystems Inc., 2004.
SunOS 5.11 26 Mar 2004 thumbnail(1)