(North America only – SPLC data must be installed) To use SPLCs when entering origins and destinations, each number needs to be preceded by “SPLC”, e.g. “SPLC191690000”. Follow the steps below to use Microsoft® Excel to quickly change a text file of SPLCs pairs into a properly formatted input file for BatchPro.
1. Copy the text file into Excel, with one column for origins (Column A in this example) and one column for destinations. There should be at least one blank column to the right of the origins column.
2. Insert a new column to the left of column A (right click column > Insert).
3. In the new column, add “SPLC” to each row that has a SPLC in it. To do this quickly, type “SPLC” in cell A1, then click and drag the bottom right corner of the cell down the column (the cursor will become a plus sign). Let go when all target cells are populated with “SPLC”.
4. Select a third column to the right (column C in this example) and make sure the cells are formatted as “General” or “Number” (right click the column and choose Format Cells…).
5. In cell C1 (or C2 if there is a header row), manually enter the following formula: =CONCATENATE(A1,B1)
6. Copy the formula down the remainder of the column as in Step 3.
7. With the third column selected, right click and select “Copy”.
8. With the column still highlighted, right click and select “Paste Special”.
9. In the dialog that opens, select Values and hit OK.
10. Delete the first two columns. Your origin SPLCs are now correctly formatted.
11. For the destination SPLC, follow steps 1-10 starting with the column that contain the destinations.
12. When you have origin and destination columns set up, save the Excel file as a .PRN file.
13. Rename the .PRN file, changing the extension “.prn” to “.in”. The file is now ready to be imported into BatchPro.
14. After you select the file in BatchPro, select “SPLC” in the Format Name menu.
15. Click Edit Format.
16. Make sure that the Start Position and End Position for each column match the positions in your file. Create a new custom format if necessary.