โ02-19-2019 07:00 PM
I have a file called โFile With Spaces.csvโ and am trying to create a GLOB pattern to match it in a Director Browser.
What should work does not work and what does work is not optimal in my opinion.
Simply setting the File Filter to the value: File With Spaces.csv
returns 0 documents.
Setting the filter to: File?With?Spaces.csv
returns 0 documents.
Setting the filter to: File*With*Spaces.csv
returns the 1 document.
The fact that it will not match the exact file name is perplexing.
The fact that โ?โ has no effect is perplexing as well.
At least โ*โ works, but I find that pattern problematic and should not be necessary.
I can find no where in the documentation that spaces require special handling.
Anyone know of solution that does not require the use of โ*โ for this?
TK
โ02-19-2019 07:30 PM
Actually it looks like using %20 works for the space character matching.
Perhaps it has to do with the fact that I am browsing an SFTP directory?
Seems reasonable but kind of violates the Principal of Least Surprise.
TK
โ02-19-2019 07:44 PM
Try enabling expressions by clicking the โ=โ button and entering the name of the file within quotes: โFile With Spaces.csvโ.
That should do the trick.
โ02-19-2019 08:39 PM
Hi Rakesh,
โFile With Spaces.csvโ does not work either, but using โFile%20With%20Spaces.csvโ does the trick.
File???With???Spaces.csv also does the trick (as quoted expression or not), so it is clear now that it has to do with the encoding from the sftp server.
TK