From d57fc1094625792b20d5ec713bcf9dfb1901ed68 Mon Sep 17 00:00:00 2001
From: fwq <582742538@qq.com>
Date: 星期五, 01 九月 2023 10:17:15 +0800
Subject: [PATCH] 增加Excel解析不为空的校验
---
src/main/java/com/hx/util/NumberUtil.java | 32 ++++++++++++++++++++++++++++++++
1 files changed, 32 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/hx/util/NumberUtil.java b/src/main/java/com/hx/util/NumberUtil.java
index 27d25e0..59b9581 100644
--- a/src/main/java/com/hx/util/NumberUtil.java
+++ b/src/main/java/com/hx/util/NumberUtil.java
@@ -3,6 +3,8 @@
import java.math.BigDecimal;
import java.math.RoundingMode;
import java.text.DecimalFormat;
+import java.util.regex.Matcher;
+import java.util.regex.Pattern;
/**
* 鏁板瓧宸ュ叿
@@ -351,4 +353,34 @@
return result2;
}
+ /**
+ * 浠庡瓧绗︿覆涓彁鍙栧皬鏁�
+ * @param str
+ * @return
+ */
+ public static String getNumber(String str){
+ // 鎺у埗姝ｅ垯琛ㄨ揪寮忕殑鍖归厤琛屼负鐨勫弬鏁�(灏忔暟)
+ Pattern p = Pattern.compile("(\\d+\\.\\d+)");
+ //Matcher绫荤殑鏋勯�犳柟娉曚篃鏄鏈夌殑,涓嶈兘闅忔剰鍒涘缓,鍙兘閫氳繃Pattern.matcher(CharSequence input)鏂规硶寰楀埌璇ョ被鐨勫疄渚�.
+ Matcher m = p.matcher(str);
+ //m.find鐢ㄦ潵鍒ゆ柇璇ュ瓧绗︿覆涓槸鍚﹀惈鏈変笌"(\\d+\\.\\d+)"鐩稿尮閰嶇殑瀛愪覆
+ if (m.find()) {
+ //濡傛灉鏈夌浉鍖归厤鐨�,鍒欏垽鏂槸鍚︿负null鎿嶄綔
+ //group()涓殑鍙傛暟锛�0琛ㄧず鍖归厤鏁翠釜姝ｅ垯锛�1琛ㄧず鍖归厤绗竴涓嫭鍙风殑姝ｅ垯,2琛ㄧず鍖归厤绗簩涓鍒�,鍦ㄨ繖鍙湁涓�涓嫭鍙�,鍗�1鍜�0鏄竴鏍风殑
+ str = m.group(1) == null ? "" : m.group(1);
+ } else {
+ //濡傛灉鍖归厤涓嶅埌灏忔暟锛屽氨杩涜鏁存暟鍖归厤
+ p = Pattern.compile("(\\d+)");
+ m = p.matcher(str);
+ if (m.find()) {
+ //濡傛灉鏈夋暣鏁扮浉鍖归厤
+ str = m.group(1) == null ? "" : m.group(1);
+ } else {
+ //濡傛灉娌℃湁灏忔暟鍜屾暣鏁扮浉鍖归厤,鍗冲瓧绗︿覆涓病鏈夋暣鏁板拰灏忔暟锛屽氨璁句负绌�
+ str = "";
+ }
+ }
+ return str;
+ }
+
}
--
Gitblit v1.8.0