12-22-2008
That is not the same as what you asked for in the original post.
Try any of the solutions in the search below, any of the awk options will work, and all you will have to do is update the print/prtinf formatting:
Search "transpose" on UNIX.COM
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have some text data generated by a perl script and want to put it into an excel sheet. Is there a perl script that can do this for me, i.e, convert text data to excel? (1 Reply)
Discussion started by: Pavankk
1 Replies
2. UNIX for Advanced & Expert Users
Hello All,
I have a sql report with 50 columns and 1000 rows result in a file ( txt / csv). is there is any way that we can move them to excel in KSH.
Thanks,
Sateesh (7 Replies)
Discussion started by: kotasateesh
7 Replies
3. UNIX for Dummies Questions & Answers
Hello Gurus,
I have a text file containing nearly 12,000 tab delimited characters with 4000 rows. If the file size is small, excel can convert the text into coloumns. However, the file that I have is very big. Can some body help me in solving this problem?
The input file example,
... (6 Replies)
Discussion started by: Unilearn
6 Replies
4. 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
5. Shell Programming and Scripting
Hi all,
I need to find a way to convert excel file into csv or a text file in linux command. The reason is I have hundreds of files to convert. Another complication is the I need to delete the first 5 lines of the excel file before conversion.
so for instance
input.xls
description of... (6 Replies)
Discussion started by: johnkim0806
6 Replies
6. Shell Programming and Scripting
Dear Users , Need to convert delimited text files in UNix server to an Excel file and move the excel file to Windows environment. Am trying to automate the whole process. Can anyone share the ideas,if they have done similar ones before...Thanks -Meera (1 Reply)
Discussion started by: meerakrish
1 Replies
7. Shell Programming and Scripting
:cool:Hi, Iam new to this Scripts and forum too. Plz excuse if may i ask silly questions now and further..
Prob: i need to convert txt files data into excel sheet. Suppose if i have hour-wise data in txt file1 and file2 like
file1 file2
00: 140 00: 235
01: 160 01:415... (1 Reply)
Discussion started by: mrudula
1 Replies
8. Shell Programming and Scripting
Hi Everyone,
I want your help to write a script which will take text file as input and on the basis of delimiter ":"script will create excel sheet.
Example input:
IpAdress:InstanceName:Port:ServerName
10.255.255.1:abc:2232:xyz_abc
Output should be an excel sheet like below:
Column... (8 Replies)
Discussion started by: akabhinav18
8 Replies
9. UNIX for Beginners Questions & Answers
Hi
i have a problem in my job
i try to convert an excel file (xls extention) to text file (tab delimited), but no result with this comand
cat xxx.xls > xxx.txt
Do you have eny idea?
PS: sorry for my english
Thanks!! (4 Replies)
Discussion started by: frisso
4 Replies
10. UNIX for Beginners Questions & Answers
Hi.
I need an input file of a single word pr. line converted in into a list of random pairs.
i need input like this
word1
word2
word3
word4
to be outputted like this:
word3 word1
word2 word4
My attempt is a tedious while loop like this:
nfiles=$(cat inputfile | wc -l) ... (4 Replies)
Discussion started by: BotHead
4 Replies
LEARN ABOUT DEBIAN
webservice::musicbrainz::track
WebService::MusicBrainz::Track(3pm) User Contributed Perl Documentation WebService::MusicBrainz::Track(3pm)
NAME
WebService::MusicBrainz::Track
SYNOPSIS
use WebService::MusicBrainz::Track;
my $ws = WebService::MusicBrainz::Track->new();
my $response = $ws->search({ TITLE => 'Same in any language' });
my $track = $response->track(); # grab the first one from list
print $track->title(), " - ", $track->artist()->name(), "
";
# OUTPUT: Same In Any Language - I Nine
DESCRIPTION
This module is used to search the MusicBrainz database about track information.
METHODS
new()
This method is the constructor and it will call for initialization.
query()
This method will return the cached WebService::MusicBrainz::Query object.
search()
This method will search the MusicBrainz database about track related information. The only argument is a hashref to define the search
parameters.
my $ws = WebService::MusicBrainz::Track->new();
$ws->search({ TITLE => 'when the stars go blue' });
$ws->search({ TITLE => 'blue', OFFSET => 100 });
$ws->search({ ARTIST => 'Ryan Adams', TITLE => 'when the stars go blue' });
$ws->search({ RELEASE => 'Gold', TITLE => 'when the stars go blue' });
$ws->search({ DURATION => 200000, TITLE => 'when the stars go blue' });
$ws->search({ TRACKNUM => 7, TITLE => 'when the stars go blue' });
$ws->search({ ARTISTID => 'c80f38a6-9980-485d-997c-5c1a9cbd0d64', TITLE => 'when the stars go blue' });
$ws->search({ RELEASEID => '433adbc2-382f-4f3a-9ce9-401f221f5b3b', TITLE => 'when the stars go blue' });
$ws->search({ LIMIT => 5, TITLE => 'when the stars go blue' });
$ws->search({ MBID => 'bd08eddf-b811-4653-b56b-892292c291bc', INC => 'artist' });
$ws->search({ MBID => 'bd08eddf-b811-4653-b56b-892292c291bc', INC => 'releases' });
$ws->search({ MBID => 'bd08eddf-b811-4653-b56b-892292c291bc', INC => 'puids' });
$ws->search({ MBID => 'bd08eddf-b811-4653-b56b-892292c291bc', INC => 'artist-rels' });
$ws->search({ MBID => 'bd08eddf-b811-4653-b56b-892292c291bc', INC => 'release-rels' });
$ws->search({ MBID => 'bd08eddf-b811-4653-b56b-892292c291bc', INC => 'track-rels' });
$ws->search({ MBID => 'bd08eddf-b811-4653-b56b-892292c291bc', INC => 'url-rels' });
Multiple INC params can be delimited by whitespace, commas, or + characters.
$ws->search({ MBID => 'bd08eddf-b811-4653-b56b-892292c291bc', INC => 'artist url-rels' });
$ws->search({ MBID => 'bd08eddf-b811-4653-b56b-892292c291bc', INC => 'artist,url-rels' });
$ws->search({ MBID => 'bd08eddf-b811-4653-b56b-892292c291bc', INC => 'artist+url-rels' });
AUTHOR
Bob Faist <bob.faist@gmail.com>
COPYRIGHT AND LICENSE
Copyright 2006-2007 by Bob Faist
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
http://wiki.musicbrainz.org/XMLWebService
perl v5.10.1 2009-12-06 WebService::MusicBrainz::Track(3pm)