VXTEXTSPLIT Function

Created by Harry Lewis, Modified on Wed, 6 Sep, 2023 at 5:13 PM by Harry Lewis

Applies to:

Velixo Classic and Velixo NX

Description

The VXTEXTSPLIT function takes a delimited list (values separated by a common character) and separates the values in that list into an array of rows.

Examples include a list of comma-separated values: 1,2,3,4,5

⚠️ Prior to version 7.0.282, the function is named TEXTSPLIT. Velixo renamed this function to VXTEXTSPLIT to avoid conflicts with the newly released Excel TEXTSPLIT function from Microsoft, which has a different set of parameters.

TABLE OF CONTENTS

Syntax
Parameters
Examples
- Example 1
- Example 2

Syntax

VXTEXTSPLIT(Text [or cell reference], delimiter])

Parameters

The VXTEXTSPLIT function uses the following parameters:

Parameter	Required/Optional	Description
Text	Required	The delimited text to be separated (may be typed into the function or be in a separate cell).
Delimiter	Required	The character that is used - in the Text - to separate the values.

Examples

Example 1

=VXTEXTSPLIT(D7,";")

Description

Cell D7 contains a list separated by semicolons (and includes a blank value).

Results:

Example 2

=VXTEXTSPLIT("abc;xyz;123;890",";")

Description

Returns the segments abc, xyz, 123, and 890 as elements of a dynamic array.

Result: