h8rt3rmin8r

airtable - 9char title - 5char symbol - recid

Nov 11th, 2018
189
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CONCATENATE(IF(MID(UPPER(title), 1, 1) = "A", "01", IF(MID(UPPER(title), 1, 1) = "B", "02", IF(MID(UPPER(title), 1, 1) = "C", "03", IF(MID(UPPER(title), 1, 1) = "D", "04", IF(MID(UPPER(title), 1, 1) = "E", "05", IF(MID(UPPER(title), 1, 1) = "F", "06", IF(MID(UPPER(title), 1, 1) = "G", "07", IF(MID(UPPER(title), 1, 1) = "H", "08", IF(MID(UPPER(title), 1, 1) = "I", "09", IF(MID(UPPER(title), 1, 1) = "J", "10", IF(MID(UPPER(title), 1, 1) = "K", "11", IF(MID(UPPER(title), 1, 1) = "L", "12", IF(MID(UPPER(title), 1, 1) = "M", "13", IF(MID(UPPER(title), 1, 1) = "N", "14", IF(MID(UPPER(title), 1, 1) = "O", "15", IF(MID(UPPER(title), 1, 1) = "P", "16", IF(MID(UPPER(title), 1, 1) = "Q", "17", IF(MID(UPPER(title), 1, 1) = "R", "18", IF(MID(UPPER(title), 1, 1) = "S", "19", IF(MID(UPPER(title), 1, 1) = "T", "20", IF(MID(UPPER(title), 1, 1) = "U", "21", IF(MID(UPPER(title), 1, 1) = "V", "22", IF(MID(UPPER(title), 1, 1) = "W", "23", IF(MID(UPPER(title), 1, 1) = "X", "24", IF(MID(UPPER(title), 1, 1) = "Y", "25", IF(MID(UPPER(title), 1, 1) = "Z", "26", "27")))))))))))))))))))))))))), IF(MID(UPPER(title), 2, 1) = "A", "01", IF(MID(UPPER(title), 2, 1) = "B", "02", IF(MID(UPPER(title), 2, 1) = "C", "03", IF(MID(UPPER(title), 2, 1) = "D", "04", IF(MID(UPPER(title), 2, 1) = "E", "05", IF(MID(UPPER(title), 2, 1) = "F", "06", IF(MID(UPPER(title), 2, 1) = "G", "07", IF(MID(UPPER(title), 2, 1) = "H", "08", IF(MID(UPPER(title), 2, 1) = "I", "09", IF(MID(UPPER(title), 2, 1) = "J", "10", IF(MID(UPPER(title), 2, 1) = "K", "11", IF(MID(UPPER(title), 2, 1) = "L", "12", IF(MID(UPPER(title), 2, 1) = "M", "13", IF(MID(UPPER(title), 2, 1) = "N", "14", IF(MID(UPPER(title), 2, 1) = "O", "15", IF(MID(UPPER(title), 2, 1) = "P", "16", IF(MID(UPPER(title), 2, 1) = "Q", "17", IF(MID(UPPER(title), 2, 1) = "R", "18", IF(MID(UPPER(title), 2, 1) = "S", "19", IF(MID(UPPER(title), 2, 1) = "T", "20", IF(MID(UPPER(title), 2, 1) = "U", "21", IF(MID(UPPER(title), 2, 1) = "V", "22", IF(MID(UPPER(title), 2, 1) = "W", "23", IF(MID(UPPER(title), 2, 1) = "X", "24", IF(MID(UPPER(title), 2, 1) = "Y", "25", IF(MID(UPPER(title), 2, 1) = "Z", "26", "27")))))))))))))))))))))))))), IF(MID(UPPER(title), 3, 1) = "A", "01", IF(MID(UPPER(title), 3, 1) = "B", "02", IF(MID(UPPER(title), 3, 1) = "C", "03", IF(MID(UPPER(title), 3, 1) = "D", "04", IF(MID(UPPER(title), 3, 1) = "E", "05", IF(MID(UPPER(title), 3, 1) = "F", "06", IF(MID(UPPER(title), 3, 1) = "G", "07", IF(MID(UPPER(title), 3, 1) = "H", "08", IF(MID(UPPER(title), 3, 1) = "I", "09", IF(MID(UPPER(title), 3, 1) = "J", "10", IF(MID(UPPER(title), 3, 1) = "K", "11", IF(MID(UPPER(title), 3, 1) = "L", "12", IF(MID(UPPER(title), 3, 1) = "M", "13", IF(MID(UPPER(title), 3, 1) = "N", "14", IF(MID(UPPER(title), 3, 1) = "O", "15", IF(MID(UPPER(title), 3, 1) = "P", "16", IF(MID(UPPER(title), 3, 1) = "Q", "17", IF(MID(UPPER(title), 3, 1) = "R", "18", IF(MID(UPPER(title), 3, 1) = "S", "19", IF(MID(UPPER(title), 3, 1) = "T", "20", IF(MID(UPPER(title), 3, 1) = "U", "21", IF(MID(UPPER(title), 3, 1) = "V", "22", IF(MID(UPPER(title), 3, 1) = "W", "23", IF(MID(UPPER(title), 3, 1) = "X", "24", IF(MID(UPPER(title), 3, 1) = "Y", "25", IF(MID(UPPER(title), 3, 1) = "Z", "26", "27")))))))))))))))))))))))))), IF(MID(UPPER(title), 4, 1) = "A", "01", IF(MID(UPPER(title), 4, 1) = "B", "02", IF(MID(UPPER(title), 4, 1) = "C", "03", IF(MID(UPPER(title), 4, 1) = "D", "04", IF(MID(UPPER(title), 4, 1) = "E", "05", IF(MID(UPPER(title), 4, 1) = "F", "06", IF(MID(UPPER(title), 4, 1) = "G", "07", IF(MID(UPPER(title), 4, 1) = "H", "08", IF(MID(UPPER(title), 4, 1) = "I", "09", IF(MID(UPPER(title), 4, 1) = "J", "10", IF(MID(UPPER(title), 4, 1) = "K", "11", IF(MID(UPPER(title), 4, 1) = "L", "12", IF(MID(UPPER(title), 4, 1) = "M", "13", IF(MID(UPPER(title), 4, 1) = "N", "14", IF(MID(UPPER(title), 4, 1) = "O", "15", IF(MID(UPPER(title), 4, 1) = "P", "16", IF(MID(UPPER(title), 4, 1) = "Q", "17", IF(MID(UPPER(title), 4, 1) = "R", "18", IF(MID(UPPER(title), 4, 1) = "S", "19", IF(MID(UPPER(title), 4, 1) = "T", "20", IF(MID(UPPER(title), 4, 1) = "U", "21", IF(MID(UPPER(title), 4, 1) = "V", "22", IF(MID(UPPER(title), 4, 1) = "W", "23", IF(MID(UPPER(title), 4, 1) = "X", "24", IF(MID(UPPER(title), 4, 1) = "Y", "25", IF(MID(UPPER(title), 4, 1) = "Z", "26", "27")))))))))))))))))))))))))), IF(MID(UPPER(title), 5, 1) = "A", "01", IF(MID(UPPER(title), 5, 1) = "B", "02", IF(MID(UPPER(title), 5, 1) = "C", "03", IF(MID(UPPER(title), 5, 1) = "D", "04", IF(MID(UPPER(title), 5, 1) = "E", "05", IF(MID(UPPER(title), 5, 1) = "F", "06", IF(MID(UPPER(title), 5, 1) = "G", "07", IF(MID(UPPER(title), 5, 1) = "H", "08", IF(MID(UPPER(title), 5, 1) = "I", "09", IF(MID(UPPER(title), 5, 1) = "J", "10", IF(MID(UPPER(title), 5, 1) = "K", "11", IF(MID(UPPER(title), 5, 1) = "L", "12", IF(MID(UPPER(title), 5, 1) = "M", "13", IF(MID(UPPER(title), 5, 1) = "N", "14", IF(MID(UPPER(title), 5, 1) = "O", "15", IF(MID(UPPER(title), 5, 1) = "P", "16", IF(MID(UPPER(title), 5, 1) = "Q", "17", IF(MID(UPPER(title), 5, 1) = "R", "18", IF(MID(UPPER(title), 5, 1) = "S", "19", IF(MID(UPPER(title), 5, 1) = "T", "20", IF(MID(UPPER(title), 5, 1) = "U", "21", IF(MID(UPPER(title), 5, 1) = "V", "22", IF(MID(UPPER(title), 5, 1) = "W", "23", IF(MID(UPPER(title), 5, 1) = "X", "24", IF(MID(UPPER(title), 5, 1) = "Y", "25", IF(MID(UPPER(title), 5, 1) = "Z", "26", "27")))))))))))))))))))))))))), IF(MID(UPPER(title), 6, 1) = "A", "01", IF(MID(UPPER(title), 6, 1) = "B", "02", IF(MID(UPPER(title), 6, 1) = "C", "03", IF(MID(UPPER(title), 6, 1) = "D", "04", IF(MID(UPPER(title), 6, 1) = "E", "05", IF(MID(UPPER(title), 6, 1) = "F", "06", IF(MID(UPPER(title), 6, 1) = "G", "07", IF(MID(UPPER(title), 6, 1) = "H", "08", IF(MID(UPPER(title), 6, 1) = "I", "09", IF(MID(UPPER(title), 6, 1) = "J", "10", IF(MID(UPPER(title), 6, 1) = "K", "11", IF(MID(UPPER(title), 6, 1) = "L", "12", IF(MID(UPPER(title), 6, 1) = "M", "13", IF(MID(UPPER(title), 6, 1) = "N", "14", IF(MID(UPPER(title), 6, 1) = "O", "15", IF(MID(UPPER(title), 6, 1) = "P", "16", IF(MID(UPPER(title), 6, 1) = "Q", "17", IF(MID(UPPER(title), 6, 1) = "R", "18", IF(MID(UPPER(title), 6, 1) = "S", "19", IF(MID(UPPER(title), 6, 1) = "T", "20", IF(MID(UPPER(title), 6, 1) = "U", "21", IF(MID(UPPER(title), 6, 1) = "V", "22", IF(MID(UPPER(title), 6, 1) = "W", "23", IF(MID(UPPER(title), 6, 1) = "X", "24", IF(MID(UPPER(title), 6, 1) = "Y", "25", IF(MID(UPPER(title), 6, 1) = "Z", "26", "27")))))))))))))))))))))))))), IF(MID(UPPER(title), 7, 1) = "A", "01", IF(MID(UPPER(title), 7, 1) = "B", "02", IF(MID(UPPER(title), 7, 1) = "C", "03", IF(MID(UPPER(title), 7, 1) = "D", "04", IF(MID(UPPER(title), 7, 1) = "E", "05", IF(MID(UPPER(title), 7, 1) = "F", "06", IF(MID(UPPER(title), 7, 1) = "G", "07", IF(MID(UPPER(title), 7, 1) = "H", "08", IF(MID(UPPER(title), 7, 1) = "I", "09", IF(MID(UPPER(title), 7, 1) = "J", "10", IF(MID(UPPER(title), 7, 1) = "K", "11", IF(MID(UPPER(title), 7, 1) = "L", "12", IF(MID(UPPER(title), 7, 1) = "M", "13", IF(MID(UPPER(title), 7, 1) = "N", "14", IF(MID(UPPER(title), 7, 1) = "O", "15", IF(MID(UPPER(title), 7, 1) = "P", "16", IF(MID(UPPER(title), 7, 1) = "Q", "17", IF(MID(UPPER(title), 7, 1) = "R", "18", IF(MID(UPPER(title), 7, 1) = "S", "19", IF(MID(UPPER(title), 7, 1) = "T", "20", IF(MID(UPPER(title), 7, 1) = "U", "21", IF(MID(UPPER(title), 7, 1) = "V", "22", IF(MID(UPPER(title), 7, 1) = "W", "23", IF(MID(UPPER(title), 7, 1) = "X", "24", IF(MID(UPPER(title), 7, 1) = "Y", "25", IF(MID(UPPER(title), 7, 1) = "Z", "26", "27")))))))))))))))))))))))))), IF(MID(UPPER(title), 8, 1) = "A", "01", IF(MID(UPPER(title), 8, 1) = "B", "02", IF(MID(UPPER(title), 8, 1) = "C", "03", IF(MID(UPPER(title), 8, 1) = "D", "04", IF(MID(UPPER(title), 8, 1) = "E", "05", IF(MID(UPPER(title), 8, 1) = "F", "06", IF(MID(UPPER(title), 8, 1) = "G", "07", IF(MID(UPPER(title), 8, 1) = "H", "08", IF(MID(UPPER(title), 8, 1) = "I", "09", IF(MID(UPPER(title), 8, 1) = "J", "10", IF(MID(UPPER(title), 8, 1) = "K", "11", IF(MID(UPPER(title), 8, 1) = "L", "12", IF(MID(UPPER(title), 8, 1) = "M", "13", IF(MID(UPPER(title), 8, 1) = "N", "14", IF(MID(UPPER(title), 8, 1) = "O", "15", IF(MID(UPPER(title), 8, 1) = "P", "16", IF(MID(UPPER(title), 8, 1) = "Q", "17", IF(MID(UPPER(title), 8, 1) = "R", "18", IF(MID(UPPER(title), 8, 1) = "S", "19", IF(MID(UPPER(title), 8, 1) = "T", "20", IF(MID(UPPER(title), 8, 1) = "U", "21", IF(MID(UPPER(title), 8, 1) = "V", "22", IF(MID(UPPER(title), 8, 1) = "W", "23", IF(MID(UPPER(title), 8, 1) = "X", "24", IF(MID(UPPER(title), 8, 1) = "Y", "25", IF(MID(UPPER(title), 8, 1) = "Z", "26", "27")))))))))))))))))))))))))), IF(MID(UPPER(title), 9, 1) = "A", "01", IF(MID(UPPER(title), 9, 1) = "B", "02", IF(MID(UPPER(title), 9, 1) = "C", "03", IF(MID(UPPER(title), 9, 1) = "D", "04", IF(MID(UPPER(title), 9, 1) = "E", "05", IF(MID(UPPER(title), 9, 1) = "F", "06", IF(MID(UPPER(title), 9, 1) = "G", "07", IF(MID(UPPER(title), 9, 1) = "H", "08", IF(MID(UPPER(title), 9, 1) = "I", "09", IF(MID(UPPER(title), 9, 1) = "J", "10", IF(MID(UPPER(title), 9, 1) = "K", "11", IF(MID(UPPER(title), 9, 1) = "L", "12", IF(MID(UPPER(title), 9, 1) = "M", "13", IF(MID(UPPER(title), 9, 1) = "N", "14", IF(MID(UPPER(title), 9, 1) = "O", "15", IF(MID(UPPER(title), 9, 1) = "P", "16", IF(MID(UPPER(title), 9, 1) = "Q", "17", IF(MID(UPPER(title), 9, 1) = "R", "18", IF(MID(UPPER(title), 9, 1) = "S", "19", IF(MID(UPPER(title), 9, 1) = "T", "20", IF(MID(UPPER(title), 9, 1) = "U", "21", IF(MID(UPPER(title), 9, 1) = "V", "22", IF(MID(UPPER(title), 9, 1) = "W", "23", IF(MID(UPPER(title), 9, 1) = "X", "24", IF(MID(UPPER(title), 9, 1) = "Y", "25", IF(MID(UPPER(title), 9, 1) = "Z", "26", "27")))))))))))))))))))))))))), "-", IF(MID(UPPER(symbol), 1, 1) = "A", "01", IF(MID(UPPER(symbol), 1, 1) = "B", "02", IF(MID(UPPER(symbol), 1, 1) = "C", "03", IF(MID(UPPER(symbol), 1, 1) = "D", "04", IF(MID(UPPER(symbol), 1, 1) = "E", "05", IF(MID(UPPER(symbol), 1, 1) = "F", "06", IF(MID(UPPER(symbol), 1, 1) = "G", "07", IF(MID(UPPER(symbol), 1, 1) = "H", "08", IF(MID(UPPER(symbol), 1, 1) = "I", "09", IF(MID(UPPER(symbol), 1, 1) = "J", "10", IF(MID(UPPER(symbol), 1, 1) = "K", "11", IF(MID(UPPER(symbol), 1, 1) = "L", "12", IF(MID(UPPER(symbol), 1, 1) = "M", "13", IF(MID(UPPER(symbol), 1, 1) = "N", "14", IF(MID(UPPER(symbol), 1, 1) = "O", "15", IF(MID(UPPER(symbol), 1, 1) = "P", "16", IF(MID(UPPER(symbol), 1, 1) = "Q", "17", IF(MID(UPPER(symbol), 1, 1) = "R", "18", IF(MID(UPPER(symbol), 1, 1) = "S", "19", IF(MID(UPPER(symbol), 1, 1) = "T", "20", IF(MID(UPPER(symbol), 1, 1) = "U", "21", IF(MID(UPPER(symbol), 1, 1) = "V", "22", IF(MID(UPPER(symbol), 1, 1) = "W", "23", IF(MID(UPPER(symbol), 1, 1) = "X", "24", IF(MID(UPPER(symbol), 1, 1) = "Y", "25", IF(MID(UPPER(symbol), 1, 1) = "Z", "26", "27")))))))))))))))))))))))))), IF(MID(UPPER(symbol), 2, 1) = "A", "01", IF(MID(UPPER(symbol), 2, 1) = "B", "02", IF(MID(UPPER(symbol), 2, 1) = "C", "03", IF(MID(UPPER(symbol), 2, 1) = "D", "04", IF(MID(UPPER(symbol), 2, 1) = "E", "05", IF(MID(UPPER(symbol), 2, 1) = "F", "06", IF(MID(UPPER(symbol), 2, 1) = "G", "07", IF(MID(UPPER(symbol), 2, 1) = "H", "08", IF(MID(UPPER(symbol), 2, 1) = "I", "09", IF(MID(UPPER(symbol), 2, 1) = "J", "10", IF(MID(UPPER(symbol), 2, 1) = "K", "11", IF(MID(UPPER(symbol), 2, 1) = "L", "12", IF(MID(UPPER(symbol), 2, 1) = "M", "13", IF(MID(UPPER(symbol), 2, 1) = "N", "14", IF(MID(UPPER(symbol), 2, 1) = "O", "15", IF(MID(UPPER(symbol), 2, 1) = "P", "16", IF(MID(UPPER(symbol), 2, 1) = "Q", "17", IF(MID(UPPER(symbol), 2, 1) = "R", "18", IF(MID(UPPER(symbol), 2, 1) = "S", "19", IF(MID(UPPER(symbol), 2, 1) = "T", "20", IF(MID(UPPER(symbol), 2, 1) = "U", "21", IF(MID(UPPER(symbol), 2, 1) = "V", "22", IF(MID(UPPER(symbol), 2, 1) = "W", "23", IF(MID(UPPER(symbol), 2, 1) = "X", "24", IF(MID(UPPER(symbol), 2, 1) = "Y", "25", IF(MID(UPPER(symbol), 2, 1) = "Z", "26", "27")))))))))))))))))))))))))), IF(MID(UPPER(symbol), 3, 1) = "A", "01", IF(MID(UPPER(symbol), 3, 1) = "B", "02", IF(MID(UPPER(symbol), 3, 1) = "C", "03", IF(MID(UPPER(symbol), 3, 1) = "D", "04", IF(MID(UPPER(symbol), 3, 1) = "E", "05", IF(MID(UPPER(symbol), 3, 1) = "F", "06", IF(MID(UPPER(symbol), 3, 1) = "G", "07", IF(MID(UPPER(symbol), 3, 1) = "H", "08", IF(MID(UPPER(symbol), 3, 1) = "I", "09", IF(MID(UPPER(symbol), 3, 1) = "J", "10", IF(MID(UPPER(symbol), 3, 1) = "K", "11", IF(MID(UPPER(symbol), 3, 1) = "L", "12", IF(MID(UPPER(symbol), 3, 1) = "M", "13", IF(MID(UPPER(symbol), 3, 1) = "N", "14", IF(MID(UPPER(symbol), 3, 1) = "O", "15", IF(MID(UPPER(symbol), 3, 1) = "P", "16", IF(MID(UPPER(symbol), 3, 1) = "Q", "17", IF(MID(UPPER(symbol), 3, 1) = "R", "18", IF(MID(UPPER(symbol), 3, 1) = "S", "19", IF(MID(UPPER(symbol), 3, 1) = "T", "20", IF(MID(UPPER(symbol), 3, 1) = "U", "21", IF(MID(UPPER(symbol), 3, 1) = "V", "22", IF(MID(UPPER(symbol), 3, 1) = "W", "23", IF(MID(UPPER(symbol), 3, 1) = "X", "24", IF(MID(UPPER(symbol), 3, 1) = "Y", "25", IF(MID(UPPER(symbol), 3, 1) = "Z", "26", "27")))))))))))))))))))))))))), IF(MID(UPPER(symbol), 4, 1) = "A", "01", IF(MID(UPPER(symbol), 4, 1) = "B", "02", IF(MID(UPPER(symbol), 4, 1) = "C", "03", IF(MID(UPPER(symbol), 4, 1) = "D", "04", IF(MID(UPPER(symbol), 4, 1) = "E", "05", IF(MID(UPPER(symbol), 4, 1) = "F", "06", IF(MID(UPPER(symbol), 4, 1) = "G", "07", IF(MID(UPPER(symbol), 4, 1) = "H", "08", IF(MID(UPPER(symbol), 4, 1) = "I", "09", IF(MID(UPPER(symbol), 4, 1) = "J", "10", IF(MID(UPPER(symbol), 4, 1) = "K", "11", IF(MID(UPPER(symbol), 4, 1) = "L", "12", IF(MID(UPPER(symbol), 4, 1) = "M", "13", IF(MID(UPPER(symbol), 4, 1) = "N", "14", IF(MID(UPPER(symbol), 4, 1) = "O", "15", IF(MID(UPPER(symbol), 4, 1) = "P", "16", IF(MID(UPPER(symbol), 4, 1) = "Q", "17", IF(MID(UPPER(symbol), 4, 1) = "R", "18", IF(MID(UPPER(symbol), 4, 1) = "S", "19", IF(MID(UPPER(symbol), 4, 1) = "T", "20", IF(MID(UPPER(symbol), 4, 1) = "U", "21", IF(MID(UPPER(symbol), 4, 1) = "V", "22", IF(MID(UPPER(symbol), 4, 1) = "W", "23", IF(MID(UPPER(symbol), 4, 1) = "X", "24", IF(MID(UPPER(symbol), 4, 1) = "Y", "25", IF(MID(UPPER(symbol), 4, 1) = "Z", "26", "27")))))))))))))))))))))))))), IF(MID(UPPER(symbol), 5, 1) = "A", "01", IF(MID(UPPER(symbol), 5, 1) = "B", "02", IF(MID(UPPER(symbol), 5, 1) = "C", "03", IF(MID(UPPER(symbol), 5, 1) = "D", "04", IF(MID(UPPER(symbol), 5, 1) = "E", "05", IF(MID(UPPER(symbol), 5, 1) = "F", "06", IF(MID(UPPER(symbol), 5, 1) = "G", "07", IF(MID(UPPER(symbol), 5, 1) = "H", "08", IF(MID(UPPER(symbol), 5, 1) = "I", "09", IF(MID(UPPER(symbol), 5, 1) = "J", "10", IF(MID(UPPER(symbol), 5, 1) = "K", "11", IF(MID(UPPER(symbol), 5, 1) = "L", "12", IF(MID(UPPER(symbol), 5, 1) = "M", "13", IF(MID(UPPER(symbol), 5, 1) = "N", "14", IF(MID(UPPER(symbol), 5, 1) = "O", "15", IF(MID(UPPER(symbol), 5, 1) = "P", "16", IF(MID(UPPER(symbol), 5, 1) = "Q", "17", IF(MID(UPPER(symbol), 5, 1) = "R", "18", IF(MID(UPPER(symbol), 5, 1) = "S", "19", IF(MID(UPPER(symbol), 5, 1) = "T", "20", IF(MID(UPPER(symbol), 5, 1) = "U", "21", IF(MID(UPPER(symbol), 5, 1) = "V", "22", IF(MID(UPPER(symbol), 5, 1) = "W", "23", IF(MID(UPPER(symbol), 5, 1) = "X", "24", IF(MID(UPPER(symbol), 5, 1) = "Y", "25", IF(MID(UPPER(symbol), 5, 1) = "Z", "26", "27")))))))))))))))))))))))))), "-", IF(MID(UPPER(RECORD_ID()), 4, 1) = "A", "01", IF(MID(UPPER(RECORD_ID()), 4, 1) = "B", "02", IF(MID(UPPER(RECORD_ID()), 4, 1) = "C", "03", IF(MID(UPPER(RECORD_ID()), 4, 1) = "D", "04", IF(MID(UPPER(RECORD_ID()), 4, 1) = "E", "05", IF(MID(UPPER(RECORD_ID()), 4, 1) = "F", "06", IF(MID(UPPER(RECORD_ID()), 4, 1) = "G", "07", IF(MID(UPPER(RECORD_ID()), 4, 1) = "H", "08", IF(MID(UPPER(RECORD_ID()), 4, 1) = "I", "09", IF(MID(UPPER(RECORD_ID()), 4, 1) = "J", "10", IF(MID(UPPER(RECORD_ID()), 4, 1) = "K", "11", IF(MID(UPPER(RECORD_ID()), 4, 1) = "L", "12", IF(MID(UPPER(RECORD_ID()), 4, 1) = "M", "13", IF(MID(UPPER(RECORD_ID()), 4, 1) = "N", "14", IF(MID(UPPER(RECORD_ID()), 4, 1) = "O", "15", IF(MID(UPPER(RECORD_ID()), 4, 1) = "P", "16", IF(MID(UPPER(RECORD_ID()), 4, 1) = "Q", "17", IF(MID(UPPER(RECORD_ID()), 4, 1) = "R", "18", IF(MID(UPPER(RECORD_ID()), 4, 1) = "S", "19", IF(MID(UPPER(RECORD_ID()), 4, 1) = "T", "20", IF(MID(UPPER(RECORD_ID()), 4, 1) = "U", "21", IF(MID(UPPER(RECORD_ID()), 4, 1) = "V", "22", IF(MID(UPPER(RECORD_ID()), 4, 1) = "W", "23", IF(MID(UPPER(RECORD_ID()), 4, 1) = "X", "24", IF(MID(UPPER(RECORD_ID()), 4, 1) = "Y", "25", IF(MID(UPPER(RECORD_ID()), 4, 1) = "Z", "26", IF(MID(UPPER(RECORD_ID()), 4, 1) = "a", "27", IF(MID(UPPER(RECORD_ID()), 4, 1) = "b", "28", IF(MID(UPPER(RECORD_ID()), 4, 1) = "c", "29", IF(MID(UPPER(RECORD_ID()), 4, 1) = "d", "30", IF(MID(UPPER(RECORD_ID()), 4, 1) = "e", "31", IF(MID(UPPER(RECORD_ID()), 4, 1) = "f", "32", IF(MID(UPPER(RECORD_ID()), 4, 1) = "g", "33", IF(MID(UPPER(RECORD_ID()), 4, 1) = "h", "34", IF(MID(UPPER(RECORD_ID()), 4, 1) = "i", "35", IF(MID(UPPER(RECORD_ID()), 4, 1) = "j", "36", IF(MID(UPPER(RECORD_ID()), 4, 1) = "k", "37", IF(MID(UPPER(RECORD_ID()), 4, 1) = "l", "38", IF(MID(UPPER(RECORD_ID()), 4, 1) = "m", "39", IF(MID(UPPER(RECORD_ID()), 4, 1) = "n", "40", IF(MID(UPPER(RECORD_ID()), 4, 1) = "o", "41", IF(MID(UPPER(RECORD_ID()), 4, 1) = "p", "42", IF(MID(UPPER(RECORD_ID()), 4, 1) = "q", "43", IF(MID(UPPER(RECORD_ID()), 4, 1) = "r", "44", IF(MID(UPPER(RECORD_ID()), 4, 1) = "s", "45", IF(MID(UPPER(RECORD_ID()), 4, 1) = "t", "46", IF(MID(UPPER(RECORD_ID()), 4, 1) = "u", "47", IF(MID(UPPER(RECORD_ID()), 4, 1) = "v", "48", IF(MID(UPPER(RECORD_ID()), 4, 1) = "w", "49", IF(MID(UPPER(RECORD_ID()), 4, 1) = "x", "50", IF(MID(UPPER(RECORD_ID()), 4, 1) = "y", "51", IF(MID(UPPER(RECORD_ID()), 4, 1) = "z", "52", IF(MID(UPPER(RECORD_ID()), 4, 1) = "0", "53", IF(MID(UPPER(RECORD_ID()), 4, 1) = "1", "54", IF(MID(UPPER(RECORD_ID()), 4, 1) = "2", "55", IF(MID(UPPER(RECORD_ID()), 4, 1) = "3", "56", IF(MID(UPPER(RECORD_ID()), 4, 1) = "4", "57", IF(MID(UPPER(RECORD_ID()), 4, 1) = "5", "58", IF(MID(UPPER(RECORD_ID()), 4, 1) = "6", "59", IF(MID(UPPER(RECORD_ID()), 4, 1) = "7", "60", IF(MID(UPPER(RECORD_ID()), 4, 1) = "8", "61", IF(MID(UPPER(RECORD_ID()), 4, 1) = "9", "62", "63")))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
RAW Paste Data