faithless1
asked on
Data to XML
Hi,
I'm looking for a way to convert a list of domain lists to XML format.
Example:
domain.com number number number number
domain.com number number number number
domain.com number number number number
domain.com number number number number
domain.com number number number number
domain.com number number number number
Desired Output:
<tr class="gradeA">
<td>domain</td>
<td>number</td>
<td>number</td>
<td class="center">number</td>
<td class="center">number</td>
</tr>
<tr class="gradeA">
<td>domain</td>
<td>number</td>
<td>number</td>
<td class="center">number</td>
<td class="center">number</td>
</tr>
<tr class="gradeA">
<td>domain</td>
<td>number</td>
<td>number</td>
<td class="center">number</td>
<td class="center">number</td>
</tr>
<tr class="gradeA">
<td>domain</td>
<td>number</td>
<td>number</td>
<td class="center">number</td>
<td class="center">number</td>
</tr>
Thank you
I'm looking for a way to convert a list of domain lists to XML format.
Example:
domain.com number number number number
domain.com number number number number
domain.com number number number number
domain.com number number number number
domain.com number number number number
domain.com number number number number
Desired Output:
<tr class="gradeA">
<td>domain</td>
<td>number</td>
<td>number</td>
<td class="center">number</td>
<td class="center">number</td>
</tr>
<tr class="gradeA">
<td>domain</td>
<td>number</td>
<td>number</td>
<td class="center">number</td>
<td class="center">number</td>
</tr>
<tr class="gradeA">
<td>domain</td>
<td>number</td>
<td>number</td>
<td class="center">number</td>
<td class="center">number</td>
</tr>
<tr class="gradeA">
<td>domain</td>
<td>number</td>
<td>number</td>
<td class="center">number</td>
<td class="center">number</td>
</tr>
Thank you
awk 'print awk '{print "<tr class=\"gradeA\">\n<td>"$1 "</td>\n<t d>"$2"</td >\n<td>"$3 "</td>\n<t d class=\"center\">"$4"</td> \n<td class=\"center\">"$5"</td> "}'
awk '{print "<tr class=\"gradeA\">\n<td>"$1 "</td>\n<t d>"$2"</td >\n<td>"$3 "</td>\n<t d class=\"center\">"$4"</td> \n<td class=\"center\">"$5"</td> "}'
#!/usr/bin/python
import sys
for line in open(sys.stdin):
domain, n1, n2, n3, n4 = line.split()
print '''\
<tr class="gradeA">
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td class="center">%s</td>
<td class="center">%s</td>
</tr>
''' % (domain.rsplit('.', 1)[0], n1, n2, n3, n4)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
.com not cut away :)
perl -ane '$F[0]=~s/\.com$//;printf q( <tr class="gradeA">
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td class="center">%s</td>
<td class="center">%s</td>
</tr>
),@F'
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td class="center">%s</td>
<td class="center">%s</td>
</tr>
),@F'