BatchPro: Format SPLC Input Files

(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.

    J SwugtDFHSJeTO78MmqNaWHcHz8up4Pg

  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”.

    awvVKJDgg5Si8q iKuCfP uCqM28yu4WWA

  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.

    LRRh6FtMBgKhsHBi8Jg JJZHJ1fjUpw 2A

  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.

    HwU6VvFg6uwG6CNElUsiZ Ga8ZTvRQyjJg

  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.