Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to solve formate peroblem

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to solve formate peroblem
# 1  
Old 01-17-2008
Question How to solve formate peroblem
I have converted an excel file in unix accessible form using Spreadsheet::ParseExcel. It coverting perfectly but the problem is while coverting there is one column in the excel sheet which is when coverted in unix it shows the value along with some extra value like :

in excel sheet the value in that particular column is:

12|
43|
-76|
-98|
34|

After conversion it shows this particular column's value like this:

12.00[$ 1/4C0A]
43.00[$ 1/4C0A]
76.00[$ 1/4-C0A]
98.00[$ 1/4-C0A]
34.00[$ 1/4C0A]


please give some solution to this problem
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Check time stamp formate in file

I have to check whether last line of the file has time stamp or not. File.txt cong = 0 This formats a date and time into the given strftime() format = 09 Dates can be passed to Smarty as unix timestamps = 56789 mysql timestamps or any string made up =98 Since Smarty-2.6.10 numeric... (4 Replies)
Discussion started by: Roozo
4 Replies

2. Shell Programming and Scripting

csh if loop variable condition check peroblem

Hi, I have variables like var1 var2 var3 var4 in if loop i am trying to check the condition if(variable == "var") then echo $variable endif (0 Replies)
Discussion started by: vasanth.vadalur
0 Replies

3. UNIX for Dummies Questions & Answers

Can somebody solve this

I have to find the files older than 200 days from a path and copy them to some other directory with the current date stamp attached to it. i have written like follows: #!/bin/ksh DSTAMP=$(date +"%y%m%d%H%M") rm $CA_OUT_PATH/ftp_logs/temp touch $CA_OUT_PATH/ftp_logs/temp chmod 777... (13 Replies)
Discussion started by: sreenusola
13 Replies

4. UNIX for Advanced & Expert Users

Can somebody solve this

I have to find the files older than 200 days from a path and copy them to some other directory with the current date stamp attached to it. i have written like follows: #!/bin/ksh DSTAMP=$(date +"%y%m%d%H%M") rm $CA_OUT_PATH/ftp_logs/temp touch $CA_OUT_PATH/ftp_logs/temp chmod 777... (1 Reply)
Discussion started by: sreenusola
1 Replies

5. Shell Programming and Scripting

Can somebody solve this please

I have to find the files older than 200 days from a path and copy them to some other directory with the current date stamp attached to it. i have written like follows: #!/bin/ksh DSTAMP=$(date +"%y%m%d%H%M") rm $CA_OUT_PATH/ftp_logs/temp touch $CA_OUT_PATH/ftp_logs/temp chmod 777... (1 Reply)
Discussion started by: sreenusola
1 Replies

6. Programming

does any one know how to solve?

Hello experts, Here is my code.I can create the database.But I also want it to see standard output.Please see the blocked code.If i use them they show me weired symbols. #include <stdio.h> #include <stdlib.h> struct date { int month; int day; int year; }; struct empRec{... (14 Replies)
Discussion started by: mlhazan
14 Replies

7. UNIX for Dummies Questions & Answers

formate file in unix

my file looks like this: D8511049777 I 04/10/08 99817 1,923.33 927156 Kaufman D8511049777I04100829981859003924884Martin i'd like to look like this: D8511049777I0410080000299817000000192333927156Kaufman D8511049777I0410080000299818000000059003924884Martin my spec sheet: D: starting... (4 Replies)
Discussion started by: tjmannonline
4 Replies

8. Shell Programming and Scripting

How to solve this

I have to write an script for.. CUST: 123 trans: some contents CUST: 1234 trans: some contents Now wat i have to do is this: CUST:123 akash trans: some contents CUST:1234 akash1 trans: I have been able to add... (3 Replies)
Discussion started by: akashag22
3 Replies
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

test::excel::template::plus

Test::Excel::Template::Plus(3pm)			User Contributed Perl Documentation			  Test::Excel::Template::Plus(3pm)

NAME

       Test::Excel::Template::Plus - Testing module for use with Excel::Template::Plus

SYNOPSIS

	 use Test::More tests => 1;
	 use Test::Excel::Template::Plus;

	 my $template = Excel::Template::Plus->new(
	     engine   => 'TT',
	     template => 'test.tmpl',
	     config   => { INCLUDE  => [ '/templates' ] },
	     params   => { ... }
	 );
	 $template->write_file('test.xls');

	 # compare the file we just made with
	 # an existing example file ...
	 cmp_excel_files("test.xls", "t/xls/test.xls", '... the excel files matched');

DISCLAIMER

       This module is woefully incomplete. It works for my very basic purposes right now, but it is surely going to need lots or work in the
       future to make it really usable.

DESCRIPTION

       This module attempts to provide a means of testing and comparing dynamically generated excel files. Currently it only supports comparing
       two excel files for some approximation of strutural (values within cells) and visual (formatting of said cells) equivalence.

       As a by product of the implementation, elements may get compared which don't really need comparing, and things which do need comparing may
       be skipped. This will get refined as time goes by and the module is used in more heavyweight situations.

FUNCTIONS

       cmp_excel_files($file1, $file2, $msg)

BUGS

       All complex software has bugs lurking in it, and this module is no exception. If you find a bug please either email me, or add the bug to
       cpan-RT.

AUTHOR

       Stevan Little <stevan@iinteractive.com>

COPYRIGHT AND LICENSE

       Copyright 2007-2010 by Infinity Interactive, Inc.

       <http://www.iinteractive.com>

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.14.2							    2012-05-06					  Test::Excel::Template::Plus(3pm)