Skip to content

Implement TEXTSPLIT function #55

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)

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions