Regex for numbers only

Use the beginning and end anchors. Regex regex = new Regex(@”^\d$”); Use “^\d+$” if you need to match more than one digit. Note that “\d” will match [0-9] and other digit characters like the Eastern Arabic numerals ٠١٢٣٤٥٦٧٨٩. Use “^[0-9]+$” to restrict matches to just the Arabic numerals 0 – 9. If you need to … Read more

Regular expression to match DNS hostname or IP Address?

You can use the following regular expressions separately or by combining them in a joint OR expression. ValidIpAddressRegex = “^(([0-9]|[1-9][0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5])\.){3}([0-9]|[1-9][0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5])$”; ValidHostnameRegex = “^(([a-zA-Z0-9]|[a-zA-Z0-9][a-zA-Z0-9\-]*[a-zA-Z0-9])\.)*([A-Za-z0-9]|[A-Za-z0-9][A-Za-z0-9\-]*[A-Za-z0-9])$”; ValidIpAddressRegex matches valid IP addresses and ValidHostnameRegex valid host names. Depending on the language you use \ could have to be escaped with \. ValidHostnameRegex is valid as per RFC 1123. Originally, … Read more

Regular Expressions- Match Anything

Normally the dot matches any character except newlines. So if .* isn’t working, set the “dot matches newlines, too” option (or use (?s).*). If you’re using JavaScript, which doesn’t have a “dotall” option, try [\s\S]*. This means “match any number of characters that are either whitespace or non-whitespace” – effectively “match any string”. Another option … Read more

split string only on first instance of specified character

Use capturing parentheses: ‘good_luck_buddy’.split(/_(.*)/s) [‘good’, ‘luck_buddy’, ”] // ignore the third element They are defined as If separator contains capturing parentheses, matched results are returned in the array. So in this case we want to split at _.* (i.e. split separator being a sub string starting with _) but also let the result contain some … Read more

Regex lookahead, lookbehind and atomic groups

Examples Given the string foobarbarfoo: bar(?=bar) finds the 1st bar (“bar” which has “bar” after it) bar(?!bar) finds the 2nd bar (“bar” which does not have “bar” after it) (?<=foo)bar finds the 1st bar (“bar” which has “foo” before it) (?<!foo)bar finds the 2nd bar (“bar” which does not have “foo” before it) You can … Read more

Find and extract a number from a string

\d+ is the regex for an integer number. So //System.Text.RegularExpressions.Regex resultString = Regex.Match(subjectString, @”\d+”).Value; returns a string containing the first occurrence of a number in subjectString. Int32.Parse(resultString) will then give you the number.

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)