From 538d83257a71a0795071d104343ac3b1e35a1569 Mon Sep 17 00:00:00 2001
From: Sergey Chebotar <s.chebotar@gmail.com>
Date: Mon, 4 Jul 2022 09:08:02 +0300
Subject: Add SKU Parser Function

---
 src/AddIn/Functions.cs | 13 +++++++++++++
 1 file changed, 13 insertions(+)

(limited to 'src/AddIn/Functions.cs')

diff --git a/src/AddIn/Functions.cs b/src/AddIn/Functions.cs
index 618d17d..867e246 100644
--- a/src/AddIn/Functions.cs
+++ b/src/AddIn/Functions.cs
@@ -52,5 +52,18 @@ namespace RehauSku
                     return null;
             }
         }
+
+        [ExcelFunction(Description = "Получение корректного артикула из строки")]
+        public static object GETRAUSKU([ExcelArgument(Name = "\"Строка\"", Description = "строка, содержащая актикул")] string line)
+        {
+            RauSku rausku;
+
+            if (RauSku.TryParse(line, out rausku))
+            {
+                return rausku.ToString();
+            }
+
+            else return ExcelError.ExcelErrorNA;
+        }
     }
 }
\ No newline at end of file
-- 
cgit v1.2.3