RegEx Text Search in All Files' Contents in Directories and Its Sub Directories

Question

Hi,

Is it possible to create an Alteryx workflow to perform a regular expression text search in all files' contents in specified directory and all of its sub directories?

Thanks!

domo_arigatoo · Answer

Thanks @PhilipMannering on using Powershell.

philipmannering · Answer

Ah, I see. That's more difficult. I would do it in Powershell. You can execute powershell commands in the Run Command Tool by prepending the command with `powershell`. The command would look something like,

Get-ChildItem -Path C:\Users\Philip\Desktop\ -file -recurse | foreach-object {select-string $_ -Pattern 'regex'}

where `C:\Users\Philip\Desktop\` is the directory you're looking in, and `regex` is your regular expression. I could build this into a tool, but would take longer.

Hope this helps.

Philip

domo_arigatoo · Answer

Hi @PhilipMannering,

I have made some corrections in my initial post. I would like to search the contents of all files, not searching the path of all files.

Thanks.