I have the following sample data that I'm trying to parse a specific number field out of, but the problem is sometimes there's a different number of the same length of 7 digits that I don't want. I tried parsing by the 2 dashes, but then realized some of the valid data only has 1 dash. Is there some way to take into account that I only want to use data that contains "Need ARLO Number" but not include that phrase in the results? Field3Desired ResultNo_Cost_Center-Need_ARLO_Number--1036528-10474934_0_1689001_WW001036528No_Cost_Center-Need_ARLO_Number--1036569-10474975_0_1689001_WW001036569No_Cost_Center-Need_ARLO_Number-HDQ-1036687-10475093_0_1689001_WW001036687No_Cost_Center-Need_ARLO_Number--1036687-10475093_0_1689001_WW001036687No_Cost_Center_WW00-7409101nullNo_Cost_Center_WW00-7301181nullNo_Cost_Center_WW00-7409101--No_ARLO_NumbernullNo_Cost_Center-Need_ARLO_Number--1036503-10474909_0_1689001_WW001036503

RegEx Parse formula needed when more than 1 numeric field of same length exists

I have the following sample data that I'm trying to parse a specific number field out of, but the problem is sometimes there's a different number of the same length of 7 digits that I don't want. I tried parsing by the 2 dashes, but then realized some of the valid data only has 1 dash. Is there some way to take into account that I only want to use data that contains "Need ARLO Number" but not include that phrase in the results?

Field3	Desired Result
No_Cost_Center-Need_ARLO_Number--1036528-10474934_0_1689001_WW00	1036528
No_Cost_Center-Need_ARLO_Number--1036569-10474975_0_1689001_WW00	1036569
No_Cost_Center-Need_ARLO_Number-HDQ-1036687-10475093_0_1689001_WW00	1036687
No_Cost_Center-Need_ARLO_Number--1036687-10475093_0_1689001_WW00	1036687
No_Cost_Center_WW00-7409101	null
No_Cost_Center_WW00-7301181	null
No_Cost_Center_WW00-7409101--No_ARLO_Number	null
No_Cost_Center-Need_ARLO_Number--1036503-10474909_0_1689001_WW00	1036503