08-17-2010
Hi durden_tyler,
Thanks Very Much but i have to use unix script for this ....could help me
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a text file like
----------------------
aaa|bbb|ccc|ddd|eee
fff|gggg|hhhhhh|kkkk
--------------------
I have a script which will transfer(thourgh FTP) this text file to windows system.
But I want to covert it into excel or CSF then upload into windows system..
thanks (9 Replies)
Discussion started by: srikanthus2002
9 Replies
2. Shell Programming and Scripting
Hello!
I need to sort a file that is partly in English partly in Bulgarian.
The original file is an Excel file but I converted it to a tab-delimited text file. The encoding of the tab delimited file is UTF-8.
To sort the text, the script should test every line of the text file to see if... (9 Replies)
Discussion started by: degoor
9 Replies
3. UNIX for Dummies Questions & Answers
Hi All,
I have to convert the excel file which will be placed in the Unix box to a CSV file using a shell script.
Please Advise.
Thanks & Regards,
Kumar66 (1 Reply)
Discussion started by: kumar66
1 Replies
4. Shell Programming and Scripting
Hi,
I am trying to attach and email a csv file in the form of an excel sheet.
And I have been successful in doing this.
But after some days I realised that some fields in the csv file are also having commas because of which this field is getting splitted in columns in the excel sheet.
... (5 Replies)
Discussion started by: girish1428
5 Replies
5. Shell Programming and Scripting
Hi,
I am new to scripting. I have a requirement
1.convert excel 2007 format to excel 2003 fromat
2.sort the excel file -( all columns in descending order).
This needs to be done progarmmatically. Please let me know what would be the possible steps that I would need to take inorder to... (2 Replies)
Discussion started by: eva13
2 Replies
6. UNIX for Advanced & Expert Users
Hi All,
i have a .Csv file in the below format
startTime, endTime, delta, gName, rName, rNumber, m2239max, m2239min, m2239avg, m100016509avg, m100019240max, metric3min, m100019240avg, propValues
11-Mar-2012 00:00:00, 11-Mar-2012 00:05:00, 300.0, vma3550a, a-1_CPU Index<1>, 200237463, 0.0,... (9 Replies)
Discussion started by: mahi_mayu069
9 Replies
7. Shell Programming and Scripting
Hi Friends,
I have come across some files where some of the columns don not have data.
Key, Data1,Data2,Data3,Data4,Data5
A,5,6,,10,,
A,3,4,,3,,
B,1,,4,5,,
B,2,,3,4,,
If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Discussion started by: ks_reddy
4 Replies
8. Shell Programming and Scripting
Hi,
I have a file of csv data, which looks like this:
file1:
1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628
2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Discussion started by: djoseph
10 Replies
9. UNIX for Beginners Questions & Answers
I have to sort the 4th column of an excel/csv file. I tried the following command
sort -u --field-separator=, --numeric-sort -k 2 -n dinesh.csv > test.csv
But, it's not working. Moreover, I have to do the same for more than 30 excel/csv file. So please help me to do the same. (6 Replies)
Discussion started by: dineshkumarsrk
6 Replies
LEARN ABOUT DEBIAN
prima::detailedlist
Prima::DetailedList(3) User Contributed Perl Documentation Prima::DetailedList(3)
NAME
Prima::DetailedList - a multi-column list viewer with controlling header widget.
SYNOPSIS
use Prima::DetailedList;
my $l = $w-> insert( 'Prima::DetailedList',
columns => 2,
headers => [ 'Column 1', 'Column 2' ],
items => [
['Row 1, Col 1', 'Row 1, Col 2'],
['Row 2, Col 1', 'Row 2, Col 2']
],
);
$l-> sort(1);
DESCRIPTION
Prima::DetailedList is a descendant of Prima::ListViewer, and as such provides a certain level of abstraction. It overloads format of items
in order to support multi-column ( 2D ) cell span. It also inserts Prima::Header widget on top of the list, so the user can interactively
move, resize and sort the content of the list. The sorting mechanism is realized inside the package; it is activated by the mouse click on
a header tab.
Since the class inherits Prima::ListViewer, some functionality, like 'item search by key', or "get_item_text" method can not operate on 2D
lists. Therefore, mainColumn property is introduced, that selects the column representing all the data.
API
Events
Sort COLUMN, DIRECTION
Called inside sort method, to facilitate custom algorithms of sorting. If the callback procedure is willing to sort by COLUMN index,
then it must call "clear_event", to signal the event flow stop. The DIRECTION is a boolean flag, specifying whether the sorting must be
performed is ascending ( 1 ) or descending ( 0 ) order.
The callback procedure must operate on the internal storage of "{items}", which is an array of arrays of scalars.
The default action is the literal sorting algorithm, where precedence is arbitrated by "cmp" operator ( see "Equality Operators" in
perlop ) .
Properties
columns INTEGER
Governs the number of columns in items. If set-called, and the new number is different from the old number, both items and headers are
restructured.
Default value: 0
headerClass
Assigns a header class.
Create-only property.
Default value: "Prima::Header"
headerProfile HASH
Assigns hash of properties, passed to the header widget during the creation.
Create-only property.
headerDelegations ARRAY
Assigns a header widget list of delegated notifications.
Create-only property.
headers ARRAY
Array of strings, passed to the header widget as column titles.
items ARRAY
Array of arrays of scalars, of arbitrary kind. The default behavior, however, assumes that the scalars are strings. The data direction
is from left to right and from top to bottom.
mainColumn INTEGER
Selects the column, responsible for representation of all the data. As the user clicks the header tab, "mainColumn" is automatically
changed to the corresponding column.
Default value: 0
Methods
sort [ COLUMN ]
Sorts items by the COLUMN index in ascending order. If COLUMN is not specified, sorts by the last specified column, or by #0 if it is
the first "sort" invocation.
If COLUMN was specified, and the last specified column equals to COLUMN, the sort direction is reversed.
The method does not perform sorting itself, but invokes Sort notification, so the sorting algorithms can be overloaded, or be applied
differently to the columns.
AUTHOR
Dmitry Karasik, <dmitry@karasik.eu.org>.
SEE ALSO
Prima, Prima::Lists, Prima::Header, examples/sheet.pl
perl v5.14.2 2009-02-24 Prima::DetailedList(3)