Hi

I have a csv file with lines that relate to each other purely by the order they appear in the file. So all the records with a record type "1" are the main record and the lines below with 2, 3, 4 or 5 record types relate the record above with the type 1. There could be any number of lines below and you only know when you get to a new record because you get a new record type 1. I would like to assign a new field with a common ID to the lines that refer to the same property. So in the first example the 8 lines would have a common ID and then the next 3 lines a different ID.

1 106 London road

2 Ground

2 Ground

2 First

1 104 London Road

2 Stores

3 Offices

1 Retail

4 Car Parking

Any help gratefully received.

Thanks

Ruth