I once had a filelist user hit the limit with a directory that contained 18,000 files (that was with MP version 13). # of characters in a macro (2) 51,800 264,392 4,227,143So it's definitively a possibility, especially for those working with Small Stata. Loc subfiles: list local filesall - local files ******You can use 'filesA' or you can use 'files' & macro extended functions to produce a list you desire: **! Alternate ways to manipulate the lists : **FilesA is the macro you want to use for your loop/append/etc.ĭi `'`num2''' //# of files after processingĭi `'`=`num'-`num2'''' //# of files removed, check Loc filesA `'`=regexr(`'`filesA''', `'('*')'', `''')'''ĭi `'`files''' //list of non-target filesĭi `'`filesA''' //list of target files for inclusion in your processing *di `'`files''' //substitutes first instance for non-target filename pattern ****!n.b., run the commands below all together so that the locals are preservedĭi `'`num''' //# of files in list before processing **Now, use looping to remove targets or non-targets: L x y in 1 //lists first target and non-target **ex: using string expressions to find files: Loc files2 `'`=regexr(`'`files''', `'('*')'', 'OMIT')'''ĭi `'`files2''' //substitutes first instance for non-target filename pattern

Outsheet using `'TeSt_File_HERE.dat'', replace

Find word in file in directory