I'm reading 'live' server log information (before written to log.txt) into an MS-SQL database. All is well and performance is outstanding. I would like to improve my Regex parsing to clean-up my SQL data for easier processing. For instance,
This Regex will find any 'Port' number from 1 - 999999 contained within ( and ).......
(\((\d{1,6})\)) = (1) to (999999) Port Addresses
Although, I would like to 'Trim' off the ( and ) before it is written to the database so the port looks like 25 and not (25).
Q. How can I painlessly perform the 'Trim' task in Regex