Hi, I assume that you are already using Anaplan Connect, if so you can edit your import batch scripts to clean data before running the import. The easy way if your system has Powershell(Windows 7 or newer have this built-in) is to call the powershell command "-replace" from your batch script which will help you replace any characters/strings with your desired characters/strings. Eg: powershell -Command "(gc myFile.txt) -replace 'dog', 'cat' | Out-File -encoding ASCII myFile1.txt" This line will replace all the 'dog' that exist in myFile.txt to 'cat' and save the file as myFile1.txt. powershell -Command "(gc myFile.txt) -replace 'dog', '' | Out-File -encoding ASCII myFile2.txt" If we don't provide empty single quotes as the second string then it will remove 'dog' from myFile.txt and save it as myFile2.txt. The myFile.txt needs to exist in the same folder as the batch script for this to work. If they exist in different folders you can use 'cd' command before this command to go to your text file location, and then use 'cd' again to come back to your script location. I hope this helps, Good luck Mandeep
... View more
