How to automatically edit a text file to add a command space and then move the below line up to after the space
Posted on 2011-03-11
We use a scanner to scan bar codes when we get in inventory. The Inventory system is web bases so all we have to do is type in that number into a text box or several numbers and it will update the file with all the item. The problem is that the scanner outputs the serial numbers like this (below)
When we put them into the browser to do it to enter multiple items we have to change it to
00020957000311, 00020957000311, 16139651541515...etc
Basically we have to take the list and hit comma space delete so they line up like that so the S/W can upload multiple serial numbers. The problem is this list can be 500 serial numbers long and ir rather tedious. Is there any sort of script or Macro that can do this from the list?