Please enable JavaScript to view this site.

itgendoc001X

xMsg javascript has not been loaded.

Windows Data Model

Navigation: » No topics above this level «

regexp_split_row: Windows Split Row on Regular Expression

 Contents Previous Home Next More

Catalog: FileSystem

Label: Split Row on Regular Expression

This is a read-only table function. The Windows API may not support changing the data or the Invantive SQL driver for Windows does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Windows API.

Table Function Parameters

The following parameters can be used to control the behaviour of the table function regexp_split_row. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be treated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example with `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.

Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.

Name

Data Type

Required

Default Value

Documentation

regex

string

☑

 

Regular expression to use.

row

string

☑

 

Text to split into individual rows using a regular expression.

 

Table Function Columns

The columns of the table function regexp_split_row are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

input_text

string

Original Input

 

Original input.

regular_expression

string

Regular Expression

 

Regular expression used to split.

success

boolean

Success

 

Could content be split.

text_content_1

string

 

 

Split content of the text file.

text_content_10

string

 

 

Split content of the text file.

text_content_11

string

 

 

Split content of the text file.

text_content_12

string

 

 

Split content of the text file.

text_content_13

string

 

 

Split content of the text file.

text_content_14

string

 

 

Split content of the text file.

text_content_15

string

 

 

Split content of the text file.

text_content_16

string

 

 

Split content of the text file.

text_content_17

string

 

 

Split content of the text file.

text_content_18

string

 

 

Split content of the text file.

text_content_19

string

 

 

Split content of the text file.

text_content_2

string

 

 

Split content of the text file.

text_content_20

string

 

 

Split content of the text file.

text_content_21

string

 

 

Split content of the text file.

text_content_22

string

 

 

Split content of the text file.

text_content_23

string

 

 

Split content of the text file.

text_content_24

string

 

 

Split content of the text file.

text_content_25

string

 

 

Split content of the text file.

text_content_26

string

 

 

Split content of the text file.

text_content_27

string

 

 

Split content of the text file.

text_content_28

string

 

 

Split content of the text file.

text_content_29

string

 

 

Split content of the text file.

text_content_3

string

 

 

Split content of the text file.

text_content_30

string

 

 

Split content of the text file.

text_content_31

string

 

 

Split content of the text file.

text_content_32

string

 

 

Split content of the text file.

text_content_33

string

 

 

Split content of the text file.

text_content_34

string

 

 

Split content of the text file.

text_content_35

string

 

 

Split content of the text file.

text_content_36

string

 

 

Split content of the text file.

text_content_37

string

 

 

Split content of the text file.

text_content_38

string

 

 

Split content of the text file.

text_content_39

string

 

 

Split content of the text file.

text_content_4

string

 

 

Split content of the text file.

text_content_40

string

 

 

Split content of the text file.

text_content_41

string

 

 

Split content of the text file.

text_content_42

string

 

 

Split content of the text file.

text_content_43

string

 

 

Split content of the text file.

text_content_44

string

 

 

Split content of the text file.

text_content_45

string

 

 

Split content of the text file.

text_content_46

string

 

 

Split content of the text file.

text_content_47

string

 

 

Split content of the text file.

text_content_48

string

 

 

Split content of the text file.

text_content_49

string

 

 

Split content of the text file.

text_content_5

string

 

 

Split content of the text file.

text_content_50

string

 

 

Split content of the text file.

text_content_6

string

 

 

Split content of the text file.

text_content_7

string

 

 

Split content of the text file.

text_content_8

string

 

 

Split content of the text file.

text_content_9

string

 

 

Split content of the text file.

 

17-05-2021 11:56 Version 20.1.419-BETA+3191