regex to find a string, excluding comments
I need a regex to search for the string SQLHELPER that ignores commented code (single line comment or multi line comments). I am searching in visual studio.
Solution
You may use
(?<!^[\p{Zs}\t]*//.*)(?<!/\*(?:(?!\*/)[\s\S\r])*?)\bSQLHELPER\b
See the regex demo.
Details
(?<!^[\p{Zs}\t]*//.*)- a negative lookbehind that fails the match if, immediately to the left of the current location, the following pattern does not match:^- start of line[\p{Zs}\t]*- any 0+ horizontal whitespaces//- a//substring.*- any 0+ chars other than line break chars
(?<!/\*(?:(?!\*/)[\s\S\r])*?)- - a negative lookbehind that fails the match if, immediately to the left of the current location, the following pattern does not match:/\*- a/*substring(?:(?!\*/)[\s\S\r])*?- (tempered greedy token) any char (matched with[\s\S\r]), 0 or more repetitions but as few as possible (due to*?) that does not start a*/substring (due to the(?!\*/)negative lookahead)
\bSQLHELPER\b- a whole wordSQLHelper(\bare word boundaries).
- Commenting Regular Expressions
- How to correctly parse system call execution times from strace output using pipes in C?
- Looking for a simple regex to match any valid windows relative path, to be used in a Powershell script. (Case insensitive)
- regex to find a string, excluding comments
- RegEx for Username validation
- How to properly escape a backslash to match a literal backslash in single-quoted and double-quoted PHP regex patterns
- Regex for cryptocurrencies
- jQuery Regex validation query
- Java regular expression to match _all_ whitespace characters
- RegEx in Notepad++ to replace text in files with some exclusions
- How to filter word between two patterns - Linux
- Regular Expression for URL validation
- A more efficient Regex or alternative?
- search using regex in JPA
- Replace all occurrences that match regular expression
- Are wildcards in tests always faster?
- PostgreSQL adding carriage return(next line) from a long field's value
- Trying to assert a date format in Cypress that has white space
- ReactJS - How to fix regex error for email validation?
- REGEXP in SQLite - problem while editing table
- Printing first instance of match in each line of file (Perl)
- How can I store a regex pattern in a MySQL field and check an input against it?
- Regular expression to stop at first match
- php extract Emoji from a string
- Find all Git commits from authors whose email is not in certain domain (ex. abc.com)
- regular expression for finding decimal/float numbers?
- Different and same Regex in Ruby and JS on the same input
- Regular expression for only characters a-z, A-Z
- How do I renumber the numbers of this superscript?
- matching a line that doesn't contain specific text with regular expressions