Using Regular Expressions...

[tenfoot]

Using Linux Mint v20.1 on Lenovo Thinkpad T450s.

I have downloaded from my local library a list of books I've read. The data is a text file in the following form

Code: Select all

Record 1 of 126
AUTHOR       Frame, Janet, author.
TITLE        Owls do cry : a novel / by Janet Frame.
PUB INFO     Christchurch, N.Z. : Pegasus Press ; London : Women's Press,
               1958.

I want to convert this to a csv file to insert into LibreOffice Calc. What would be the quickest way to delete the lines "AUTHOR...." and "PUB INFO..." please? After that is completed successfully I am quite happy to search for other characters and delete and/or replace with a comma, as necessary. The thought of having to select those two lines 126 times and press delete for each will take forever and a day

[Moonstone Man]

I want to convert this to a csv file ...

A single record likely won't be enough to deduce a proper pattern because of this:

...............1958. <-----

(dots replaced spaces at start to retain distance)

Why is it so? Because the line breaks then extends into a new line. Markers are needed as guides for any regex or perl script to cut the records ... because there is no evidence showing that you only want the TITLE line and the "Record 1 of 126" line, nor any evidence that the TITLE line does not also break like the line above.

You really need to provide additional information, and you need to be very clear about what is to be kept because your description neglects to deal with "Record 1 of 126", otherwise you're going to waste someone else's time when they make incorrect assumptions about you what you actually want.

[t42]

as asked "way to delete the lines "AUTHOR...." and "PUB INFO..."

Code: Select all

sed '/AUTHOR/d;/PUB\sINFO/d' -i your_file_name

[Moonstone Man]

as asked "way to delete the lines "AUTHOR...." and "PUB INFO..."

Code: Select all

sed '/AUTHOR/d;/PUB\sINFO/d' -i your_file_name

Yes, as asked, but I bet the city of London, England to half a house brick that what was asked is not what is wanted.

[t42]

@Kadaitcha Man - I think the same. Still, this will delete the lines with a year and dot in it

Code: Select all

sed '/[0-9][0-9][0-9][0-9]./d' your_file_name > new_file_name

It's easy to do the rest even in xed, such as empty lines or Record 1 of 126 pattern

[Flemur]

Using Linux Mint v20.1 on Lenovo Thinkpad T450s.

I have downloaded from my local library a list of books I've read. The data is a text file in the following form

Code: Select all

Record 1 of 126
AUTHOR       Frame, Janet, author.
TITLE        Owls do cry : a novel / by Janet Frame.
PUB INFO     Christchurch, N.Z. : Pegasus Press ; London : Women's Press,
               1958.

I want to convert this to a csv file to insert into LibreOffice Calc. What would be the quickest way to delete the lines "AUTHOR...." and "PUB INFO..." please?

Would that be the same as keeping only the TITLE lines? If so,

Code: Select all

grep TITLE your-file > new-file

will keep only the lines containing TITLE.

Edit: If you want to keep the Record lines, then it's still pretty easy:

Code: Select all

grep "Record " your-file | grep " of " > new1
grep TITLE your-file > new2
paste -d '\n' new1 new2 > new-file

...though that could mess up if you have some other line with the strings "Record " and " of ", e.g. a title like "Record of my travels". Then you can use some regular expressions to check for the numbers...

[tenfoot]

Thank you to Kadaitcha Man, t42, and Flemur for your prompt replies and my apologies for not providing sufficient information. Below is the whole file. Ideally, what I want to do is

(a) Remove the first line (Record <n> of <n>)
(b) Remove the 2nd line completely (AUTHOR etc)
(b) Remove the word TITLE on the 3rd line and change the colon and slash (: and /) to commas (I can do this be a simple Find and Replace)
(c) Remove the whole of the fourth line

I should then be able to type in the field names (Title, Surname,Firstname) on the first line and save the whole as a CSV file.

Code: Select all

Record 1 of 126
AUTHOR       Frame, Janet, author.
TITLE        Owls do cry : a novel / by Janet Frame.
PUB INFO     Christchurch, N.Z. : Pegasus Press ; London : Women's Press,
               1958.

Record 2 of 126
AUTHOR       Porter, Henry, 1953-
TITLE        A spy's life / Henry Porter.
PUB INFO     London : Orion, c2001.

