Sponsored Content
Top Forums Shell Programming and Scripting how to convert fields from a text file to excel columns Post 302270722 by reborg on Monday 22nd of December 2008 04:17:13 PM
Old 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

convert Text to Excel

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

how to convert text/csv to excel

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

How to convert text to columns in tab delimited text file

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

Deleting all the fields(columns) from a .csv file if all rows in that columns are blanks

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

How to convert excel file to csv file or text file?

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

Need to convert delimited text file in UNIX to an Excel file

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

Need to convert text file into Excel sheet

: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

Need help to write a shell script to convert text file to excel file.

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

Convert Excel File (xls) to tab delimited text file on AIX

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

Convert text to columns

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
WWW::Search::Jobserve(3pm)				User Contributed Perl Documentation				WWW::Search::Jobserve(3pm)

NAME
WWW::Search::Jobserve - backend for searching www.jobserve.com SYNOPSIS
use WWW::Search; my $oSearch = new WWW::Search('Jobserve'); my $sQuery = WWW::Search::escape_query("(Fast Food Operative) and PERL"); $oSearch->native_query($sQuery, { job_category => 'it' }); while (my $oResult = $oSearch->next_result()) { print $oResult->url, " "; print $oResult->title, " "; print $oResult->description, " "; } DESCRIPTION
This class is a Jobserve specialisation of WWW::Search. It handles making, retrieving and interpreting Jobserve searches http://www.jobserve.com. This class exports no public interface; all interaction should be done through WWW::Search objects. NOTES
This class can be used to query both the UK and Australian Jobserve sites, see below. The search will terminate unless "job_category" is set in the native_query options. The results are ordered Best Match first (unless 'job_order' => 'DateTime' is specified). OPTIONS
Parameters Available: job_category job_type job_lookahead job_order jobserve_site Job Category Job Categories must be specified by setting "job_category" in the native_query options: $oSearch->native_query($sQuery, { job_category => 'it' }); The value of this is simply the prefix you see jobserve insert into the url once you've clicked beyond the front page. E.g. http://www.it.jobserve.com { job_category => 'it' } http://www.engineering.jobserve.com { job_category => 'engineering' } etc. Job Type Job Types are (Any|Contract|Permanent). To specifically search for one contract type, set 'job_type' => (*|C|P) to the query options: $oSearch->native_query($sQuery, { job_type => 'C', job_category => 'it' } ); The search defaults to "All" Days Ahead Choices of how many days to look ahead are (5|4|3|2|1|0). To specifically search for x working days ahead, set 'job_lookahead' => (5|4|3|2|1|0) to the query options: $oSearch->native_query($sQuery, { job_lookahead => '2', job_category => 'it' } ); The search defaults to 5 Result Order Choices of how to order results are (Best Match|Latest Job). To alter the result order, set 'job_order' => (Rank|DateTime) to the query options: $oSearch->native_query($sQuery, { job_order => 'DateTime', job_category => 'it' } ); The search defaults to "Best Match". Different Jobserve Sites There are currently two Jobserve websites supported by this module namely United Kingdom and Australia. The search will default to the UK site unless the parameter, 'jobserve_site' => (uk|au) is set in the query options: $oSearch->native_query($sQuery, { jobserve_site => 'au', job_category => 'it' } ); The search defaults to "uk" Invoke all parameters like so: $oSearch->native_query($sQuery, { job_category => 'it', job_type => 'C', job_lookahead => '2', job_order => 'DateTime', jobserve_site => 'au', } ); SEE ALSO
To make new back-ends, see WWW::Search. BUGS
Doubt it. Please tell me if you find any! Better still have a go at fixing them. AUTHOR
"WWW::Search::Jobserve" was written by Andy Pritchard (pilchkinstein@hotmail.com). "WWW::Search::Jobserve" is maintained by Andy Pritchard LEGALESE
THIS SOFTWARE IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. VERSION HISTORY
1.02 Altered parse_tree for cases where another href link is inserted before the job title and link 1.01 Altered POD and added a README 1.00 Released to the public. perl v5.12.4 2011-11-02 WWW::Search::Jobserve(3pm)
All times are GMT -4. The time now is 07:20 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy