Sponsored Content
Full Discussion: Help with data formatting
Top Forums Shell Programming and Scripting Help with data formatting Post 302761579 by karumudi7 on Saturday 26th of January 2013 04:27:36 AM
Old 01-26-2013
IBM Help with data formatting

Hi,

I am generating the following output from my script.

Code:
Country,A,B,C,D,E,F
INDIA    ,3755019,774604,484749,329838,7333612,442031
CHINA       ,3716520,889197,530899,379754,6198475,355768
JAPAN       ,52038,30462,231224,147275,1272,498
USA,9494,1130,0,0,15303,451
UK,3680478,1085154,999262,645190,4453831,421336
CANADA      ,2,1,0,0,0,0
SINGAPORE         ,3548689,715416,1073298,733718,3520766,304011

I want to format this into html table code:

Code:
<table>
<tr><td>Country</td><td>A</td><td>B</td><td>C</td><td>D</td><td>E</td><td>F</td></tr>
<tr><td>INDIA    </td><td>3755019</td><td>774604</td><td>484749</td><td>329838</td><td>7333612</td><td>442031</td></tr>
<tr><td>CHINA       </td><td>3716520</td><td>889197</td><td>530899</td><td>379754</td><td>6198475</td><td>355768</td></tr>
<tr><td>JAPAN       </td><td>52038</td><td>30462</td><td>231224</td><td>147275</td><td>1272</td><td>498</td></tr>
<tr><td>USA</td><td>9494</td><td>1130</td><td>0</td><td>0</td><td>15303</td><td>451</td></tr>
<tr><td>UK</td><td>3680478</td><td>1085154</td><td>999262</td><td>645190</td><td>4453831</td><td>421336</td></tr>
<tr><td>CANADA      </td><td>2</td><td>1</td><td>0</td><td>0</td><td>0</td><td>0</td></tr>
<tr><td>SINGAPORE         </td><td>3548689</td><td>715416</td><td>1073298</td><td>733718</td><td>3520766</td><td>304011</td></tr>
</table>

Also Bold the first column (Country names) and first row (Column names).
But here I have to handle cases if the output from the initial script gives one more extra country.

I want to use this final output for UNIX mail command with HTML. So the body of the message will display a table for this.

Thanks.
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Formatting Data

i am writing a script that reads in a file and i just want it to print each element on a new line here is my code and the data that i want to read in #!/usr/bin/perl use strict; use CGI qw(:standard); use CGI qw(:cgi); my $data_file = "/tmp/results.txt"; my $configuration; my... (3 Replies)
Discussion started by: nmeliasp
3 Replies

2. Shell Programming and Scripting

Re-formatting of data display

Hi All, I have been trying to re-arrange the below data using AWK or Perl. Can anybody help me ? Thanks in advance. Input: 111 222 333 444 AAA BBB CCC DDD 555 666 777 888 EEE FFF GGG HHH Output: (6 Replies)
Discussion started by: Raynon
6 Replies

3. Shell Programming and Scripting

Script for data formatting

Hi I have to convert the data in a file ******* 01-20-09 11:14AM 60928 ABC Valuation-2009.xls 01-20-09 11:16AM 55808 DEF GHI Equation-2009.xls 01-20-09 11:02AM 52736 ABC DF Valuation-2009.xls 01-20-09 11:06AM 89600 THE... (6 Replies)
Discussion started by: shekhar_v4
6 Replies

4. UNIX for Dummies Questions & Answers

Data manipulation/ formatting question

How would I get this output to look $ cat newfile 13114 84652 84148 LIKE THIS?: 13114,84652,84148 sed,cut awk? syntax? (2 Replies)
Discussion started by: ddurden7
2 Replies

5. Shell Programming and Scripting

Formatting Data - CSV

I want to check whether if any column data has any + , - , = prefixed to it then convert it in such a form that in excel its not read as formula. echo "$DATA" | awk 'BEGIN { OFS="," } -F" " {print $1,$2,$3,$4,$5,$6,$7,$8.$9,$10,$11,$12}' (4 Replies)
Discussion started by: dinjo_jo
4 Replies

