正则表达式匹配逗号分隔的数字具有可选的小数部分小数、逗号、可选、部分

由网友(野心与梦想)分享简介:我有一个正则表达式匹配逗号分隔的数字,在一个给定的多行文本可选两位小数部分。I've a regex that matches comma separated numbers with an optional two digit decimal part in a given multiline text./(?<...

我有一个正则表达式匹配逗号分隔的数字,在一个给定的多行文本可选两位小数部分。

I've a regex that matches comma separated numbers with an optional two digit decimal part in a given multiline text.

/(?<=s|^)d{1,3}(,d{3})*(.d{2})?(?=s|$)/m

它匹配像1,12,12.34,成功12,345.67等字符串。如何修改它的一些搭配只喜欢 0.23

编辑:只是为了澄清 - 我想修改的正则表达式,使其符合 12 12.34 0.34

Just to clarify - I would like to modify the regex so that it matches 12, 12.34 and .34

和我期待的'独立'的有效数字。即,数字串,其边界要么是空白或启动/行/字符串的结尾。

And I am looking for 'stand alone' valid numbers. i.e., number-strings whose boundaries are either white space or start/end of line/string.

推荐答案

本:

d{1,3}(,d{3})*(.dd)?|.dd

符合以下所有的数字:

matches all of the following numbers:

1
12
.99
12.34 
12,345.67
999,999,999,999,999.99

如果你想为排除如 123A 号码(街道地址为例),或 123.123 (数字超过2小数点后的数字),请尝试:

If you want to exclude numbers like 123a (street addresses for example), or 123.123 (numbers with more than 2 digits after the decimal point), try:

(?<=s|^)(d{1,3}(,d{3})*(.dd)?|.dd)(?=s|$)

一个小的演示(我猜你正在使用PHP):

A little demo (I guessed you're using PHP):

$text = "666a 1 fd 12 dfsa .99 fds 12.34 dfs 12,345.67 er 666.666 er 999,999,999,999,999.99";
$number_regex = "/(?<=s|^)(?:d{1,3}(?:,d{3})*(?:.dd)?|.dd)(?=s|$)/";
if(preg_match_all($number_regex, $text, $matches)) {
  print_r($matches);
}

这将输出:

Array
(
    [0] => Array
        (
            [0] => 1
            [1] => 12
            [2] => .99
            [3] => 12.34
            [4] => 12,345.67
            [5] => 999,999,999,999,999.99
        )

)

请注意,它忽略了字符串 666A 666.666

Note that it ignores the strings 666a and 666.666

阅读全文

相关推荐

最新文章