f2 is tx&test01.xlsx. The file that's there is tx&test02.xlsx.
Henry Rich
On 8/20/2012 6:18 PM, Bill Harris wrote:
fexist dir,f1
1
f1
txtest01.xlsx
fexist dir,f2
0
f2
tx&test01.xlsx
fdir dir,'*.xlsx'
┌──────────────────┬──────────────────┬──────┬───┬──────┐
│tx&test02.xlsx │2012 8 20 10 11 57│7978 │rw-│-----a│
├──────────────────┼──────────────────┼──────┼───┼──────┤
│txtest01.xlsx │2012 8 20 10 7 39 │7977 │rw-│-----a│
├──────────────────┼──────────────────┼──────┼───┼──────┤
9!:14''
j602/2008-03-03/16:45
Is there a way to work with "&" in file names in J? f2 is a copy of
f1, and Excel is happy with both files.
Interestingly,
dir,f1
b:/TopLevelDirectory/_Word1 & Word2/Bill
Harris/j602-user/projects/taraxmltest/txtest01.xlsx
IOW, the directory has an "&", and that's okay. It's just when it's
in the file name that it fails. (I did try putting spaces around the
"&" in the file name, but it didn't help.)
My real goal is to read another file that has an "&" in the file name
using taraxml, but I figure the same mechanism gives fexist and
readxlxsheets difficulty.
Bill
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
