Splitting a field and using part of the split result

Paul_Christie

New member
Joined
Mar 23, 2016
Messages
153
Reaction score
0
Points
0
Location
Nottingham, UK
Website
www.instantpages.ltd.uk
Excel Version(s)
Office 365 Monthly update
Is there a way to pick up one of the values resulting from a Text.Split? I've used List.Count(Text.Split([Folder Path], "\")) to count the number of fields and I've worked out I want to pick up the value that is always the third value in the list. I know I could do it using a combination of Text.Mid and Text.PositionOf but being able to use the result of a Text.Split seems much more pleasing.
 
Back
Top