ImportAs

importSL    =   app.trustedFunction(function()  {

    var fileName        =   "/c/Users/user/Desktop/Equipment Workbooks/Lanyards Workbook.txt";
    var serverOutputDir =   "/x/Equipment Certs/Safety Lanyards/";
    var whichCase       =   String(whichCert).indexOf(lastChar);
    var whichCert       =   this.getField("PFFSID").value;
    var whichFolder     =   "0";
    var whichNumber     =   String(whichCert).substr(0,50);
    var lastChar        =   String(whichCert).substr(-1,1);



var idx = 0;

while (0 == this.importTextData(fileName, idx)) {

    // Evaluates variables for the switch and saveAs statements

    whichCert   =   this.getField("PFFSID").value;
    lastChar    =   String(whichCert).substr(-1,1);

        if  (isNaN(lastChar) == false)
            whichCase = -1;
        else if (isNaN(lastChar) == true)
            whichCase = String(whichCert).indexOf(lastChar);

    switch(whichCase){

        case 1: {

            whichNumber =   String(whichCert).substr(0,1);

            if  (0 < whichNumber && whichNumber < 10)
                whichFolder = lastChar + "1-" + lastChar + "49";
            break;
        }

        case 2: {

            whichNumber =   String(whichCert).substr(0,2);

            if  (9 < whichNumber && whichNumber < 50)
                whichFolder = lastChar + "1-" + lastChar + "49";
            else if (49 < whichNumber && whichNumber < 100)
                whichFolder = lastChar + "50-" + lastChar + "99";
            break;
        }

        case 3: {

            whichNumber =   String(whichCert).substr(0,3);

            if  (99 < whichNumber && whichNumber < 150)
                whichFolder = lastChar + "100-" + lastChar + "149";
            else if (150 < whichNumber && whichNumber < 200)
                whichFolder = lastChar + "150-" + lastChar + "199";
            else if (199 < whichNumber && whichNumber < 250)
                whichFolder = lastChar + "200-" + lastChar + "249";
            else if (249 < whichNumber && whichNumber < 300)
                whichFolder = lastChar + "250-" + lastChar + "299";
            else if (299 < whichNumber && whichNumber < 350)
                whichFolder = lastChar + "300-" + lastChar + "349";
            else if (349 < whichNumber && whichNumber < 400)
                whichFolder = lastChar + "350-" + lastChar + "399";
            else if (399 < whichNumber && whichNumber < 450)
                whichFolder = lastChar + "400-" + lastChar + "449";
            else if (449 < whichNumber && whichNumber < 500)
                whichFolder = lastChar + "450-" + lastChar + "499";
            else if (499 < whichNumber && whichNumber < 550)
                whichFolder = lastChar + "500-" + lastChar + "549";
            else if (549 < whichNumber && whichNumber < 600)
                whichFolder = lastChar + "550-" + lastChar + "599";
            else if (599 < whichNumber && whichNumber < 650)
                whichFolder = lastChar + "600-" + lastChar + "649";
            else if (649 < whichNumber && whichNumber < 700)
                whichFolder = lastChar + "650-" + lastChar + "699";
            else if (699 < whichNumber && whichNumber < 750)
                whichFolder = lastChar + "700-" + lastChar + "749";
            else if (749 < whichNumber && whichNumber < 800)
                whichFolder = lastChar + "750-" + lastChar + "799";
            else if (799 < whichNumber && whichNumber < 850)
                whichFolder = lastChar + "800-" + lastChar + "849";
            else if (849 < whichNumber && whichNumber < 900)
                whichFolder = lastChar + "850-" + lastChar + "899";
            else if (899 < whichNumber && whichNumber < 950)
                whichFolder = lastChar + "900-" + lastChar + "949";
            else if (949 < whichNumber && whichNumber < 1000)
                whichFolder = lastChar + "950-" + lastChar + "999";
            break;
        }

        case 4: {

            whichNumber =   String(whichCert).substr(0,4);

            if (999 < whichNumber && whichNumber < 1050)
                whichFolder = lastChar + "1000-" + lastChar + "1049"
            else if (1049 < whichNumber && whichNumber < 1100)
                whichFolder = lastChar + "1050-" + lastChar + "1099"
            else if (1099 < whichNumber && whichNumber < 1150)
                whichFolder = lastChar + "1100-" + lastChar + "1149"
            else if (1149 < whichNumber && whichNumber < 1200)
                whichFolder = lastChar + "1150-" + lastChar + "1199"
            else if (1199 < whichNumber && whichNumber < 1250)
                whichFolder = lastChar + "1200-" + lastChar + "1249"
            else if (1249 < whichNumber && whichNumber < 1300)
                whichFolder = lastChar + "1250-" + lastChar + "1299"
            else if (1299 < whichNumber && whichNumber < 1350)
                whichFolder = lastChar + "1300-" + lastChar + "1349"
            else if (1349 < whichNumber && whichNumber < 1400)
                whichFolder = lastChar + "1350-" + lastChar + "1399"
            else if (1399 < whichNumber && whichNumber < 1450)
                whichFolder = lastChar + "1400-" + lastChar + "1449"
            else if (1449 < whichNumber && whichNumber < 1500)
                whichFolder = lastChar + "1450-" + lastChar + "1499"
            else if (1499 < whichNumber && whichNumber < 1550)
                whichFolder = lastChar + "1500-" + lastChar + "1549"
            else if (1549 < whichNumber && whichNumber < 1600)
                whichFolder = lastChar + "1550-" + lastChar + "1599"
            else if (1599 < whichNumber && whichNumber < 1650)
                whichFolder = lastChar + "1600-" + lastChar + "1649"
            else if (1649 < whichNumber && whichNumber < 1700)
                whichFolder = lastChar + "1650-" + lastChar + "1699"
            else if (1699 < whichNumber && whichNumber < 1750)
                whichFolder = lastChar + "1700-" + lastChar + "1749"
            else if (1749 < whichNumber && whichNumber < 1800)
                whichFolder = lastChar + "1750-" + lastChar + "1799"
            else if (1799 < whichNumber && whichNumber < 1850)
                whichFolder = lastChar + "1800-" + lastChar + "1849"
            else if (1849 < whichNumber && whichNumber < 1900)
                whichFolder = lastChar + "1850-" + lastChar + "1899"
            else if (1899 < whichNumber && whichNumber < 1950)
                whichFolder = lastChar + "1900-" + lastChar + "1949"
            else if (1949 < whichNumber && whichNumber < 2000)
                whichFolder = lastChar + "1950-" + lastChar + "1999"
            break;
        }

        case -1: {

            if (0 < whichNumber && whichNumber < 50)
                whichFolder = "1-49";
            else if (49 < whichNumber && whichNumber < 100)
                whichFolder = "50-99";
            else if (99 < whichNumber && whichNumber < 150)
                whichFolder = "100-149";
            else if (149 < whichNumber && whichNumber < 200)
                whichFolder = "150-199";
            else if (199 < whichNumber && whichNumber < 250)
                whichFolder = "200-249";
            else if (249 < whichNumber && whichNumber < 300)
                whichFolder = "250-299";
            else if (299 < whichNumber && whichNumber < 350)
                whichFolder = "300-349";
            else if (349 < whichNumber && whichNumber < 400)
                whichFolder = "350-399";
            else if (399 < whichNumber && whichNumber < 450)
                whichFolder = "400-449";
            else if (449 < whichNumber && whichNumber < 500)
                whichFolder = "450-499";
            else if (499 < whichNumber && whichNumber < 550)
                whichFolder = "500-549";
            else if (549 < whichNumber && whichNumber < 600)
                whichFolder = "550-599";
            else if (599 < whichNumber && whichNumber < 650)
                whichFolder = "600-649";
            else if (649 < whichNumber && whichNumber < 700)
                whichFolder = "650-699";
            else if (699 < whichNumber && whichNumber < 750)
                whichFolder = "700-749";
            else if (749 < whichNumber && whichNumber < 800)
                whichFolder = "750-799";
            else if (799 < whichNumber && whichNumber < 850)
                whichFolder = "800-849";
            else if (849 < whichNumber && whichNumber < 900)
                whichFolder = "850-899";
            else if (899 < whichNumber && whichNumber < 950)
                whichFolder = "900-949";
            else if (949 < whichNumber && whichNumber < 1000)
                whichFolder = "950-999";
            break;
        }
    }



    //  The save function puts all our variables together
    //  appending a prefix according to type of certificate
    //  and saving it to the resulting file location.

    this.saveAs({cPath:serverOutputDir + whichFolder + "/SL-" + whichCert + ".pdf"});
    idx++;
}
});