I have found a couple of threads on this topic but I have been unable to really modify them to what i need.


I have a macro that i use to clean database files prior to import into SQL.

Untill now i have just loaded the files and run the Macro on "ALL FILES"

however we are now dealing with a few hundred files at a time.

IS there a way to make UE run our macro on all files within a folder?

i would prefer not having to create a UE project to do this.

i was thinking a command line batch file may work.

open UE
run XXX.mac on files *.*

But i have read that this is not posible due to auto macro and wildcards?

i am running UE 11.10a+1

Thanks in advance for any help


ps.

if i do have all the files listed in a project, how do i get a macro to run on entire project?......i think i sorted this part

Replace in files and select "Project Files" in "Select Where" option.

Replace In Files has no limits. You can run it on thousands of files each with several MBs or GBs.

Replace In Files does not support hexadecimal replaces except you use the Perl regular expression engine and appropriate search and replace string in hexadecimal notation. However, you can replace all bytes except a NULL byte (00) with Replace In Files too. You just have to use the ASCII/ANSI characters for the bytes you want to replace.


Here is a small macro which is able to run a macro on all files specified by you on startup.

It works only for non FTP files. (To be more precise, I have not tested it with FTP files.)

It works only for UltraEdit v10.20 or later and all versions of UEStudio. Without the first line it should work also for UltraEdit v9.10 and later, but then you have to run the Find In Files with an empty search string and with option Results to Edit Window checked manually.

If you use an UltraEdit version prior v12.00 or an UEStudio version prior v5.50 delete the command UnicodeToASCII from the macro code because those versions already create the Find In Files results window as ASCII file and not as Unicode file.

The conversion from Unicode to ASCII means also that the full file names of the project files cannot contain Unicode characters. I have not tested if this macro would also work without conversion from Unicode to ASCII.


Further the macro identifies the results window by the string "Search complete, found". This string exists at bottom of the results window only for English version of UltraEdit and only when Find Summary is still enabled and contains the default string at Advanced - Configuration - Search - Set Find Output Format depending on version of UltraEdit. If a localized version of UltraEdit is used, this search string must be modified to the localized string. With an unchecked Find Summary configuration setting the macro will not work because not able to identify the document window with the results.


The name of the called macro as written in the string "Name of your macro" is case sensitive. So make sure that you enter the macro name correct. Also this macro and your called macro must exist in the same macro file. It is not possible to call a macro stored in another macro file. And it is important to first create the called macro and then create this macro or UltraEdit would remove the line with the PlayMacro on close (compilation) because of the missing macro.


The macro property Continue if a Find with Replace not found or Continue if search string not found must be checked for this macro.

FindInFiles "directory" "file type" ""
Loop
Find MatchCase Up "Search complete, found"
IfFound
ExitLoop
Else
NextWindow
EndIf
EndLoop
DeleteLine
SelectToBottom
IfSel
Delete
EndIf
Top
UnicodeToASCII
Loop
IfEof
ExitLoop
EndIf
StartSelect
Key END
IfSel
Open "^s"
PlayMacro 1 "Name of your macro"
CloseFile Save
EndIf
EndSelect
DeleteLine
EndLoop
CloseFile NoSave

Thanks Mofi!

thats great

A few issues.

when referencing the Macro1, does it need to be in the same macro file as the source macro, or do i put the complete file path to the macro?

if i remove the "filetype" prompt at the start will it still work on all files?? most of the files we need this for don't actually have extensions.

so far i can get it to run and display "Search complete, found '' 0 time(s). (0 files.)" on the screen so i think it is having trouble finding the macro to run or trouble finding the file to search

i made very simple test macro which is just "find "PRD""

I also have a few test files with both *.txt extension and no extension. All files contain PRD in them.


Thanks again for the help, once i get it going, you'll have saved me hours and hours of tedium with this.

OK, thanks for that Mofi.

Have done some testing,

I am now getting the file list showing up and all files are displayed and listed. I've got a collection of *.txt files with missing the extension.

What happens next is that the macro running/cancel box is displayed and the cursor blinks rapidly. The called macro doesn't appear to run as no changes are made to the files

Obviously I have an error somewhere in the 2nd half of the macro

both macros are saved in the same macro file

Called Macro (step2)
Main Macro (step1)

I want to replace the hard coded directory in the FindInFiles command with a dynamic value.

FindInFiles "D:\Users\macro test\" "*" ""

So I tried using the following but neither worked.

1. FindInFiles "^c" "*" ""
In this case the directory path was copied to the clipboard before executing the macro

2. FindInFiles "^s" "*" ""
In this case the directory path was selected text in the current file

Can anyone help?

Thanks
Krthk

Hi all,

I'm using currently Ultraedit 12.20b+1. How do I get this to work on the whole folder?

I am trying to run a macro on around 100 files to tidy them up with the following macro..

InsertMode
ColumnModeOff
HexOff
UnixReOff
Find "<!-- Begin Document Specific Declarations -->"
Replace ""
Find "<!-- End Document Specific Declarations -->"
Replace ""
Find RegExp "Multiple
procedures"
Replace All "Multiple procedures"
Find RegExp "single
procedure"
Replace All "single procedure"
Find RegExp "<?MEKON*>"
Replace All ""
Find "><"
Replace All ">^p<"
Loop 10
Find "^p^p"
Replace All "^p"
EndLoop
Loop 10
Find " "
Replace All " "
EndLoop
Find "^p</XREF>"
Replace All "</XREF>"
Find "^p</ENTRY>"
Replace All "</ENTRY>"

Do I add the command to the macro and do I have to run it on command line and if so how??

FindInFiles "D:\Users\macro test\" "*" ""

or

RepInFiles "D:\Users\macro test\" "*" ""

Many thanks for your time.

Regards

Neil

Hi Mofi,

Thanks for your response, I use this macro to tidy up some sgml data on a regular basis.

Nothing wrong with your macro, I just dont understand that language...

2 hours later: Just used your macro, Many Thanks, saved me lots of time.

Kind Regards

Neil

This thread has become a bit old. I read through the posts here and applied the same but it just didn't work for me. I have multiple folders inside a folder. How can i run my macro on all files in those folders since there are a few thousand of them. I have UE version 16.

Thanks Mofi ...it worked!!!