A regEx to validate a mongoDb connection string like the following: mongodb+srv://user:pass@subdomain.domain.com:27107/fDb/?replicaSet=myRepl&ssl=true

Convert "text" to ``text''

Regex to validate a Nigerian phone number

Nice if you need to remove or extract the last word\string on a line.

Now that we have Income in a column we can split it up into upper and lower as they are two different values. We can use multiple ways to extract this information, seperate, extract, or case_when. I will be using extract as this provides the best way to collect this information.

^\-?\$0-1+(\.[0-9]{2,2})?$|^\-?\$[0-5]+(\.[0-9]{2,2})?$

a

Specialists index

1

Allows Number: Currency amount US (cents optional) Can use US-style 123,456.78 notation Optional thousands separators; optional two-digit fraction; commas; dollar sign

check for urls

/^(?=.?[A-Z])(?=.?[a-z])(?=.?[0-9])(?=.?[#?!@$%^&-]).$/gm

/^(?=.?[a-zA-Z])(?=.?[0-9])/gm

Useful for adding JsonPropertyName to a bunch of class members. Given: ` public string MemberId { get; set; } `...

Regex to match tcp/udp port and range. Comma can be used as delimiter

This is used to check and grab parts from our box # format at our production facility.

This Regex can be used to validate the different format of colors in the HTML

Example input-pattern for the Friendzymes GitHub Action dna-annotate.

Modified from this StackOverflow answer, this Regex matches a word or phrase which is not preceded by another word or phrase

Requirements: At least one lower and one upper case letter At least one digit or special character