I'm not sure if this is possible. But here goes...
We have 3 .txt files that are generated from our system. Contained within each, in a random order is about 6000 rows of customer data, this amount of course differs everyday as we gain and lose customers.
Each morning we must open the .txt files one by one using something like Utraledit and go to a specific column to fill a single character for all rows of the information. By creating this character we notice it also creates a space at the end for each line which needs to be removed, so we will then remove the space at the end for each. See below example.
My question is can this process be automated using a script, without any user interaction whatsoever?
Please let me know if you have any additional questions.
Some Additional information regarding the current 3 files:
1.These files are generated each morning to a path on the server (Example: X:\Quili\raw_data\)
2.The file names of each of the .txt files are different each day using the naming convention of BZYYYYMMDD.txt and UIYYYYMMDD.txt and ZZYYYYMMDD.txt
3.Once we do the above the procedure with these files and process them through another system all 3 of these files are then moved automatically to another folder. So the X:\Quili\raw_data folder is always empty after we process the 3 files in the system each day.
Do let me know if this is possible.