6. Shell Programming and Scripting

Formatting input data

Hello everybody, I have a file containing some statistics regarding CPU usage. The file has this syntax : Fri Jul 16 14:27:16 EEST 2010 Cpu(s): 15.2%us, 1.4%sy, 0.0%ni, 82.3%id, 0.1%wa, 0.0%hi, 0.9%si, 0.0%st Fri Jul 16 15:02:17 EEST 2010 Cpu(s): 15.3%us, 1.4%sy, 0.0%ni, 82.3%id, ... (9 Replies)
Discussion started by: spiriad
9 Replies

7. Shell Programming and Scripting

help with data formatting

Hi, I have data coming in like below. Not all data is like that, these are the problem records that is causing the ETL load to fail. Can you pls help me with combining theese broken records! 001800018000000guyMMAAY~acct name~acct type~~"address part 1 address... (8 Replies)
Discussion started by: varman
8 Replies

8. UNIX for Advanced & Expert Users

formatting the data

HI I want to make it single row if start with braces i.e. { .Any idea {1:XXX2460275191}{2:SEC00687921131112201641N}{3:{58910}}{4: :R:GENL :C::xx//xx1 :20C::yy//yy1 :2S:xxT} {1:XXX2460275190}{2:SEC00687921131112201641y}{3:{58911}}{4: :z:GENL :v::xx//xx1 :10C::yy//yy1 :4S:xxT ... (2 Replies)
Discussion started by: mohan705
2 Replies

9. Shell Programming and Scripting

Data formatting using awk

Need assistance on the data extraction using awk Below is the format and would like to extract the data in another format ------------------------------------------------------------------------------------------------- Minimum Temperature (deg F ) DAY 1 2 3 4 5 6 7 8 9 10 11... (4 Replies)
Discussion started by: ajayram_arya
4 Replies
GENDERGENDER(3) 							 1							   GENDERGENDER(3)

The GenderGender class

INTRODUCTION
CLASS SYNOPSIS
GenderGender GenderGender Constants o const integer$GenderGender::IS_FEMALE70 o const integer$GenderGender::IS_MOSTLY_FEMALE102 o const integer$GenderGender::IS_MALE77 o const integer$GenderGender::IS_MOSTLY_MALE109 o const integer$GenderGender::IS_UNISEX_NAME63 o const integer$GenderGender::IS_A_COUPLE67 o const integer$GenderGender::NAME_NOT_FOUND32 o const integer$GenderGender::ERROR_IN_NAME69 o const integer$GenderGender::ANY_COUNTRY0 o const integer$GenderGender::BRITAIN1 o const integer$GenderGender::IRELAND2 o const integer$GenderGender::USA3 o const integer$GenderGender::SPAIN4 o const integer$GenderGender::PORTUGAL5 o const integer$GenderGender::ITALY6 o const integer$GenderGender::MALTA7 o const integer$GenderGender::FRANCE8 o const integer$GenderGender::BELGIUM9 o const integer$GenderGender::LUXEMBOURG10 o const integer$GenderGender::NETHERLANDS11 o const integer$GenderGender::GERMANY12 o const integer$GenderGender::EAST_FRISIA13 o const integer$GenderGender::AUSTRIA14 o const integer$GenderGender::SWISS15 o const integer$GenderGender::ICELAND16 o const integer$GenderGender::DENMARK17 o const integer$GenderGender::NORWAY18 o const integer$GenderGender::SWEDEN19 o const integer$GenderGender::FINLAND20 o const integer$GenderGender::ESTONIA21 o const integer$GenderGender::LATVIA22 o const integer$GenderGender::LITHUANIA23 o const integer$GenderGender::POLAND24 o const integer$GenderGender::CZECH_REP25 o const integer$GenderGender::SLOVAKIA26 o const integer$GenderGender::HUNGARY27 o const integer$GenderGender::ROMANIA28 o const integer$GenderGender::BULGARIA29 o const integer$GenderGender::BOSNIA30 o const integer$GenderGender::CROATIA31 o const integer$GenderGender::KOSOVO32 o const integer$GenderGender::MACEDONIA33 o const integer$GenderGender::MONTENEGRO34 o const integer$GenderGender::SERBIA35 o const integer$GenderGender::SLOVENIA36 o const integer$GenderGender::ALBANIA37 o const integer$GenderGender::GREECE38 o const integer$GenderGender::RUSSIA39 o const integer$GenderGender::BELARUS40 o const integer$GenderGender::MOLDOVA41 o const integer$GenderGender::UKRAINE42 o const integer$GenderGender::ARMENIA43 o const integer$GenderGender::AZERBAIJAN44 o const integer$GenderGender::GEORGIA45 o const integer$GenderGender::KAZAKH_UZBEK46 o const integer$GenderGender::TURKEY47 o const integer$GenderGender::ARABIA48 o const integer$GenderGender::ISRAEL49 o const integer$GenderGender::CHINA50 o const integer$GenderGender::INDIA51 o const integer$GenderGender::JAPAN52 o const integer$GenderGender::KOREA53 Methods o public boolean GenderGender::connect (string $dsn) o public GenderGender::__construct ([string $dsn]) o public array GenderGender::country (integer $country) o public integer GenderGender::get (string $name, [integer $country]) o public array GenderGender::isNick (string $name0, string $name1, [integer $country]) o public array GenderGender::similarNames (string $name, [integer $country]) PREDEFINED CONSTANTS
o GenderGender::IS_FEMALE - o GenderGender::IS_MOSTLY_FEMALE - o GenderGender::IS_MALE - o GenderGender::IS_MOSTLY_MALE - o GenderGender::IS_UNISEX_NAME - o GenderGender::IS_A_COUPLE - o GenderGender::NAME_NOT_FOUND - o GenderGender::ERROR_IN_NAME - o GenderGender::ANY_COUNTRY - o GenderGender::BRITAIN - o GenderGender::IRELAND - o GenderGender::USA - o GenderGender::SPAIN - o GenderGender::PORTUGAL - o GenderGender::ITALY - o GenderGender::MALTA - o GenderGender::FRANCE - o GenderGender::BELGIUM - o GenderGender::LUXEMBOURG - o GenderGender::NETHERLANDS - o GenderGender::GERMANY - o GenderGender::EAST_FRISIA - o GenderGender::AUSTRIA - o GenderGender::SWISS - o GenderGender::ICELAND - o GenderGender::DENMARK - o GenderGender::NORWAY - o GenderGender::SWEDEN - o GenderGender::FINLAND - o GenderGender::ESTONIA - o GenderGender::LATVIA - o GenderGender::LITHUANIA - o GenderGender::POLAND - o GenderGender::CZECH_REP - o GenderGender::SLOVAKIA - o GenderGender::HUNGARY - o GenderGender::ROMANIA - o GenderGender::BULGARIA - o GenderGender::BOSNIA - o GenderGender::CROATIA - o GenderGender::KOSOVO - o GenderGender::MACEDONIA - o GenderGender::MONTENEGRO - o GenderGender::SERBIA - o GenderGender::SLOVENIA - o GenderGender::ALBANIA - o GenderGender::GREECE - o GenderGender::RUSSIA - o GenderGender::BELARUS - o GenderGender::MOLDOVA - o GenderGender::UKRAINE - o GenderGender::ARMENIA - o GenderGender::AZERBAIJAN - o GenderGender::GEORGIA - o GenderGender::KAZAKH_UZBEK - o GenderGender::TURKEY - o GenderGender::ARABIA - o GenderGender::ISRAEL - o GenderGender::CHINA - o GenderGender::INDIA - o GenderGender::JAPAN - o GenderGender::KOREA - PHP Documentation Group GENDERGENDER(3)
All times are GMT -4. The time now is 07:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy