I'm really sorry to waste your time. The file I have is at work and I didn't want to do a straight copy and paste as I didn't want to put work data on the web.
However, the test data was rubbish which I used. I am sorry about that.
Here is some better test data which correctly shows what I was trying to do. My previous version was useless, I now realise.
Code: Select all
TESTQ-ABCDE 123/ABC123235234
TESTQ-3gdfdf 1 Contract Costs
TESTQ-ABCDE Some Text Here
TESTQ-32234 1 Other Text There
TESTQ-dfg75 This Says Something
TESTQ-ABCDE This Says Something Else
TESTQ-FSDFdfg 1 My Test Data
TESTQ-fsdf33 Going From One To Another
TESTQ-fgsdf34 Friday May 4th
TESTQ-dsf4dfy 1 Testing One Two Three
TESTQ-235fgh45 Ability Agility House
I'd like to search for those lines where there is a 1 after the first block of text - i.e. those marked with a * below:
Code: Select all
TESTQ-ABCDE 123/ABC123235234
* TESTQ-3gdfdf 1 Contract Costs
TESTQ-ABCDE Some Text Here
* TESTQ-32234 1 Other Text There
TESTQ-dfg75 This Says Something
TESTQ-ABCDE This Says Something Else
* TESTQ-FSDFdfg 1 My Test Data
TESTQ-fsdf33 Going From One To Another
TESTQ-fgsdf34 Friday May 4th
* TESTQ-dsf4dfy 1 Testing One Two Three
TESTQ-235fgh45 Ability Agility House
I could see that the find of ^TESTQ will find lines starting with "TESTQ" but then do not know how to skip the variable length block of text after the dash, to then be able to find the "1".
I hope that's clearer, and sorry for my mistake.