I don't suppose he's using Linux / Mac, and/or Windows 10 with the bash command? If so, I'd almost certainly do it with some sed commands in a bash script.
If not, I agree with Jared that a frontend solution may be good. You could build your colleague a simple sanitize.html page with two textbox elements, and upon change in the input invoke a function to transform it to the output,
function transformInputCSV() {
var input = document.getElementById("inputTextbox").value;
var output = input.replace(/your regex here/, "You're replacement text");
// ouput = output.replace(.....)
document.getElementById("outputTextbox").value = output;
}
Here's the HTML for such a page, which he could open in a browser,
<html>
<head>
<script>
function transformInputCSV() {
var input = document.getElementById("inputTextbox").value;
var output = input.replace(/your regex here/, "Your replacement text");
// output = output.replace(.....)
document.getElementById("outputTextbox").value = output;
}
</script>
</head>
<body>
<div><textarea id="inputTextbox" onchange="transformInputCSV()"></textarea></div>
<div><textarea id="outputTextbox" ></textarea></div>
</body>
</html>
But it would be possible to tie Mango into things if there is a reason to. Have you checked out the API endpoints for the data file data source? One permits you to submit files for immediate processing, and there's no reason an importer could not simply place the post-processed file in the filestore for a user this user has access to.
