Differences

This shows you the differences between two versions of the page.

--- vba:functions:parsecsvline [12.01.2016 14:34:08]
yaslaw
+++ vba:functions:parsecsvline [12.01.2016 14:50:09]
yaslaw
@@ Line 2: / Line 2: @@
     version=1.0.0
     vdate=11.01.2016
-    fname=udf_parsecsvline
+    fname=udf_parsecsvline.bas
     ns=%NAMESPACE%
     fpath=/vba/functions
@@ Line 12: / Line 12: @@
 //==Version %%version%% %%vdate%%==
 {{%%fname%%|Download %%fname%% (V-%%version%%)}}
+===== Beispiele =====
+> Für die Ausgabe der Resultate verwendete ich die Funktion [[:vba:functions:print_r:]].
+<code vb>
+d parseCsvLine("123;abc;'def;ghi';;;0.12;")
+<String()>  (
+    [0] => <String> '123'
+    [1] => <String> 'abc'
+    [2] => <String> 'def;ghi'
+    [3] => <String> ''
+    [4] => <String> ''
+    [5] => <String> '0.12'
+    [6] => <String> ''
+)
+'Mit "" als Quote mit Trim
+d parseCsvLine("""abc;'def' "";0.12")
+<String()>  (
+    [0] => <String> 'abc;'def''
+    [1] => <String> '0.12'
+)
+'Mit ' Als Quote und ohne trim
+d parseCsvLine("'abc;""def ""';0.12",,,false)
+<String()>  (
+    [0] => <String> 'abc;"def "'
+    [1] => <String> '0.12'
+)
+'Mit dem Setting Delemiter = # Quote = '
+d parseCsvLine("12#""abc#def""#'ghi#jk'","#", "'")
+<String()>  (
+    [0] => <String> '12'
+    [1] => <String> '"abc'
+    [2] => <String> 'def"'
+    [3] => <String> 'ghi#jk'
+)</code>
 ===== Code =====
 <source '%%fpath%%/%%fname%%' vb>

Yaslaw.Info