for your prompt replies and my apologies for not providing sufficient information. Below is the whole file. Ideally, what I want to do is
(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)
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.