Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Mdigregorio
Regular Visitor

Find Record in Text Split list that starts with "U"

Working with a column in Excel that contains:

UA56551325295214354/U2/8414259/9906589-LINE36

 

Currently working with: =Text.Split([PO],"/") to create a List value.

 

Next step is to determine which record in the List starts with "U" and is a minimum of 14 characters long. Once identified show that value in cell.

 

Not sure how to continue.

 

Thank you in advance.

1 ACCEPTED SOLUTION
wdx223_Daniel
Super User
Super User

=List.Select(Text.Split([PO],"/"),each Text.StartsWith(_,"U") and Text.Length(_)>13){0}?

View solution in original post

2 REPLIES 2
Mdigregorio
Regular Visitor

Wdx, Thank you so much!

wdx223_Daniel
Super User
Super User

=List.Select(Text.Split([PO],"/"),each Text.StartsWith(_,"U") and Text.Length(_)>13){0}?

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.