Power Query start at second instance of delimiter

[btwice]

I'm trying to pull a set of numbers after a delimiter using "_1" as a delimiter, but in some values in the data this delimiter shows up one time before the one that I want to pull from. How would I use an if statement to do something like below:

if delimiter("_1") > 0 then start at delimiter("_1") position 1 (second instance) else start at delimiter("_1") position 0 (first instance)

Appreciate any help, thanks.

 

[ExcelToDAX]

Can you post some data for an example please?

 

[btwice]

Sure, see below. Notice rows 4-6 can't pull the "Notification" out as it sees WEIMAR_1101, and I'm using _1 as a delimiter.

Book1
	A	B	C	D	E	F	G	H	I	J
1	Vendor	Name	Date modified	Date created	Folder Path	Order	Notification	Package type	Order_Vendor	Order_Notification
2	Vendor	NB_town_45564190_118977199_vendor_KAA_RFP_22Mar24	45373	45373		45564190	118977199	RFP_	45564190_Edison	45564190_118977199
3	Vendor	NB_town_45564215_118978175_vendor_KAA_RFP_22Mar24	45373	45373		45564215	118978175	RFP_	45564215_Edison	45564215_118978175
4	Vendor	SI_WEIMAR_1101_31686873_124052853_2AA_Contractor_ConPkgComp	45373	45373		31686873		ConP	31686873_MEGA
5	Vendor	SI_WEIMAR_1101_31686736_126433769_2AA_Contractor_PreFieldPkg	45373	45373		31686736		PreF	31686736_MEGA
6	Vendor	SI_WEIMAR_1101_31686437_121497058_2AA_Contractor_PreFieldPkg	45373	45373		31686437		PreF	31686437_MEGA
Sheet1

 

[ExcelToDAX]

I believe you are trying to extract the 9 digits. I just recently answered a question on this website here.

You can add a Power Query column that extracts these 9 digits:

List.Select(Text.Split(
    Text.Select([Name],{"0".."9","_"}),"_"),(x)
    =>Text.Length(x)=9)

Got this from here.

 

[btwice]

Yes this works great it looks like, your answer to my other question probably works as well but I used a different method to get the result I needed. Appreciate the help!!