gptcleanuppro.com / tilde-to-json-array
Ready · local0w
Works with text copied from
ChatGPTClaudeGeminiGrokCopilotPerplexity
delimiter recognised
1
bytes sent to a server
0
length or run limit
None

The tool

A precise tilde to JSON array converter

This tool takes a line delimited with the tilde character, '~', and splits it on every tilde, trims each value, and returns a formatted JSON array. It addresses the same category of source as the caret converter: older, fixed-format exports that chose a character unlikely to appear inside ordinary field values.

The conversion runs entirely in JavaScript in your browser. There is no request sent to a server, and no run limit, since nothing here costs anything to serve.

Where the format comes from

Why older exports settled on the tilde specifically

Certain legacy flat-file and EDI-adjacent formats required a field separator unlikely to occur inside a name, an amount or a code, the way a comma or a space so frequently does. The tilde was one character selected for that reason, rare enough in ordinary business text to serve as a deliberate, low-collision delimiter.

That choice persists in older systems, integrations and archived exports built on that assumption, even as modern formats have largely moved to comma-separated files or JSON.

How it works

How to convert a tilde-delimited line to JSON in three steps

No configuration, no format to declare in advance.

Step 1
Paste the tilde-delimited line into the input field.
Step 2
Press Convert. The split and trim run instantly, client side.
Step 3
Copy the resulting JSON array from the output panel.

Why it matters

Where a tilde legitimately appears outside a delimited export

The tilde is rarer than a comma or a space in ordinary prose, but not universally. On Unix or Linux systems, '~' is shorthand for a home directory, so a shell path such as '~/Documents/report.txt' carries one. In casual writing, a tilde preceding a number, '~10 items', signals an approximation. In a package.json file, an npm version range such as '~1.2.3' uses one to indicate a compatible minor version.

Pasting a line that mixes genuinely delimited fields with any of these, a file path, an approximate figure, a version string, causes the internal tilde to be split apart alongside the real field boundaries.

The underlying tradeoff

Why rarity, not invisibility, is what makes a delimiter reliable

A tilde is a fully visible, ordinary keyboard character, unlike a zero-width space or a non-breaking space. Its usefulness as a delimiter comes not from being hidden but from being uncommon in the specific kind of data typically exported, names, amounts, codes, dates. The moment that data includes a shell path, a version string or an approximation, the assumption of rarity no longer holds.

This is the same constraint the caret converter operates under, and every rare-character delimiter in this family: the choice works precisely because the data was expected to be ordinary business content rather than technical text.

Straight answer

Is tilde delimiting still common in current systems?

Not especially. Most modern exports and APIs have moved to comma-separated files, JSON or JSON lines. It survives chiefly in older systems, legacy integrations and archived exports that were never rebuilt.

A fresh export from a current system is unlikely to use a tilde delimiter. An older flat-file format or a legacy integration is a genuine possibility worth checking.

Who it's for

Who uses a tilde to JSON array converter, and when

Developers and integration engineers working with an older system's flat-file export use it to get a single tilde-delimited row into JSON without building a dedicated parser for a legacy format that is otherwise rarely touched. Anyone migrating data out of an older EDI-adjacent or mainframe-connected system uses it to inspect a sample row before writing a proper import.

It also surfaces during data archaeology, opening an old export file to understand its structure before deciding what to do with the data it holds.

FAQ

Tilde to JSON array, answered precisely

All answered in full, nothing to click open.

How do I convert a tilde-delimited line to a JSON array?

Paste the line into the input field and press Convert. Each tilde-separated value becomes one array item.

Is it free?

Yes. No signup, no length cap, no run limit, since the conversion runs on your own device.

Is my text uploaded anywhere?

No, the split runs entirely client side. Nothing is transmitted, stored or logged.

Why do some exports use a tilde instead of a comma?

A tilde almost never appears in ordinary business data, names, amounts, dates, making it a safer delimiter choice than a comma for older export formats.

Will it split apart a shell path like ~/Documents?

Yes, a tilde used as home-directory shorthand is indistinguishable from a delimiter here and is split accordingly.

Will it split apart an npm version range like ~1.2.3?

Yes, the tilde in a version range is treated as a delimiter here, breaking the version string apart.

Does it work on modern exports as well?

It splits any tilde-delimited text regardless of age, though tilde delimiting today is mostly confined to older, legacy formats.

What happens to whitespace around each value?

It's trimmed automatically, removing any stray spacing around a value.

What happens with two consecutive tildes?

The empty item between them is dropped rather than retained as a blank entry.

Is there a length limit on the input?

No. There's no cap and no run limit, only your device's own memory.

Does it work on phones?

Yes, the layout adapts to narrow screens.

What's the difference between this and the caret converter?

Both address the same class of legacy delimited export, chosen for rarity, but this splits on a tilde and the other on a caret. Use whichever character your source file contains.

Will it split apart an approximate value like ~10 items?

Yes, that tilde is treated identically to any other, so casual text using it to mean approximately is split apart if pasted.

Is there an API or batch mode?

Not currently. This is a single-line, browser-based converter.

How do I determine whether my export uses a tilde delimiter?

Open the raw file in a plain text editor and check for a tilde appearing at regular intervals between values.

Is the output guaranteed to be valid JSON?

Yes, it's constructed with JSON.stringify. It cannot confirm the split points matched your data's intent, only that the result parses.

Can I use this on healthcare or insurance data exports?

Yes, tilde delimiting appears in some legacy back-office formats in those industries. Paste a sample row to check the structure.

Is confidential data safe to paste here?

Yes, nothing is transmitted anywhere. Processing happens locally in your browser.

Can I convert several rows in one pass?

The converter treats the whole paste as one sequence, so multiple rows produce one combined array. Convert one row at a time for cleaner results.

What's the difference between this and the custom delimiter tool?

This converter is fixed to a tilde. The custom delimiter tool accepts any separator you type, useful when a source uses a different rare character.

Convert a tilde-delimited line to JSON.

Computed locally, no upload, no run limit.

Open the converter