vba:functions:splitplus
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
vba:functions:splitplus [07.10.2016 11:05:15] yaslaw created |
vba:functions:splitplus [07.10.2016 11:11:20] (current) yaslaw |
||
|---|---|---|---|
| Line 30: | Line 30: | ||
| ===== Beispiele ===== | ===== Beispiele ===== | ||
| - | <code vb></code> | + | {{section>:snippets#vba_print_r&noheader&firstseconly}} |
| + | <code vb>'Trennung mit VBA.split() | ||
| + | d split("abc,'def,ghi'", ",") | ||
| + | <String()> ( | ||
| + | [0] => <String> 'abc' | ||
| + | [1] => <String> ''def' | ||
| + | [2] => <String> 'ghi'' | ||
| + | ) | ||
| + | |||
| + | 'und Dasselbe mit splitPlus | ||
| + | d splitPlus("abc,'def,ghi'", ",", "'") | ||
| + | <String()> ( | ||
| + | [0] => <String> 'abc' | ||
| + | [1] => <String> 'def,ghi' | ||
| + | ) | ||
| + | |||
| + | 'Und ein Beispiel mir Maskierten Zeichen. Maskieren immer mit \ | ||
| + | d splitPlus("ab\,c\\,'def,g\'hi',''", ",", "'") | ||
| + | <String()> ( | ||
| + | [0] => <String> 'ab,c\' | ||
| + | [1] => <String> 'def,g'hi' | ||
| + | [2] => <String> '' | ||
| + | )</code> | ||
| ===== Code ===== | ===== Code ===== | ||
| <source '%%fpath%%/%%fname%%' vb> | <source '%%fpath%%/%%fname%%' vb> | ||
vba/functions/splitplus.1475831115.txt.gz · Last modified: 07.10.2016 11:05:15 by yaslaw
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
