How to transform a table into a csv file using pup?

[stephane-archer]

I have the following input

<!-- a lot of html -->
<table>
<tr>
 <td>
  <p>
   data1
  </p>
 </td>
 <td>
  <p>
   data2
  </p>
 </td>
</tr>
<tr>
 <td>
  <p>
   data3
  </p>
 </td>
 <td>
  <p>
   data4
  </p>
 </td>
</tr>
<tr>
</table>
<!-- a lot of html -->

and I want the following output

data1 <separator> data2
data3 <separator> data4

Can I do this with pup?
pup.exe "table [magic display function]"

[Anshuman-bansal]

it is. not installing on mac i have go and hombrew both

[mazznoer]

@stephane-archer Using pup and jq.

file.html:

<table>
  <thead>
    <tr>
      <th>Last Digit</th>
      <th>Color</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>0</td>
      <td>black</td>
    </tr>
    <tr>
      <td>1</td>
      <td>red</td>
    </tr>
    <tr>
      <td>2</td>
      <td>green</td>
    </tr>
    <tr>
      <td>3</td>
      <td>yellow</td>
    </tr>
    <tr>
      <td>4</td>
      <td>blue</td>
    </tr>
    <tr>
      <td>5</td>
      <td>magenta</td>
    </tr>
    <tr>
      <td>6</td>
      <td>cyan</td>
    </tr>
    <tr>
      <td>7</td>
      <td>white</td>
    </tr>
  </tbody>
</table>

With commands:

pup -f file.html 'table tbody tr json{}' | jq '.[] | .children | "\(.[0].text),\(.[1].text)"' -r

We get:

0,black
1,red
2,green
3,yellow
4,blue
5,magenta
6,cyan
7,white

[MarceloAmigo]

or more easy:

pup -f file.html 'table tbody tr td:nth-last-of-type(n+2) text{}'  

for first case:

paste  <(pup -f file.html 'table tr td:first-child p text{}') <(pup -f file.html 'table tr td:last-child p text{}')