Dataczar
Browse helpers

API Reference / data / text-columns-splitter

Split a text column into multiple CSV columns.

Split a column (e.g., "Full Name") by spaces, commas, or any delimiter and write the parts into new columns. Drop this helper wherever you want to split a text column into multiple CSV columns with a single HTTP call. Send the documented inputs and the API streams back polished results you can hand directly to your users.

GETPOST/data/text-columns-splitter

Where this helper shines

Split a text column into multiple CSV columns. keeps data helpers on autopilot. Use it whenever you need to split a text column into multiple CSV columns without pausing a sprint or asking design/dev to jump in.

  • Trigger this helper whenever you need to split a text column into multiple CSV columns without waiting on a full deploy.
  • Drop it into automations (Zapier, Make, workers) to split a text column into multiple CSV columns as part of your workflow.
  • Share the GET URL so support and success can split a text column into multiple CSV columns safely using their Dataczar API key.

Copy & ship snippets

GET

Instant link

GET https://api.dataczar.app/data/text-columns-splitter?delimiter=%2C&column=sample-column&splitter=+&limit=0&ak=demo

Open directly in any browser, webhook, or low-code workflow.

curl

curl GET

curl "https://api.dataczar.app/data/text-columns-splitter?delimiter=%2C&column=sample-column&splitter=+&limit=0&ak=demo"

Swap ak=demo with your Dataczar API key.

curl

curl POST

curl -X POST "https://api.dataczar.app/data/text-columns-splitter?ak=demo" \
  -H 'Content-Type: application/json' \
  -d '{
  "file": "sample_file"
}'

Send JSON payloads from back-end jobs, queues, or workers.

Parameters

Query Parameters

NameTypeDescription
delimiterstring
columnstring · required
splitterstring
limitintegerMaximum number of parts; remaining text is preserved in the last column.
prefixstring
dryrunboolean

All helper calls accept your Dataczar key via the ak query parameter. Need one? Create or copy a key on Dataczar Connect and drop it into each request.

Responses

Status 200

CSV output with the new columns appended.

Examples

Query parameters

Equivalent curl
Grab your Dataczar API key
Every helper runs with the same simple API key. Sign in (or create a free Dataczar account) at Dataczar Connect to issue keys in seconds, then drop the key into any `ak=` parameter and start shipping.
Get your API keyBrowse helpers
Tip: reuse the same key across these helpers, or rotate keys per project from the Connect dashboard.