[Justin Niakamal]

Can you show the results of the following in your directory with the files:

filelist
keep if regexm(filename, "\\$")
dataex

[Calvin Chen]

Can you show the results of the following in your directory with the files:

filelist
keep if regexm(filename, "\\$")
dataex

. filelist
Number of files found = 2

. keep if regexm(filename, "\\$")
(1 observation deleted)

. dataex

----------------------- copy starting from the next line -----------------------


	
	
* Example generated by -dataex-. To install: ssc install dataex
clear
input str1 dirname str9 filename int fsize
"." "$ROPE.csv" 4761
end
------------------ copy up to and including the previous line ------------------

Listed 1 out of 1 observations

It's working

[Justin Niakamal]

Can you tell me what happens when you change directory to the file with $ROPE.csv and run this:

filelist, pattern(*ROPE.csv)

keep if regexm(filename, "\\$")
assert `=_N' == 1
replace filename = subinstr(filename, "$", "\\$", .)

local toread = filename[1]
import delimited using "`toread'", clear

[Calvin Chen]

Can you tell me what happens when you change directory to the file with $ROPE.csv and run this:

filelist, pattern(*ROPE.csv)

keep if regexm(filename, "\\$")
assert `=_N' == 1
replace filename = subinstr(filename, "$", "\\$", .)

local toread = filename[1]
import delimited using "`toread'", clear

. filelist, pattern(*ROPE.csv)
Number of files found = 1

. assert `r(N)' == 1

. replace filename = subinstr(filename, "$", "\\$", .)
variable filename was str9 now str10
(1 real change made)

.
. local toread = filename[1]

. import delimited using "`toread'", clear
file \.csv not found

I think we may meet the same problem here, still, the file is not found.

[Justin Niakamal]

Unfortunately, I can't reproduce what you're experiencing. The only thing I can suggest is updating your Stata (type update all in your Stata window) and running the code again.

filelist, pattern(*ROPE.csv)

keep if regexm(filename, "\\$")
assert `=_N' == 1
replace filename = subinstr(filename, "$", "\\$", .)

local toread = filename[1]
import delimited using "`toread'", clear
(12 vars, 74 obs)

note:

. filelist, pattern(*ROPE.csv)
Number of files found = 1

. list

     +-----------------------------+
     | dirname   filename    fsize |
     |-----------------------------|
  1. | .         $ROPE.csv   4,761 |
     +-----------------------------+

[Calvin Chen]

Unfortunately, I can't reproduce what you're experiencing. The only thing I can suggest is updating your Stata (type update all in your Stata window) and running the code again.

filelist, pattern(*ROPE.csv)

keep if regexm(filename, "\\$")
assert `=_N' == 1
replace filename = subinstr(filename, "$", "\\$", .)

local toread = filename[1]
import delimited using "`toread'", clear
(12 vars, 74 obs)

note:

. filelist, pattern(*ROPE.csv)
Number of files found = 1

. list

+-----------------------------+
| dirname filename fsize |
|-----------------------------|
1. | . $ROPE.csv 4,761 |
+-----------------------------+

I have just tried to install and uninstall and also tried everthing in another Mac computer, all the attempts failed. I use Stata 16 IC, can I know what version do you use?

Thank you very much for your help!

[Justin Niakamal]

I have just tried to install and uninstall and also tried everthing in another Mac computer, all the attempts failed. I use Stata 16 IC, can I know what version do you use?

Here's my info

. about

Stata/SE 16.1 for Mac (64-bit Intel)
Revision 03 Dec 2020
Copyright 1985-2019 StataCorp LLC

[Calvin Chen]

Here's my info

. about

Stata/SE 16.1 for Mac (64-bit Intel)
Revision 03 Dec 2020
Copyright 1985-2019 StataCorp LLC

Thank you very much for your replies. I even tried to install a Stata/SE, but still, it didn't work. However, I have just now figured it out, we can use macval() to pass the text as it is. I was literally working on this question for a whole day!
in this case, the code is

local all_file: dir . files"*.csv"
foreach f of local all_file {
    
    insheet using "`macval(f)'", clear
}

I hope it would help people who need it in the future.

Have a nice day.

[Justin Niakamal]

I didn't know about macval(), but that sure makes life easier! Thanks for sharing your solution.