Strings
String functions provide basic support for working with strings and regular expressions (regex). These functions allow for pattern matching, searching, and text manipulation within Excel. More functionality will be added in the future as the feature set expands.
String Functions
XBString_Split
Split a string into a range
=XBString_Split(stringValue, delimiter, [trimStrings], [ignoreEmpty])
| Parameter | Type | Description |
|---|---|---|
| stringValue | String |
A string |
| delimiter | String |
A delimiter |
| trimStrings | Boolean |
Optional Trim strings |
| ignoreEmpty | Boolean |
Optional Ignore empty strings |
Returns
A range
XBString_RegexMatch
Check a string for a regex match
=XBString_RegexMatch(stringValue, pattern, [caseSensitive])
| Parameter | Type | Description |
|---|---|---|
| stringValue | String |
A string |
| pattern | String |
A regex pattern |
| caseSensitive | Boolean |
Optional Case insensitive |
Returns
A boolean
XBString_RegexReplace
Split a string into a range
=XBString_RegexReplace(stringValue, pattern, replacement)
| Parameter | Type | Description |
|---|---|---|
| stringValue | String |
A string |
| pattern | String |
A regex pattern |
| replacement | String |
A replacement value |
Returns
A string