Record 3 of 126
AUTHOR       Fry, Stephen, 1957-
TITLE        Making history / Stephen Fry.
PUB INFO     London : Hutchinson, c1996.

Record 4 of 126
AUTHOR       Frame, Janet.
TITLE        The Carpathians / Janet Frame.
PUB INFO     Auckland [N.Z.] : Century Hutchinson, 1988.

Record 5 of 126
AUTHOR       Pratchett, Terry, author.
TITLE        Wintersmith / Terry Pratchett.
PUB INFO     London : Corgi Books, 2017.
PUB INFO     ©2006.

Record 6 of 126
AUTHOR       Ryan, Chris, 1961-
TITLE        Blackout / Chris Ryan.
PUB INFO     London : Century, 2005.

Record 7 of 126
AUTHOR       Goddard, Robert, author.
TITLE        Sight unseen / Robert Goddard.
PUB INFO     London : Bantam, 2005.

Record 8 of 126
AUTHOR       Mankell, Henning, 1948-2015, author.
TITLE        Depths / Henning Mankell ; translated from the Swedish by Laurie 
               Thompson.
PUB INFO     London : Harvill Secker, 2006.

Record 9 of 126
AUTHOR       Yan, Geling.
TITLE        The banquet bug / Geling Yan.
PUB INFO     New York : Hyperion, [2006].

Record 10 of 126
AUTHOR       Robotham, Michael, 1960- author.
TITLE        The suspect / Michael Robotham.
PUB INFO     London : TimeWarner, 2004.

Record 11 of 126
AUTHOR       Ryman, Geoff.
TITLE        Air / Geoff Ryman.
PUB INFO     New York : St. Martin's Griffin, 2003.

Record 12 of 126
AUTHOR       Robotham, Michael, 1960-
TITLE        The night ferry / Michael Robotham.
PUB INFO     London : Sphere, c2007.

Record 13 of 126
AUTHOR       Browne, Marshall.
TITLE        Inspector Anders and the blood vendetta / Marshall Browne.
PUB INFO     Milsons Point, N.S.W. : Random House Australia, 2006.

Record 14 of 126
AUTHOR       Nobbs, David.
TITLE        Pratt à manger / David Nobbs.
PUB INFO     London : William Heinemann, 2006.

Record 15 of 126
AUTHOR       Bourne, Sam, 1967- author.
TITLE        The righteous men / Sam Bourne.
PUB INFO     London : HarperCollins, 2006.

Record 16 of 126
AUTHOR       Eggers, Dave.
TITLE        What is the what : the autobiography of Valentino Achak Deng : a 
               novel / Dave Eggers.
PUB INFO     San Francisco : McSweeney's, c2006.

Record 17 of 126
AUTHOR       Blake, Victoria.
TITLE        Cutting blades / by Victoria Blake.
PUB INFO     London : Orion Books, 2005.

Record 18 of 126
AUTHOR       Banks, Iain, 1954-2013.
TITLE        The steep approach to Garbadale / Iain Banks.
PUB INFO     London : Little, Brown, 2007.

Record 19 of 126
AUTHOR       Trevor, William, 1928-2016.
TITLE        Cheating at canasta / William Trevor.
PUB INFO     London : Viking, 2007.

Record 20 of 126
AUTHOR       Eriksson, Kjell, 1953-
TITLE        The cruel stars of the night / Kjell Eriksson ; translated from 
               the Swedish by Ebba Segerberg.
PUB INFO     New York : Thomas Dunne Books/St. Martin's Press, 2007.

Record 21 of 126
AUTHOR       Tolkien, Simon, 1959-
TITLE        The Final witness : a novel / Simon Tolkien.
PUB INFO     New York : Random House, 2003.

Record 22 of 126
AUTHOR       Fforde, Jasper.
TITLE        The fourth bear : a nursery crime / Jasper Fforde.
PUB INFO     New York : Penguin, 2006.

Record 23 of 126
AUTHOR       Connolly, John, 1968-
TITLE        The unquiet / John Connolly.
PUB INFO     London : Hodder & Stoughton, 2007.

Record 24 of 126
AUTHOR       Dexter, Colin, author.
TITLE        The remorseful day / Colin Dexter.
PUB INFO     London : Macmillan, 1999.

