Please assign an AI DEV resource to implement the following rules for parsing the site ID for Huawei 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 (As described below). 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 Huawei" tab.
• (II) If not found, search in the "2G MMM" tab.
• (III) If still not found, search in the "On Air Summary" tab.
• (IV) If not found, search in the "Dismantled Sites" tab.
B. For Node Type NodeB:
• (I) Search first in the "3G Huawei" tab.
• (II) If not found, search in the "3G MMM" tab.
• (III) If still not found, search in the "On Air Summary" tab.
• (IV) If not found, search in the "Dismantled Sites" tab.
C. For Node Type eNodeB:
• (I) Search first in the "LTE Huawei" tab.
• (II) If not found, search in the "LTE MMM" tab.
• (III) If still not found, search in the "On Air Summary" tab.
• (IV) If not found, search in the "Dismantled Sites" tab.

D. For Node Type SRAN:
• (I) Search first in the "2G Huawei / 3G Huawei / LTE Huawei / 5G Huawei" tabs.
• (II) If not found, search in the "2G MMM / 3G MMM / LTE MMM / 5G MMM" tabs.
• (III) If still not found, search in the "On Air Summary" tab.
• (IV) If not found, search in the "Dismantled Sites" tab.

E. For Node Type BSC: Updated in the "site matching sheet."
F. For Node Type RNC: Updated in the "site matching sheet."
G. For Node Type SRANController: Updated in 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 from the naming convention.

Best regards,
Indrasan