Dear @Bassem Sabbagh,

Please assign an AI DEV resource to implement the following rule for parsing the site ID for Nokia RAN, as outlined below:

Priority - 1:
1. Extract the first string before any special characters (such as ‘-’, ‘_’, or ‘/’) from the node name.
2. Search for this extracted value in column ‘C’ of the relevant tab in the “On Air Sheets V13” file, based on the node type. Retrieve the corresponding value from column “B,” which will be the site ID for the node.
The steps for each node type are as follows:

A. For Node Type BTS:
• (I) Search first in the "2G_NSN" tab.
• (II) If not found, search in the "On Air Summary" tab.
• (III) If still not found, search in the "Dismantled Sites" tab.
B. For Node Type NodeB:
• (I) Search first in the "3G_NSN" tab.
• (II) If not found, search in the "On Air Summary" tab.
• (III) If still not found, search in the "Dismantled Sites" tab.
C. For Node Type eNodeB:
• (I) Search first in the "LTE_NSN" tab.
• (II) If not found, search in the "On Air Summary" tab.
• (III) If still not found, search in the "Dismantled Sites" tab.
D. For Node Type SRAN:
• (I) Search first in the "2G_NSN / 3G_NSN / LTE_NSN / 5G_NSN" tabs.
• (II) If not found, search in the "On Air Summary" tab.
• (III) If still not found, search in the "Dismantled Sites" tab.

E. For Node Type BSC: Follow the "site matching sheet."
F. For Node Type RNC: Follow the "site matching sheet."

Priority - 2:
We will prioritize using the “Site matching sheet” for the site ID.

Priority - 3:
The existing rule should be followed for the site ID.

Best regards,
Indrasan