01-26-2016
Please use code tags as required by forum rules!
And, be way more specific. What be the error? What's the files' structures? What's the desired output structure? With awk, you can't create EXCEL files; the best/nearest you can get is csv structure.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have two files with multiple columns separated by commas.
I want to search one column from the first file in the second file;
If there is a matching, will append that matched row to the first file. Let me show an example... (unique values in the search column)
First file
aa,reg1,bb,cc,dd,ff... (6 Replies)
Discussion started by: lalelle
6 Replies
2. Shell Programming and Scripting
Hi
I am working on a script which needs to scan a sequential file and fetch the row where 2nd column = 'HUB'
Can any one help me with this...
Thanks (1 Reply)
Discussion started by: manmeet
1 Replies
3. Shell Programming and Scripting
Hi all,
Im stuck in findind solution to ths problem. Please guide me if u have any ideas.
I have two files.
===FILE1===
>bi|2138271|geb|AAC15885.1|precursor
MRVIAAAMLYLYIVVLAICSVGIQGIDYPSVSFNLAGAKSATWDFLRMPHDLVGEDNKYNDGEPITGNII... (25 Replies)
Discussion started by: smriti_shridhar
25 Replies
4. Shell Programming and Scripting
111111111100000000001111111111
123232323200000010001114545454
232435424200000000001232131212
342354234301000000002323423443
232435424200000000001232131212
2390898994200000000001238908092
This is the record format.
From 11th position to 20th position in a record there are 0's occuring,and... (6 Replies)
Discussion started by: mjkreddy
6 Replies
5. Programming
hey i'm new at this stuff. i need to write a program in windows. which will fetch files from a unix machine using xshell. please help me with this. (4 Replies)
Discussion started by: tan_army810
4 Replies
6. Shell Programming and Scripting
Hi Freinds ,
I have 2 files .
File 1
|nag|HYd|1|Che
|esw|Gun|2|hyd
|pra|bhe|3|hyd
|omu|hei|4|bnsj
|uer|oeri|5|uery
File 2
|nag|HYd|1|Che
|esw|Gun|2|hyd
|uer|oi|3|uery
output : (9 Replies)
Discussion started by: i150371485
9 Replies
7. Shell Programming and Scripting
Hi All,
I have below directory structure and from these directories, I would like to fetch the last two days list of directories and append a '0' (zero) to those directories.
bash-4.1$ ls -lrt
total 32
drwxr-xr-x+ 6 root root 9 Sep 5 01:05 tested-597
drwxr-xr-x+ 6 root root 9 Sep 9... (3 Replies)
Discussion started by: ibad_urs
3 Replies
8. Shell Programming and Scripting
Hi All
I have a requirement like below.I have always 12 files got generated in my directory called /xx/out/
abc_2014_10_121.xml
abc_2014_09_345.xml
abc_2014_08_432.xml
abc_2014_07_123.xml
abc_2014_06_098.xml
abc_2014_05_569.xml
abc_2014_04_430.xml
abc_2014_03_235.xml
abc_2014_02_056.xml... (9 Replies)
Discussion started by: chigurupati.dwh
9 Replies
9. Shell Programming and Scripting
Hi All,
I have a requirement to extract para in XML file on the basis of another list file having specific parameters.
I will extract these para from XML and import in one scheduler tool.
file2
<FOLDER DATACENTER="ControlMserver" VERSION="800" PLATFORM="UNIX" FOLDER_NAME="SH_AP_INT_B01"... (3 Replies)
Discussion started by: looney
3 Replies
10. Shell Programming and Scripting
Hello team,
I have a directory containing huge number of files.
I need to go select last 5 files and read it to do a calculation.
Kindly guide, how can i achieve it.
Regards,
Sadique (13 Replies)
Discussion started by: sadique.manzar
13 Replies
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)