Could pipe it into another awk that would re-order the column like
$3,$9,$1,$10,$5,$6,$8,$7,$4,$2... or something like that, but this would not be optimal.
I guess we should directly refer the expected element of array instead of doing a "for" loop to display.I just don't know whether it can handle such syntax :
We can not use a comma as a output field separator since some of the fields contain commas. I used a semicolon instead, which is fine for importing into Excel.
This produces:
What made it a bit more complex is that not all of the fields are present in every record.
The input file seemed to be a bit crooked, I used this as a basis, hope that is OK:
S.
Last edited by Scrutinizer; 10-19-2010 at 03:24 PM..
This User Gave Thanks to Scrutinizer For This Post:
I am very new to shell scripting.
I have a autosys jil file that looks like :--
/* ------------- JOB1 ------------------ */
insert_job: JOB1 job_type: b
owner: cm@pelonmuck
permission: gx,ge,wx,we,mx,me
date_conditions: 1
days_of_week: mo,tu,we,th,fr,su
start_time: "18:30"... (9 Replies)
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
<DIV><P>Pré-condição aceder ao ecrã Home do MRS.</P></DIV><DIV><P>OK.</P></DIV><DIV><P>Seleccionar Pesquisa de Recepção Directa.</P></DIV><DIV><P>Confirmar que abriu ecrã de Recepção Directa.</P></DIV><DIV> (6 Replies)
Hi ,
I have a jil file which i am trying to parse and print the job name and the condition corresponding to it.
Below is the input file
/* -------------------- testjob1 -------------------- */
insert_job: testjob1 job_type: c
machine: unix
owner: chidori
condition: s(joba) and... (9 Replies)
All,
I have an excel sheet Excel1.xls that has some entries.
I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls
These may be in different workbooks. They are totally independent made by 2 different users.
I have placed them in a... (1 Reply)
I am trying to create a program where user can input data in certain excel cells using user interface on internet....the programming is on perl and server is unix
But when i parse data into excel the formatting of sheets is turned to default and all macro coding removed.
What to do...Please... (7 Replies)
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)