PDA

View Full Version : Splitting a field and using part of the split result



Paul_Christie
2016-11-14, 10:53 AM
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
2016-11-14, 11:03 AM
Hi Paul
Try something like this

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

Regards

Paul_Christie
2016-11-14, 11:26 AM
Bill,

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

Paul