我有多行包含一个具有不同值的字符串,其中一些具有数字,例如:
XARELTO 20 MG 14 COM.(A)(P)85003(SC)(SF)
我需要获取字符串上的数字,但只有“(P)”之后的数字才可以获取:
85003
忽略(P)之前和之后的所有字符85003
例如,以下是一些行:
| ProductName |
+----------------------------------------------+
| VALCOTE 125 MG 30 CAP.(P)15188(SC)(SF) |
+----------------------------------------------+
| ALPHAGAN SOL. OFT. 5 ML (A)(P)19347(SC) |
+----------------------------------------------+
| LUMIGAN 0.03% OF.3ML(A)(P)67740(SC)(3%+) |
+----------------------------------------------+
| BetaLOC ZOK 50 MG 30 TBS (P)15390 |
+----------------------------------------------+
| CASODEX 50 MGS 28 TBS (E)(P)104334(SC) |
+----------------------------------------------+
| SEROQUEL 100 MG 30 TBS(E)(A)(P)55800 |
+----------------------------------------------+
| SEROQUEL 200 MG 30 TBS (E)(A)(P)111600 |
+----------------------------------------------+
| SEROQUEL 25 MG 30 TBS (A)(P)13950 |
+----------------------------------------------+
这是我在SELECT语句之后需要的:
| ProductPrice |
+----------------------------------------------+
| 15188 |
+----------------------------------------------+
| 19347 |
+----------------------------------------------+
| 67740 |
+----------------------------------------------+
| 15390 |
+----------------------------------------------+
| 104334 |
+----------------------------------------------+
| 55800 |
+----------------------------------------------+
| 111600 |
+----------------------------------------------+
| 13950 |
+----------------------------------------------+