CODEWITHSUNDEEP
csvterminallibreoffice-calc
mao2047
mao2047

Reputation: 101

create a calc spreadsheet containing a list of documents

I need to create a spreadsheet containing a file list. I have a lot of PDF files, ordered like following example:

"Abbagnano, Nicola - Historia de la Pedagogía.pdf"
"Abbagnano, Nicola - Introduccion Al Existencialismo.pdf"
"Abbagnano, Nicola - La Evolucion de la Dialectica.pdf"
"Adorno, Theodor - Educacion Para la Emancipacion.pdf"
"Adorno, Theodor - Escritos Filosoficos Tempranos.pdf"
etc...

I want a list looking like this

   A        |  B      |   C 
Abbagnano | Nicola  | Historia de la Pedagogía
Abbagnano | Nicola  | Introduccion Al Existencialismo
Abbagnano | Nicola  | La Evolucion de la Dialectica
Adorno    | Theodor | Educacion Para la Emancipacion
Adorno    | Theodor | Escritos Filosoficos Tempranos

Upvotes: 0

Views: 39

Answers (1)

pnuts
pnuts

Reputation: 59475

To convert the former into the latter where the former is already in a ColumnA in LibreOffice:

Select ColumnA, Data > Text to Columns, check Comma and add - to Other for Separated by under Separator Options (others unchecked) and Text delimiter ", OK.

Then OK again, select ColumnC and Edit > Find & Replace, Find: .pdf (leave Replace: blank), Replace All, Close. Save As... Text CSV (.csv)(*.csv).

Upvotes: 1

Related Questions