Regex in php excluding values

Question

I have these lines of text ($text variable)

CC 1,00
SS 1,00
PP 1,00
1,00
FF 1,00

now I would like to have only the numeric part of each line returned to me. But the important thing must be that I don't have to take lines that start with certain characters, like I would like to exclude "SS", "PP" and "FF". So I would like it to return me only the values of "CC" and only the numeric ones without leading characters.

In the meantime I have done this but it doesn't seem to work

preg_match_all("/((?!.SS|.FF|.PP).*\d{1,2}[\,\.]{1}\d{1,2})\w+/", $text, $matches);

Unfortunately, I don't get the desired result, where am I wrong? Thanks

anotherGatsby · Accepted Answer · 2022-03-16 12:39:49Z

1

I modified your regex to this: ^(?!SS|FF|PP).*(\d{1,2}[,.]\d{1,2})

Test here: https://regex101.com/r/SAivli/2

$re = '/^(?!SS|FF|PP).*(\d{1,2}[,.]\d{1,2})$/m';
$str = 'CC 1,00
SS 1,00
PP 1,00
1,00
FF 1,00';

preg_match_all($re, $str, $matches, PREG_SET_ORDER, 0);

// Print the entire match result
print_r($matches);
//Array ( [0] => Array ( 
//                        [0] => CC 1,00 
//                        [1] => 1,00 
//                      )
//         [1] => Array ( [0] => 1,00
//                        [1] => 1,00 
//                      )
//        )

This matches both the numbers that:

begin with CC
dont have any leading alpha characters

edited Mar 16, 2022 at 12:39

answered Mar 16, 2022 at 12:14

anotherGatsby

1,59811 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

The fourth bird · Accepted Answer · 2022-03-16 12:17:04Z

You can anchor the negative lookahead to the start of the string, and omit the leading dots in .SS as it matches a single character.

You can also omit the {1} and the backslashes in [\,\.]

As there are no other characters in the examples besides spaces and 2 uppercase characters, you can change .* to match [A-Z]{2} followed by optional horizontal whitespace chars \h*

Omit the \w+ at the end because there are no more word characters and the + expects at least a single char.

^(?!SS|FF|PP)[A-Z]{2}\h*\K\d{1,2}[,.]\d{1,2}$

^ Start of string
(?!SS|FF|PP) Assert not any of the alternatives to the right
[A-Z]{2} Match 2 uppercase chars
\h*\K Match optional whitespace chars and forget what is matched so far
\d{1,2}[,.]\d{1,2} Match 1-2 digits followed by either . or , and again 1-2 digits
$ End of string

regex demo

$re = '/^(?!SS|FF|PP)[A-Z]{2}\h*\K\d{1,2}[,.]\d{1,2}$/m';
$text = 'CC 1,00
SS 1,00
PP 1,00
1,00
FF 1,00';

preg_match_all($re, $text, $matches);

print_r($matches[0]);

Output

Array
(
    [0] => 1,00
)

Collectives™ on Stack Overflow

Regex in php excluding values

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related