Splitting a field and using part of the split result

[Paul_Christie]

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.

 

[Bill Szysz]

Hi Paul
Try something like this

try Text.Split([Folder Path], "\"){2} otherwise "not exist"

Regards

 

[Paul_Christie]

Bill,

Thanks for that, does exactly what I wanted. It's all in the syntax.

Paul