How to solve formate peroblem

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...

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

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...

4. UNIX for Advanced & Expert Users

Can somebody solve this

5. Shell Programming and Scripting

Can somebody solve this please

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{...

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...

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...

LEARN ABOUT DEBIAN

spreadsheet::xlsx::utility2007

Spreadsheet::XLSX::Utility2007(3pm)			User Contributed Perl Documentation		       Spreadsheet::XLSX::Utility2007(3pm)

NAME

       Spreadsheet::XLSX::Utility2007 - Utility function for Spreadsheet::XLSX

SYNOPSIS

	   use strict;
	   #Declare
	   use Spreadsheet::XLSX::Utility qw(ExcelFmt ExcelLocaltime LocaltimeExcel);

	   #Convert localtime ->Excel Time
	   my $iBirth = LocaltimeExcel(11, 10, 12, 23, 2, 64);
				      # = 1964-3-23 12:10:11
	   print $iBirth, "
";       # 23459.5070717593

	   #Convert Excel Time -> localtime
	   my @aBirth = ExcelLocaltime($iBirth, undef);
	   print join(":", @aBirth), "
";   # 11:10:12:23:2:64:1:0

	   #Formatting
	   print ExcelFmt('yyyy-mm-dd', $iBirth), "
"; #1964-3-23
	   print ExcelFmt('m-d-yy', $iBirth), "
";	# 3-23-64
	   print ExcelFmt('#,##0', $iBirth), "
";	# 23,460
	   print ExcelFmt('#,##0.00', $iBirth), "
";	# 23,459.51
	   print ExcelFmt('"My Birthday is (m/d):" m/d', $iBirth), "
";
					     # My Birthday is (m/d): 3/23

DESCRIPTION

       Spreadsheet::XLSX::Utility exports utility functions concerned with Excel format setting.

       ExcelFmt is used by Spreadsheet::XLSX::Fmt2007.pm which is used by Spreadsheet::XLSX.

Functions
       This module can export 3 functions: ExcelFmt, ExcelLocaltime and LocaltimeExcel.

   ExcelFmt
       $sTxt = ExcelFmt($sFmt, $iData [, $i1904]);

       $sFmt is a format string for Excel. $iData is the target value.	If $flg1904 is true, this functions assumes that epoch is 1904.  $sTxt is
       the result.

       For more detail and examples, please refer sample/chkFmt.pl in this distribution.

       ex.

   ExcelLocaltime
       ($iSec, $iMin, $iHour, $iDay, $iMon, $iYear, $iwDay, $iMSec) =
		   ExcelLocaltime($iExTime [, $flg1904]);

       ExcelLocaltime converts time information in Excel format into Perl localtime format.  $iExTime is a time of Excel. If $flg1904 is true,
       this functions assumes that epoch is 1904.  $iSec, $iMin, $iHour, $iDay, $iMon, $iYear, $iwDay are same as localtime.  $iMSec means
       1/1,000,000 seconds(ms).

   LocaltimeExcel
       $iExTime = LocaltimeExcel($iSec, $iMin, $iHour, $iDay, $iMon, $iYear [,$iMSec] [,$flg1904])

       LocaltimeExcel converts time information in Perl localtime format into Excel format .  $iSec, $iMin, $iHour, $iDay, $iMon, $iYear are same
       as localtime.

       If $flg1904 is true, this functions assumes that epoch is 1904.	$iExTime is a time of Excel.

   col2int
       $iInt = col2int($sCol);

       converts a excel row letter into an int for use in an array

       This function was contributed by Kevin Mulholland.

   int2col
       $sCol = int2col($iRow);

       convert a column number into column letters NOET: This is quite a brute force coarse method does not manage values over 701 (ZZ)

       This function was contributed by Kevin Mulholland.

   sheetRef
       ($iRow, $iCol) = sheetRef($sStr);

       convert an excel letter-number address into a useful array address NOTE: That also Excel uses X-Y notation, we normally use Y-X in arrays
       $sStr, excel coord (eg. A2).

       This function was contributed by Kevin Mulholland.

   xls2csv
       $sCsvTxt = xls2csv($sFileName, $sRegion, $iRotate);

       convert a chunk of an excel file into csv text chunk $sRegions = "sheet-colrow:colrow" (ex. '1-A1:B2' means 'A1:B2' for sheet 1) $iRotate
       = 0 or 1 (output should be rotated or not)

       This function was contributed by Kevin Mulholland.

AUTHOR

       Rob Polocz rob.polocz@trackvia.com based on work by for Spreadsheet::ParseExcel by Kawai Takanori (Hippo2000) used with permission

SEE ALSO

       Spreadsheet::ParseExcel, Spreadsheet::WriteExcel

COPYRIGHT

       This module is part of the Spreadsheet::XLSX distribution.

perl v5.10.1							    2010-05-16				       Spreadsheet::XLSX::Utility2007(3pm)

Shell Programming and Scripting