topic Pick File Question in Discussions

Pick File Question

marktaylor — Fri, 22 May 2020 17:21:44 GMT

This is my first time posting here so I apologize if I'm posting in the wrong place. I wondered if anyone can help with the following. Is it possible to get only the file path part from the Pick File function.

If I write(names); I get {"/C:/Users/MT/file1.txt", "/C:/Users/MT/file1.txt"} but I would like just the path C:/Users/MT/ and to be associate that with a variable e.g. file_path = "C:/Users/MT/"

Thanks, Mark

names = Pick File(
"Select Data File",
"$DESKTOP",
{"Text Files|txt;csv", "All Files|*"},
1,
0,
"Data",
multiple
);

the

Re: Pick File Question

Mark_Bailey — Fri, 22 May 2020 17:32:20 GMT

You could use the Pick Directory() function instead. Then use Files In Directory() function with the returned path to get the list of files.

Re: Pick File Question

Wendy_Murphrey — Fri, 22 May 2020 18:15:59 GMT

I like the solution suggested by @Mark_Bailey best. But here is another possibility that uses character functions to extract the file path.

path = Substr( names[1], 1, Contains( names[1], "/", -1 ) );

Re: Pick File Question

marktaylor — Fri, 22 May 2020 20:23:06 GMT

Thanks Wendy, that works except for there's a leading slash so I get "/C:/Users/MT/" instead of "C:/Users/MT/".
I'm not sure where this leading / is coming from or how to get rid of it

Re: Pick File Question

marktaylor — Fri, 22 May 2020 20:24:00 GMT

Thanks Mark. Much appreciated

Re: Pick File Question

Wendy_Murphrey — Fri, 22 May 2020 20:29:30 GMT

In the Substr() function, just change the starting location to 2 and subtract one from the count.

path = Substr( names[1], 2, Contains( names[1], "/", -1 ) - 1 );

Re: Pick File Question

marktaylor — Fri, 22 May 2020 20:33:10 GMT

Thank you so much Wendy. That worked just great.