Community

Cheers all, not only have I learnt a couple of different ways of doing the same thing, but also to think more about what I'm actually trying to achieve!

Cheers for that, a swift reply and did exactly as I needed.
Perfect! - Many thanks.

Chris

Hi, I seem to be missing a trick here. I have data that looks like this; 1204,Bill Cook, 1205,Dave Smith, 1208,Bill Cook, 1212,Sally Jones, 1211,Bill Cook, 1202,Dave Smith, Which I want to get looking like this; 1204,Bill Cook 1205,Dave Smith 1208,Bill Cook etc.. I can search using “[a-z]+, ...

Ben, that's absolutely bang on the money.
Many, many thanks!

I'm attempting to open an .mdi file in textpad, when I do I can see all the valid text that I want in page size chunks, seperated by all the special characters that conatin the .mdi formating. How can I go about marking either set of lines? I know that I want to identify all the lines that are only ...

Thanks for the response Marbx, unfortunately I don't use Perl, but cheers for the RegEx.

I have a file that has two columns and holds HR data, the first contains a reference for the department, the second holds a reference for the employee ie, Dept,Employee P0073,00064137 P0073,00101104 P0073,00003956 P0074,00100343 P0074,00046509 The file holds approx 9500 records for approx 25 ...