

The folder could be an if as well but that'll be a bit more difficult. The action column could be a number of IF $Message contains "upload" then $Action = Upload. The message column would be everything after ($IP)> so that should ideally be easy enough. How do you read certain parts of a line up until the first space? The issue is I don't even know where to start to create this. Then I could say ok how many times does the action Upload appear in CSV or which uploaded files has the words ".exe" in them. "/Subfolder1" is current directory.ġ50 Opening data channel for file upload to server of "/Folder1/SecretSubfolder/Autologon.exe" I'm thinking something along the lines ofĢ50 CWD successful.

(000004) 10:57:02 AM - UserA (13.18.21.123)> 150 Opening data channel for file upload to server of "/Folder1/SecretSubfolder/Autologon.exe"

I'm hoping to use PowerShell to set up a friendly parser for PowerBI to combine FileZilla log files.
