Conversion of xhtml data into csv format using dump utility
Hi Unix Gurus,
I tried to convert the attached xhtml table content into csv file using unix shell script (lynx -dump filename) and got the below results:
Code:
Title ID Owner Priority Estimate Project Change Date Changed By
Complexity Create Date Created By Detail Estimate Total De tail
Estimate Done Feature Group Reference Source Split From Split From ID
Sprint Sprint State Status Story Status Team To Do Old ID Story Team
RR - Bug in m_tgt_fact_org_hierarchy mapping D-04980 Geraldraj S
elvaraj 3 - Could Have 5.00 2012 BI Project 05/23/2012 08:32 Sujith
Mukundan 10/21/2010 14:11 Karthik Iyengar 0.00 0.00 1.3 Ratings
Reporting Custom er Sprint 10 (10 -23 May) Closed Accepte d
RR New User - Password Reset B-38882 Geraldraj Selvaraj 1 - Must Have
3.00 2012 BI Project 02/01/2012 12:49 Administrator 08/12/2011 11:48
Rakesh Sinha 26.00 26.00 6.00 1.3 Ratings Reporting EU Compliance
Request - Counts Generation -ETL Analysis B-38881 Sprint 2 (19 Jan- 1
Feb) C losed Accepted
But I want the output as follows:
Row1:
Code:
Title,,ID,Owner,Priority,Estimate,Project,Change Date,Changed By,Complexity,Create Date,Created By,Detail Estimate,Total Detail Estimate,Done,Feature Group,Reference,Source,Split From,Split From ID,Sprint,Sprint State,Status,Story Status,Team,To Do,Old ID,Story Team
Row 2:
Code:
RR - Bug in m_tgt_fact_org_hierarchy mapping,,D-04980,Geraldraj Selvaraj,3 - Could Have,5.00,2012 BI Project,23/05/2012,Sujith Mukundan,,21/10/2010,Karthik Iyengar,0.00,0.00,,1.3 Ratings Reporting,,Customer,,,Sprint 10 (10 -23 May),Closed,Accepted,,,,,
Row 3:
Code:
RR New User - Password Reset,,B-38882,Geraldraj Selvaraj,1 - Must Have,3.00,2012 BI Project,01/02/2012,Administrator,,12/08/2011,Rakesh Sinha,26.00,26.00,6.00,1.3 Ratings Reporting,,,EU Compliance Request - Counts Generation -ETL Analysis,B-38881,Sprint 2 (19 Jan- 1 Feb),Closed,Accepted,,,,,
Could you please advice me if there is any option in dump utility to convert the html table content into above expected format? Or else please advise me any other method (unix script) to resolve this.
Hi,
Can any suggest me some utility to convert xhtml file to postscript file format?
Also tell me from where to down load such utility..
With Regards,
Dattatray (0 Replies)
Request if some one could provide me shell script that converts the below "input file" to "CSV format file" given
Name Domain Contact Phone Email Location
----------------------- ------------------------------------------------ ------- ----- ---------------------------------... (7 Replies)
INput file attached in thread : Column widths at 24,73,82,87,121 characters (sed 's/./,/24;s/./,/73;s/./,/81;s/./,/87;s/./,/121;s/ *, */,/g' fixedinputfile >output.csv
). The client wants instead of hard coding the column widths as they are not fixed .he has given the hint stating that ( ... (3 Replies)
Hi There
I need a script which will pick up the data from a .CSV file and reformat it as per the requirement and write it to another .CSV file.
I am using an application that will only take data in a particular format and need something that will convert without manual intervention.
The... (4 Replies)
Hi experts,
I want to convert a txt file having rows and columns (CNAI_DUMP_raw.txt) by comparing it with another text file (paramaters.txt) and generate a output in CSV which contains only 3rd column from CNAI_DUMP_raw.txt, and the columns mentioned in parameters.txt.
FYI: There are two... (16 Replies)
Hi all,
I am new here, please don't eat me alive..
I am trying to find a good community to learn and participate in unix / linux discussions to help me improve in my current job.
That being said, I have a problem which I didn't expect to challenge me, but I can't seem to find a viable... (8 Replies)
Dear Team,
please help me to solve this problem using Linux command. I want to dump this data into an excel sheet,
Suppose I have a string like:
ABC
PQR
XYZ
ASD
then I expect output as a
ABC XYZ
PQR ASD (3 Replies)