Community

Thanks, I shall give it a go.

Many thanks, that worked really well.

So, how did it work and why will it not work for large files and what is a large file in this case?

I have some similar files that I will need to work on later that are upwards of 420,000 lines long. However, they use fixed lenght zone codes rather than ...

Sorry, yes there are lines with other place names - these are files of data from the 2001 census in Scotland, so there are netries for all the Council Areas -

Aberdeen City, Angus, Argyll & Bute, Clackmannanshire etc.

This file is 4608 lines long, I have many similar files, each with a slightly ...

I have lots of text files I need to bash into shape, in the format -

"Aberdeen City",2810,1663,196,82,215,547,107
"Aberdeen City",2806,1663,196,81,215,546,105
"Aberdeen City",250,46,20,21,89,45,29

etc etc

I need to keep the first "Aberdeen City" but remove all other occurences, to end with ...