I'm in the IT department for a casino. For those of you not in the gaming industry, there is a group of people called The Count Team who collect the money from the slot machines in the middle of the night. They feed the money into a money sorter and send a file, containing information about the money and which machines it all came from, to a PC. From there, the file is uploaded to an AS/400 machine.
For some reason, when the file comes across from the money counter, the text file containing all the data will at times put a minus sign in front of the asset numbers of some of the slot machines. When they try to upload those files, the AS/400 program that we use doesn't know what to do with it. In short, it creates a huge mess.
Is there a way I can create a batch file that will remove all of the minus signs from the text document before they upload?