Hello this may be a long shot but I need some assistance with data validation.
We are currently using a new tool to automate firewall requests in our network which will pull the requested information from an spreadsheet
Currently for the protocol / ports the users are requesting it is formatted like this
Single Port Request:
Users may continue to add as many ports as they require as long as they are separated by a comma
TCP 80, 443
Users may continue to add as many ports ranges as they require as long as they are separated by a comma
UDP 5000-5010, 5030-5040
The validation that I require is as follows
1.) All requests must start with either TCP or UDP not both
2.) All ports must be between 0 to 65535.
3.) No other characters or unnecessary spaces within the cell
Any help or insight would be greatly appreciated as I don't even know if this is possible to perform.
Open in new window