Skip to content

Implement TEXTSPLIT function #55

@Jython1415

Description

@Jython1415

Overview

Implement the TEXTSPLIT function for the named-functions library.

Description

Splits text strings by using column and row delimiters to create a 2D array.

Value Proposition

  • More advanced than Google Sheets native SPLIT function
  • Creates 2D arrays from delimited text (handles both row and column delimiters)
  • Essential for parsing complex structured text formats (CSV, TSV, etc.)
  • Enables powerful data transformation workflows

Priority

HIGH

Category

Text Manipulation

Implementation Notes

  • Support both row delimiter and column delimiter parameters
  • Handle cases with inconsistent column counts
  • Consider parameter for padding behavior when rows have different lengths
  • Should handle empty strings and consecutive delimiters
  • More complex than simple SPLIT - needs careful design

Related

Part of Excel function implementation initiative (#51)

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions