Sponsored Content
Top Forums Shell Programming and Scripting excel drops leading zeros while attaching through unix Post 302291580 by chebarbudo on Thursday 26th of February 2009 03:44:47 AM
Old 02-26-2009
I just tested your situation with my Excel 2003 (11.5612.5606).
And as long as I specify the Text format for the data column, it's correctly saved as csv.
BUT, as formats are not kept in text files, as soon as I re-open it, the E is interpreted as power of ten.
My advice (not sure this fits into a unix forum but anyway):
1) Create your excel sheet
2) Set the text format for your data columns
3) Save your file as Text (delimiter: tab) (*.txt) (*.txt).
4) When you reopen it for updates, you'll be prompt to import datas...
4.1) Choose delimited
4.2) Choose delimiter = tab
4.3) Choose Text format for the data columns !

Good luck
Santiago
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

FTP Between UNIX & Windows drops leading blanks

I am using ftp on Solaris to transfer files to Windows 2000 that have leading blanks in the name (ex. " 12345A4444.BIN"). When they get to Windows the leading blanks are stripped off. Has anyone encountered this and is there a fix? If I use Hummingbird it is ok but that is not an option for... (6 Replies)
Discussion started by: worf52
6 Replies

2. Shell Programming and Scripting

Leading zeros

How to insert leading zeros into a left-justisfied zip code? e.g. Zip code is written as 60320 which is left-justified to make it be read as 0060320. We have to move it to right-justifiable then insert 2 leading zeros into it... ;) (1 Reply)
Discussion started by: wtofu
1 Replies

3. Shell Programming and Scripting

how to retain leading zeros

Hi All, I am working with a fixed width file Forrmat. C1 Number (10,3) C2 Number (10,3) e.g. c1= 0000000100.000 c2= 0000000020.000 0000000100.0000000000020.000 I have to perform c1 - c2 . i.e. I want answer to be 0000000080.000. but I am loosing the leading zeros( only getting... (3 Replies)
Discussion started by: Manish Jha
3 Replies

4. Shell Programming and Scripting

Removing leading zeros from a variable

How do I remove or add leading zeroa from a variable. To make variable 10 characters long when adding zeros. (6 Replies)
Discussion started by: toshidas2000
6 Replies

5. Shell Programming and Scripting

Help needed in padding leading zeros

Hi all, I have file with numeric values. I need to pad each value with leading zeros such that total lenght of each value is 16. Example: cat tmp.txt 502455 50255 5026 5027 5028 Output 0000000000502455 0000000000050255 0000000000005026 0000000000005027 0000000000005028 Any... (12 Replies)
Discussion started by: jakSun8
12 Replies

6. UNIX for Dummies Questions & Answers

Triml leading zeros in unix

Hi All, How does one trim leading zero's in unix Thanks KP. (7 Replies)
Discussion started by: kingofprussia
7 Replies

7. Shell Programming and Scripting

Help with adding leading zeros to a filename

Hi i need help in adding leading zero to filenames e.g file name in my folder are 1_234sd.txt 23_234sd.txt the output i need is 001_234sd.txt 023_234sd.txt can i do this shell scripting please help (2 Replies)
Discussion started by: rsmpk
2 Replies

8. Shell Programming and Scripting

Numbers with leading zeros

Hi, i have a variable which conatins values like 00001,0003,00067,00459. I want to use the values one by one and in the same form as they are like 00001,0003,00067,00459. Also can anyone tell me how to increment those numbers by 1,keeping the format as same like 00002,0004,00068,00460.... (5 Replies)
Discussion started by: arijitsaha
5 Replies

9. Shell Programming and Scripting

Help deleting leading zeros in a file

I have a list of numbers extracted and need to delete the leading zeros from them, but when i do so, the command I am using also deletes numbers that end in Zero as well. eg 10, 20, 30, etc this is part of a larger script and the only way I can think of is to try and detect the 10,20 30 etc in... (19 Replies)
Discussion started by: kcpoole
19 Replies

10. Shell Programming and Scripting

Ho to remove leading zeros from a csv file which is sent from a UNIX script

Hi All, I am using a informatica job to create a csv file and a unix script the mail the generated file.Everything is working fine but I am not seeing leading zeros in the csv file sent in the mail.These zeros were present when the .csv file was generated by informatica procees. Is there any... (11 Replies)
Discussion started by: karthik adiga
11 Replies
plotit(1)						      General Commands Manual							 plotit(1)

NAME
plotit - experiment data visualization SYNOPSIS
plotit -w FILE plotit [-lp] -q FILE [FILE]... plotit [-lp] Y FILE [FILE...] plotit [-lp] X Y FILE [FILE...] DESCRIPTION
The plotit program is a simple plotting program which can draw line plots and stripcharts using a command language similar to that of gnu- plot. It can also make quick plots of multiple data files from the command-line. Wildcards may be used in the file names. The program takes optional expressions which can be used to manipulate data columns before plotting. Expressions may be as simple as the designation of a column to be plotted or may contain arithmetic expressions and functions. In the latter case the espression must be enclosed in 'single' or "double" quotation marks. Column numbers are designated by the at-sign character (@). A single expression is used for the Y axis of the plot. OPTIONS
-h, --help Print the usage and exit. --version Print the version number and exit. -w Watch the input file for commands to stripchart, or wait to read all of stdin before plotting. Only one file or - for stdin may be specified with this option. No other options may be used in conjuction with this option. -q Plot the first and second columns of each file. -l Plot with lines. -p Plot with points. EXAMPLES
Plot the second column versus the first of all three files with lines only. plotit -lq file1.dat file2.dat file3.dat Plot the quotient of the third column and the second column versus the first column of all files matching the pattern using points only. plotit -p '@3/@2' file??.dat Plot the natural log of the second column divided by the third column versus the fourth column. By default these data are plotted with both lines and points. plotit @4 'log(@2/@3)' file.dat AUTHOR
This manual page was written by Carlo Segre <segre@iit.edu>. February 21, 2009 plotit(1)
All times are GMT -4. The time now is 12:34 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy