Databases
StackOverflow2013
Postsdbo
POFiltering text file to get unique entries based on value in column 3
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POFiltering text file to get unique entries based on value in column 3
    primarykey
    data
    text
    <p>I know a bit of bash, but I am facing a problem to filter a file. I'll explain with an example : </p> <p><strong>Given a text file like the following (file1):</strong></p> <pre><code>10.10.12 bib24 Avenger goodone 10.10.12 bib21 The_Dark_Knight_Rises betterone 10.10.12 bib53 Avenger goodone 10.10.12 bib35 Ice_Age wow 11.10.12 bib53 TheAmazingSpiderMan nice 11.10.12 bib54 TheAmazingSpiderMan nice 11.10.12 bib01 Avenger goodone 12.10.12 bib29 Avenger goodone 12.10.12 bib11 TheAmazingSpiderMan nice 12.10.12 bib03 Ice_Age wow 12.10.12 bib98 Ice_Age wow 14.10.12 bib12 Ice_Age wow </code></pre> <p><strong>This is the result I want (file2):</strong> </p> <pre><code>10.10.12 bib24 Avenger goodone 10.10.12 bib21 The_Dark_Knight_Rises betterone 10.10.12 bib35 Ice_Age wow 11.10.12 bib53 TheAmazingSpiderMan nice </code></pre> <p><strong>So my question is :</strong> which command do I use to get this result (file2) ? (i.e. first entry of a movie, and not taking into account columns/fields 1, 2, and 4).</p> <p>I hope it's clear enough.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USdoubleDown
    1. USminutemaid
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POFiltering text file to get unique entries based on value in column 3
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POFiltering text file to get unique entries based on value in column 3
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POFiltering text file to get unique entries based on value in column 3
      1. This table or related slice is empty.
      1. VTUpMod
    1. COBut "Avenger goodone" is there 5 times ?! oO
      singulars
      1. POFiltering text file to get unique entries based on value in column 3
      1. USGilles Quenot
    2. COyes so what? see, it's at different times with different bib
      singulars
      1. POFiltering text file to get unique entries based on value in column 3
      1. USminutemaid
    3. COSorry, French frog have sometimes more difficulty to understand than people speaking English as mother tongue
      singulars
      1. POFiltering text file to get unique entries based on value in column 3
      1. USGilles Quenot
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload