Choose your tool

DATA TOOL

Fixed-Width Text to JSON

Convert fixed-width text using named character lengths; preserve leading zeros.

◇ Browser only
0 lines · 0 characters
Ready when you are
Your results will appear here.
Copy or download your result below.
LESS BUSYWORK, MORE DONE

Three steps. That’s it.

A useful toolkit for text, data, images and calculations.

  1. 01

    Add your input

    Choose a tool, enter values or select a file.

  2. 02

    Make it yours

    Adjust the options and run the action.

  3. 03

    Take the result

    Copy the result or download its file.

Convert fixed-width text online

Decode a record using a field-width layout. The supplied layout defines boundaries; review whitespace and character versus byte widths.

How to use it

Enter Fixed-width records or select Try example. Review Fields: name:length, comma-separated, Trim field spaces, Include original row. Select Run tool and inspect the result before copying or downloading.

Options and example settings

OptionChoices / valueExample default
Fields: name:length, comma-separatedEnter a valuetype:3,id:5,name:10
Trim field spacesOn / OffOn
Include original rowOn / OffOn

Worked examples

Decode a record using a field-width layout.

Worked example — Fixed-Width Text to JSON

Settings: Fields: name:length, comma-separated: type:3,id:5,name:10; Trim field spaces: On; Include original row: On

Input:

SCT00042Anna      

Output:

[
  {
    "type": "SCT",
    "id": "00042",
    "name": "Anna",
    "_original": "SCT00042Anna      "
  }
]

The example returns 1 top-level item in an array. Each item is a record; the first record contains “type”, “id”, “name”, “_original”.

Limitations and common mistakes

  • The supplied layout defines boundaries; review whitespace and character versus byte widths.

Frequently asked questions

How can I transform fixed-width text online?

Enter Fixed-width records or select Try example. Review Fields: name:length, comma-separated, Trim field spaces, Include original row. Select Run tool and inspect the result before copying or downloading.

Where is my input processed?

The bundled tool processes input in your browser. It does not upload tool input to a conversion service. Other site plugins, analytics, advertising and browser extensions may have separate behavior.

Useful next tools

Explore other tools

Open a tool below, use the search, or choose a category to browse its full collection.