lib_mysqludf_preg | Use PCRE regular expressions directly in MySQL | Regex library

I have an array of 5 numbers, I'd like to match as long as there are three of the same number and two of the same different number in the array, placement does not matter. Number sequences can be any random string of 5 numbers between 1 - 5. Examples of matches would be: 33322 24422 52225 44111 54545 *basically any grouping of 2 and 3 of the same numbers needs to match.

Best I've come up with so far: ^([0-9])\1{2}|([0-9])\1{1}$

I am not so good with regex, any help would be greatly appreciated.

Currently, this is my code.

I am generating some meaningful name with the following rule in a JavaScript/Node JS program:

Input: "tenancy_account__accountPublicId__workspace__workspacePublicId__remove-user__userPublicId"

Expected output: "TenancyAccountAccountPublicIdWorkspaceWorkspacePublicIdRemove-userUserPublicId"

Rules:

1. replace any character with zero or more underscore to the non-underscored uppercase Example:x | __*x => X
2. If exists remove last _

This is what is tried so far, looking for better alternatives, if any:

Java 11 added some new methods to the Pattern class (a compiled version of a regular expression), including:

• asPredicate
• asMatchPredicate

I am trying to understand the difference between the two and when I would want to use one over the other?

I am trying to replace a single occurrence of a character '1' in a String with a different character.

This same character can occur multiple times in the String which I am not interested in.

For example, in the below string I want to replace the single occurrence of 1 with 2.

I'm attempting to solve a very simple problem - find strings in an array which only contain certain letters. However, I've run up against something in the behavior of regular expressions and/or grep that I don't get.

I'm looking for a regexp that matches any line that contains 'B', 'R', 'A' and 'S' (in any order) at the start. It would match all the following lines, except the last two.

I have a Json file having multiple comments and I want to replace a value in it.

I tried the below and it gives me a json file without comments. But I don't understand how to change the value and save it back with comments. Is this even possible because we are replacing all the comments with empty lines?

The header question may not be easy to understand. Hope you can understand my detailed info below.

I have sentence data below, that has some tags, represented by [tn]tag[/tn]: