LSD is a location format with Oil and Gas sector
I use dashes for visibility
Union - I would like to capture all the Asset Numbers for every match
Asset Number From LSD To LSD 1103787 06-08-043-01 W4 05-08-043-01 W4 1103743,1104288,5708836,5710469,1103815,1103819,1103775,1103785,1104325,110 4362 1103743 05-08-043-01 W4 08-07-043-01 W4 1103765,1103774,1103778,1103809,1104369 1103736 07-07-043-01 W4 03-07-043-01 W4 1103713,1103725,1103770,1103777,1103799,1103804,1103790,1103805,1102922 1103765 08-07-043-01 W4 07-07-043-01 W4 1103736,1103739,1103760,1103780,1103784,1103789,1103794,1104616
Yes, I know this may turn out to be a spider web.... I am doing this as a test and see where it will take me.
The chain will stop when the From = To or that the list is exhausted.