Record 25 of 126
AUTHOR       Arnaldur Indriđason, 1961-
TITLE        Voices / Arnaldur Indridason ; translated from the Icelandic by 
               Bernard Scudder.
PUB INFO     London : Harvill Secker, 2006.

Record 26 of 126
AUTHOR       Higgins, Jack, 1929-
TITLE        Toll for the brave / Jack Higgins.
PUB INFO     London : HarperCollins, 2004.

Record 27 of 126
AUTHOR       Brookmyre, Christopher, 1968- author.
TITLE        All fun and games until somebody loses an eye / Christopher 
               Brookmyre.
PUB INFO     London : Little Brown, 2005.

Record 28 of 126
AUTHOR       Kurkov, Andrei.
TITLE        Death and the penguin / Andrey Kurkov ; translated from the 
               Russian by George Bird.
PUB INFO     London : Harvill Press, 2001.

Record 29 of 126
AUTHOR       Leather, Stephen, author.
TITLE        Soft target / Stephen Leather.
PUB INFO     London : Hodder & Stoughton, 2005.

Record 30 of 126
AUTHOR       McGill, David.
TITLE        From my cold, dead hands / David McGill.
PUB INFO     Paekakariki, N.Z. : Silver Owl Press, 2007.

Record 31 of 126
AUTHOR       Gee, Maurice, author.
TITLE        The scornful moon : a moralist's tale / Maurice Gee.
PUB INFO     Auckland, N.Z. : Penguin, 2003.

Record 32 of 126
AUTHOR       Lawton, John, 1949-
TITLE        Riptide / John Lawton.
PUB INFO     London : Weidenfeld & Nicolson, 2001.

Record 33 of 126
AUTHOR       Britnell, Angela.
TITLE        A Smoky Mountain Christmas [large print] / Angela Britnell.
PUB INFO     Leicester : Thorpe, 2016.

Record 34 of 126
AUTHOR       Jacobs, Anna. author.
TITLE        Marrying Simone / Anna Jacobs.
PUB INFO     London : Allison & Busby, 2020.

Record 35 of 126
TITLE        John Hull, pioneer of Waiuku : his life and his legacy.
PUB INFO     [New Zealand] : Keith and Dorothy Dixon, 2017.

Record 36 of 126
AUTHOR       Heller, Mandasue, author.
TITLE        Save me / Mandasue Heller.
PUB INFO     London : Macmillan, 2017.

Record 37 of 126
AUTHOR       James, Peter, 1948-
TITLE        Need you dead / Peter James.
PUB INFO     London : Macmillan, c2017.

Record 38 of 126
AUTHOR       French, Nicci, author.
TITLE        The lying room / Nicci French.
PUB INFO     London : Simon & Schuster, 2019.

Record 39 of 126
AUTHOR       Horst, Jørn Lier, 1970- author.
TITLE        The Katharina code /​ Jørn Lier Horst ; translated by Anne
               Bruce.
PUB INFO     [London] : Michael Joseph, an imprint of Penguin Books, 2018.

Record 40 of 126
AUTHOR       MacBride, Stuart, author.
TITLE        All that's dead / Stuart MacBride.
PUB INFO     London, England : HarperCollins Publishers, 2019.

Record 41 of 126
AUTHOR       Rankin, Ian.
TITLE        Rather be the devil / Ian Rankin.
PUB INFO     London : Orion, c2016.

Record 42 of 126
AUTHOR       Robotham, Michael, 1960- author.
TITLE        The other wife / Michael Robotham.
PUB INFO     London : Sphere, 2018.

Record 43 of 126
AUTHOR       Robinson, Peter, 1950-, author.
TITLE        In the dark places : an Inspector Banks novel / Peter Robinson.
PUB INFO     New York, NY : William Morrow, 2015.

Record 44 of 126
AUTHOR       Roslund, Anders, 1961-
TITLE        Two soldiers / [Anders] Roslund & [Börge] Hellström ; translated 
               from the original Swedish by Kari Dickson.
PUB INFO     London : Quercus, 2013.

Record 45 of 126
AUTHOR       Spain, Jo, author.
TITLE        The confession / Jo Spain.
PUB INFO     London : Quercus, 2018.
PUB INFO     ©2018.

