Regex Match Formula

SagarGite

There is a formula being applied on my data - REGEX_Match(ToString([INN]), "-?[0-9]+") the developer is no more with my company and i belive this formula highlits the records where there is any number in the field and i have a vleu - "THIAMINE (VITAMIN B1)" under this B1 there is 1 number available still it does not validated this formula which is correct for my need but i am not sure how this works?

sergejs_kutkovics

Overall, the formula is checking whether the string representation of the value in the [INN] field contains a valid integer pattern. If there is a match, it will return true, indicating that the value is a valid integer; otherwise, it will return false.

• -?: This part of the pattern allows for an optional minus sign at the beginning of the string, indicating a negative number.

• [0-9]+: This part of the pattern matches one or more digits (0 to 9).

With the example value you provided, I'd say the ToString([INN]) part is not necessary, as the value provided is already a string.