{"id":"csv-split-column","version":"1.0.0","description":"Split one CSV column on an exact separator into uniquely named columns.","supported_operations":["csv split column","split a csv column by exact separator","expand csv column into named columns"],"unsupported_operations":["regex split","infer column names","trim cells","limit split parts without throwing","fuzzy matching","read files","fetch urls"],"semantics":["The first CSV record is the header row. An empty document is rejected; a header-only document yields the replaced headers and zero data rows.","column must name an existing header exactly. separator is a non-empty literal string of at most 16 UTF-16 code units, never a regular expression.","Each data cell is split with String.prototype.split(separator). More parts than names.length is rejected; fewer parts are padded with empty strings on the right.","names is 2 to 16 unique non-empty headers. A name may equal column (in-place replacement) but must not equal any other remaining header.","The original column is replaced in place by names, in names order. No trimming, case folding, or type coercion is performed.","The first output header name may not begin with U+FEFF because it is ambiguous with a CSV byte-order mark."],"limits":{"max_input_bytes":256000,"max_data_rows":5000,"max_columns":256,"max_header_name_bytes":256,"min_names":2,"max_names":16,"max_separator_chars":16,"max_output_bytes":256000},"pricing":{"status":"unpriced","charge_usd":null},"input_schema":{"type":"object","additionalProperties":false,"required":["csv","column","separator","names"],"properties":{"csv":{"type":"string","maxLength":256000},"column":{"type":"string","minLength":1,"maxLength":256},"separator":{"type":"string","minLength":1,"maxLength":16},"names":{"type":"array","minItems":2,"maxItems":16,"uniqueItems":true,"items":{"type":"string","minLength":1,"maxLength":256}}}},"output_schema":{"type":"object","additionalProperties":false,"required":["csv"],"properties":{"csv":{"type":"string"}}},"examples":[{"input":{"csv":"city,name\nLondon,Ada Lovelace\nParis,Grace Hopper\n","column":"name","separator":" ","names":["first","last"]},"output":{"csv":"city,first,last\nLondon,Ada,Lovelace\nParis,Grace,Hopper\n"}}],"execute_url":"/v1/tools/csv-split-column/versions/1.0.0/execute"}