Record 46 of 126
AUTHOR       Templeton, Aline, author.
TITLE        Human Face / Aline Templeton.
PUB INFO     London : Allison & Busby , 2018.

Record 47 of 126
AUTHOR       Mackintosh, Clare, author.
TITLE        Let me lie / Clare Mackintosh.
PUB INFO     London : Sphere, an imprint of Little, Brown Book Group, 2018.

Record 48 of 126
AUTHOR       Masterton, Graham, author.
TITLE        Begging to die / Graham Masterton.
PUB INFO     London : Head of Zeus, 2019.

Record 49 of 126
AUTHOR       Cleave, Paul, 1974-
TITLE        The killing hour / Paul Cleave.
PUB INFO     Auckland [N.Z.] : Black Swan, 2007.

Record 50 of 126
AUTHOR       Fossum, Karin, 1954- author.
TITLE        The drowned boy / Karin Fossum ; translated from the Norwegian by
               Kari Dickson.
PUB INFO     London : Harvill Secker, 2015.
PUB INFO     ©2015.

Record 51 of 126
AUTHOR       French, Nicci, author.
TITLE        Saturday requiem / Nicci French.
PUB INFO     United Kingdom : Michael Joseph, an imprint of Penguin Books, 
               2016.
PUB INFO     ©2016.

Record 52 of 126
AUTHOR       Gray, Alex, author.
TITLE        The stalker / Alex Gray.
PUB INFO     London : Sphere, 2019.

Record 53 of 126
AUTHOR       Grey, Isabelle, author.
TITLE        Wrong way home / Isabelle Grey.
PUB INFO     London : Quercus, 2018.

Record 54 of 126
AUTHOR       Hawkins, Paula, author.
TITLE        Into the water / Paula Hawkins.
PUB INFO     London : Doubleday, 2017.

Record 55 of 126
AUTHOR       Holt, Anne, 1958- author.
TITLE        Dead joker / Anne Holt; Translated from the Norwegian by Anne 
               Bruce.
PUB INFO     London : Corvus, 2015.

Record 56 of 126
AUTHOR       Howard, Alex.
TITLE        Hard woman to kill / Alex Howard.
PUB INFO     London : Head Of Zeus, c2015.

Record 57 of 126
AUTHOR       French, Nicci, author.
TITLE        Sunday morning coming down / Nicci French.
PUB INFO     [London, England] : Michael Joseph, an imprint of Penguin Books, 
               2017.
PUB INFO     ©2017.

Record 58 of 126
AUTHOR       Jackson, David (Fiction writer) author.
TITLE        Don't make a sound / David Jackson.
PUB INFO     London : Zaffre, 2018.

Record 59 of 126
AUTHOR       Hannah, Mari, author.
TITLE        Killing for keeps / Mari Hannah.
PUB INFO     London : Macmillan, c2014.

Record 60 of 126
AUTHOR       Nesser, Håkan, 1950- author.
TITLE        The darkest day / Håkan Nesser. Translated from the Swedish by 
               Sarah Death.
PUB INFO     London : Mantle, 2017.

Record 61 of 126
AUTHOR       Koppel, Hans, 1964-
TITLE        You're mine now / Hans Koppel ; translated by Kari Dickson.
PUB INFO     London : Sphere, 2013.

Record 62 of 126
AUTHOR       James, Peter, 1948- author.
TITLE        Absolute proof / Peter James.
PUB INFO     London : Macmillan, 2018.

Record 63 of 126
AUTHOR       Kaaberbøl, Lene, author.
TITLE        The considerate killer / Lene Kaaberbol and Agnete Friis ; 
               translated from the Danish by Elisabeth Dyssegaard.
PUB INFO     New York : Soho Crime, [2016]
PUB INFO     ©2016.

Record 64 of 126
AUTHOR       Kent, Tony (Crime fiction writer), author.
TITLE        Marked for death / Tony Kent.
PUB INFO     London : Elliott & Thompson, 2019.

Record 65 of 126
AUTHOR       Knight, Renee, author.
TITLE        The secretary / Renée Knight.
PUB INFO     London : Doubleday, an imprint of Transworld Publishers, 2019.
PUB INFO     ©2019.

Record 66 of 126
AUTHOR       McCarthy, Rob, author.
TITLE        A handful of ashes  Rob McCarthy.
PUB INFO     London : Mulholland Books/Hodder, 2017.
PUB INFO     ©2017.

Record 67 of 126
AUTHOR       McCreanor, A. J., author.
TITLE        Riven / A.J. McCreanor.
PUB INFO     London : Constable, 2014.

Record 68 of 126
AUTHOR       Newham, Vicky, author.
TITLE        Out of the ashes / Vicky Newham.
PUB INFO     London : HQ, an imprint of HarperCollins Publishers, 2019.

Record 69 of 126
AUTHOR       MacBride, Stuart, author.
TITLE        Dark blood / Stuart MacBride.
PUB INFO     London : HarperCollins, 2010.

Record 70 of 126
AUTHOR       Bagley, Desmond, 1923-1983, author.
TITLE        Domino Island / Desmond Bagley ; curated by Michael Davies.
PUB INFO     London : HarperCollins Publishers, 2019.
PUB INFO     ©2019.

Record 71 of 126
AUTHOR       Candlish, Louise, author.
TITLE        Our house / Louise Candlish.
PUB INFO     London : Simon & Schuster UK Ltd, 2018.
PUB INFO     ©2018.

Record 72 of 126
AUTHOR       Cole, Daniel (Novelist), author.
TITLE        Hangman / Daniel Cole.
PUB INFO     London : Trapeze, 2018.

Record 73 of 126
AUTHOR       Callaghan, Tom, author.
TITLE        A spring betrayal / Tom Callaghan.
PUB INFO     London : Quercus, c2016.

Record 74 of 126
AUTHOR       Elton, Ben, author.
TITLE        Identity crisis / Ben Elton.
PUB INFO     London : Bantam Press, 2019.

Record 75 of 126
AUTHOR       Booth, Stephen, 1952-
TITLE        Dying to sin / Stephen Booth.
PUB INFO     London : HarperCollins, 2007.

Record 76 of 126
AUTHOR       Butler, D. S. (Novelist), author.
TITLE        Where secrets lie / D.S. Butler.
PUB INFO     Seattle : Thomas & Mercer, [2019]
PUB INFO     ©2019.

Record 77 of 126
AUTHOR       Edwardson, Åke, 1953-
TITLE        Sun and shadow / Åke Edwardson ; translated from the Swedish by 
               Laurie Thompson.
PUB INFO     New York : Viking, 2005.

Record 78 of 126
AUTHOR       Delaney, Luke.
TITLE        The Jackdaw / Luke Delaney.
PUB INFO     London : HarperCollinsPublishers, 2015.

Record 79 of 126
AUTHOR       Fortin, Sue, author.
TITLE        Schoolgirl missing / Sue Fortin.
PUB INFO     London : HarperCollins Publishers, 2019.

Record 80 of 126
AUTHOR       Brookmyre, Christopher, 1968-
TITLE        A snowball in hell / Christopher Brookmyre.
PUB INFO     London : Little, Brown, 2008.

Record 81 of 126
AUTHOR       Candlish, Louise, author.
TITLE        The other passenger / Louise Candlish.
PUB INFO     London : Simon & Schuster, 2020.

Record 82 of 126
AUTHOR       Dolan, Eva, author.
TITLE        Tell no tales / Eva Dolan.
PUB INFO     London : Harvill Secker, c2015.

Record 83 of 126
AUTHOR       Kernick, Simon, author.
TITLE        The bone field / Simon Kernick.
PUB INFO     London [England] : Century, 2017.
PUB INFO     ©2017.

Record 84 of 126
AUTHOR       Gray, Alex, author.
TITLE        Only the dead can tell / Alex Gray.
PUB INFO     London, England : Sphere, 2018.
PUB INFO     ©2018.

Record 85 of 126
AUTHOR       Fforde, Jasper, author.
TITLE        Early riser / Jasper Fforde.
PUB INFO     London, England : Hodder & Stoughton, 2018.
PUB INFO     ©2018.

Record 86 of 126
AUTHOR       Hill, Mark (Novelist), author.
TITLE        The bad place / M.K. Hill.
PUB INFO     London : Head of Zeus, 2019.

Record 87 of 126
AUTHOR       Hewitt, Jason, 1972- author.
TITLE        Devastation road / Jason Hewitt.
PUB INFO     London : Scribner, 2015.

Record 88 of 126
AUTHOR       Ohlsson, Kristina, 1979- author.
TITLE        Buried lies / Kristina Ohlsson ; translated by Neil Smith.
PUB INFO     London : Simon & Schuster, 2017.

Record 89 of 126
AUTHOR       Ridpath, Michael, author.
TITLE        The wanderer / Michael Ridpath.
PUB INFO     London : Corvus, an imprint of Atlantic Books Ltd., 2018.

Record 90 of 126
AUTHOR       Robotham, Michael, 1960- author.
TITLE        When she was good : a novel / Michael Robotham.
PUB INFO     New York : Scribner, 2020.

Record 91 of 126
AUTHOR       Robinson, Peter, author.
TITLE        Careless love / Peter Robinson.
PUB INFO     London : Hodder & Stoughton, 2018.

Record 92 of 126
AUTHOR       Rhodes, Kate.
TITLE        The winter foundlings / Kate Rhodes.
PUB INFO     London : Mulholland, 2014.

Record 93 of 126
AUTHOR       Callaghan, Tom, author.
TITLE        A summer revenge / Tom Callaghan.
PUB INFO     London : Quercus, 2017.

Record 94 of 126
AUTHOR       Edwardson, Åke, 1953-
TITLE        Death angels / Åke Edwardson ; translated from the Swedish by Ken
               Schubert.
PUB INFO     New York : Penguin Books, 2009.

Record 95 of 126
AUTHOR       Delaney, Luke.
TITLE        The keeper / Luke Delaney.
PUB INFO     London : HarperCollins, 2013.

Record 96 of 126
AUTHOR       Brookmyre, Christopher, 1968- author.
TITLE        Black Widow / Chris Brookmyre.
PUB INFO     London : Little, Brown, 2016.

Record 97 of 126
AUTHOR       Brookmyre, Christopher, 1968- author.
TITLE        The last hack : a Jack Parlabane thriller / Christopher
               Brookmyre.
PUB INFO     New York : Atlantic Monthly Press, 2017.

Record 98 of 126
AUTHOR       Butler, J. L. (Pseudonym), author.
TITLE        Mine / JL Butler.
PUB INFO     London : HarperCollins Publishers, 2018.

Record 99 of 126
AUTHOR       Bannister, Jo, author.
TITLE        Desperate measures / Jo Bannister.
PUB INFO     New York : Minotaur Books, 2015.
PUB INFO     ©2015.

Record 100 of 126
AUTHOR       Blackwell, Nathan, author.
TITLE        The sound of her voice : one cop's descent into darkness / Nathan
               Blackwell.
PUB INFO     [Auckland, New Zealand] : Mary Egan Publishing, 2017.

Record 101 of 126
AUTHOR       Arnaldur Indriðason, 1961- author.
TITLE        The shadow killer / Arnaldur Indriðason ; translated from the 
               Icelandic by Victoria Cribb.
PUB INFO     London : Harvill Secker, 2018.

Record 102 of 126
AUTHOR       Brookmyre, Christopher, 1968-
TITLE        When the devil drives / Christopher Brookmyre.
PUB INFO     London : Little, Brown, 2012.

Record 103 of 126
AUTHOR       Bussi, Michel, 1965- author.
TITLE        After the crash / Michel Bussi ; translated from the French by 
               Sam Taylor.
PUB INFO     London : Weidenfeld & Nicolson, 2015.
PUB INFO     ©2015.

Record 104 of 126
AUTHOR       Scragg, Robert, author.
TITLE        What falls between the cracks / Robert Scragg.
PUB INFO     London : Allison & Busby, 2018.

Record 105 of 126
AUTHOR       Staincliffe, Cath.
TITLE        The girl in the green dress / Cath Staincliffe.
PUB INFO     London : Constable, 2017.

Record 106 of 126
AUTHOR       Taylor, Abbie, author.
TITLE        The stranger on the train : a novel / Abbie Taylor.
PUB INFO     New York : Atria Paperback/Atria Books, 2014.
PUB INFO     ©2009.

Record 107 of 126
AUTHOR       Thomas, David, 1959- author.
TITLE        Ostland / David Thomas.
PUB INFO     London : Quercus, 2013.

Record 108 of 126
AUTHOR       Thomas, Russ, author.
TITLE        Firewatching / Russ Thomas.
PUB INFO     London : Simon & Schuster, 2020.

Record 109 of 126
AUTHOR       Thomson, Lesley, 1958- author.
TITLE        The detective's secret / Lesley Thomson.
PUB INFO     London : Head of Zeus, 2015.
PUB INFO     ©2015.

Record 110 of 126
AUTHOR       James, Peter, 1948- author.
TITLE        Find them dead / Peter James.
PUB INFO     London, England : Macmillan, 2020.
PUB INFO     ©2020.

Record 111 of 126
AUTHOR       Koch, Emily, author.
TITLE        If I die before I wake / Emily Koch.
PUB INFO     London : Harvill Secker, 2018.

Record 112 of 126
AUTHOR       Vaughan, Sarah, 1972- author.
TITLE        Anatomy of a scandal / Sarah Vaughan.
PUB INFO     London, England : Simon & Schuster, 2018.
PUB INFO     ©2018.

Record 113 of 126
AUTHOR       Lea, Wonny, author.
TITLE        Jack-knifed / by Wonny Lea.
PUB INFO     Abercynon : Accent Press, 2014, c2012.

Record 114 of 126
AUTHOR       Pearse, Lesley, author.
TITLE        Liar / Lesley Pearse.
PUB INFO     United Kingdom : Michael Joseph, an imprint of Penguin Books, 
               2020.

Record 115 of 126
AUTHOR       Taylor, C. L., 1973- author.
TITLE        The missing / C.L. Taylor.
PUB INFO     London : Avon, 2016.

Record 116 of 126
AUTHOR       Taylor, C. L., 1973-, author.
TITLE        The lie / C.L. Taylor.
PUB INFO     London : Avon, a division of HarperCollinsPublishers, 2015.
PUB INFO     ©2015.

Record 117 of 126
AUTHOR       Walsh, T. M. E. (Tania Michelle Elizabeth), author.
TITLE        The principle of evil / T.M.E. Walsh.
PUB INFO     London : HQ, 2017.
PUB INFO     ©2016.

Record 118 of 126
AUTHOR       Voss, Louise, author.
TITLE        The blissfully dead / Louise Voss & Mark Edwards.
PUB INFO     Seattle : Thomas & Mercer , [2015]
PUB INFO     ©2015.

Record 119 of 126
AUTHOR       Ford, Jaye, author.
TITLE        Darkest place / Jaye Ford.
PUB INFO     Sydney : Bantam, 2016.

Record 120 of 126
AUTHOR       Welsh, Louise, 1965- author.
TITLE        A lovely way to burn / Louise Welsh.
PUB INFO     London : John Murray, 2014.

Record 121 of 126
AUTHOR       Ware, Ruth, author.
TITLE        The turn of the key / Ruth Ware.
PUB INFO     New York : Scout Press, an imprint of Simon & Schuster, Inc., 
               2019.
PUB INFO     ©2019.

Record 122 of 126
AUTHOR       Brookmyre, Christopher, 1968- author.
TITLE        Places in the darkness / Chris Brookmyre.
PUB INFO     New York, NY : Orbit, 2017.

Record 123 of 126
AUTHOR       Edwards, Mark (Fiction writer), author.
TITLE        The devil's work / Mark Edwards.
PUB INFO     Seattle : Thomas & Mercer, 2016.
PUB INFO     ©2016.

Record 124 of 126
AUTHOR       Howard, Catherine Ryan, author.
TITLE        The liar's girl / Catherine Ryan Howard.
PUB INFO     London : Corvus, [2018]
PUB INFO     ©2018.

Record 125 of 126
AUTHOR       Follett, Ken, author.
TITLE        The evening and the morning / Ken Follett.
PUB INFO     London, England : Macmillan, 2020.

Record 126 of 126
AUTHOR       Callaghan, Tom author.
TITLE        An autumn hunting / Tom Callaghan.
PUB INFO     London, England : Quercus Editions Ltd,  [2018]
PUB INFO     ©2018.

It wil be appreciated if you would point out any errors in my logic, please?