我需要在句號之前提取數字。
示范文本
REFERENCE DATE DOC.NUM INV.AMOUNT DED INV.AMOUNT.
91300730 20211018 2151229942 1367579.73 0.00 -1367579.73.
.
91300622 20211013 2151226915 167554.96 0.00 167554.96.
.
91300608 20211013 2151226910 1367579.73 0.00 1367579.73.
.
91300621 20211013 2151226909 729375.52 0.00 729375.52.
預期成果是:-1367579.73.,167554.96.,1367579.73.和729375.52.。
uj5u.com熱心網友回復:
假設我們可以將句點識別為換行符或輸入結尾之后的句點,我們可以嘗試:
-?\d (?:\.\d )?(?=\.(?:\n|$))
演示
這說匹配:
-? optional negative sign
\d a whole number
(?:\.\d )? followed by an optional decimal component
(?=\.(?:\n|$)) followed by dot, then a newline or end of the input
uj5u.com熱心網友回復:
這應該讓你開始:
/\s(-*[0-9\.]*)\.\s/
轉載請註明出處,本文鏈接:https://www.uj5u.com/qukuanlian/409290.html
標籤:
