Skip to content

splitByRegexp function #19386

@alexey-milovidov

Description

@alexey-milovidov

Describe the solution you'd like
Similar to splitByChar and splitByString but with regular expression as a separator.

Use case
There is a string column containing a list of data items in unusual format. I want to parse it inside ClickHouse.

Alternatives
extractAll(s, '(.+?)separator') will do something similar but splitByRegexp can be more convenient.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions