txt-file-to-json

txt-file-to-json

Reads a text file or data variable having a table and returns an array of obects. In which each object consists of all headers as keys and there data as values.

Installation

npm i --save txt-file-to-json

Usage

txt-file-to-json support CommonJS.

In module system

Use filePath key to provide TEXT data from file.

const txtToJson = require("txt-file-to-json");
const dataInJSON = txtToJSON({ filePath: "./filePath.txt" });

Use data key to provide TEXT data from variable or directly.

const txtToJSON = require("txt-file-to-json");
const dataInJSON = txtToJSON({ data: someTEXTData });

Sample input (txt data) :

FIRST_NAME     LAST_NAME        NUMBER               EMAIL                        ADDRESS
Debra          Burks            880012XXXX           [e-mail]        9273 Thome Ave., Orchard Park, NY - 14127
Kasha          Todd             null                 [e-mail]         910, Vine Street, Campbell, CA - 95008
Tameka         Fisher           880111XXXX           [e-mail]      7693 Honey Creek St., Redondo Beach, CA - 90278
Daryl          Spence           990015XXXX           null                         988 Pearl Lane!!! (Uniondale), NY - 11553
Charolette     Rice             720012XXXX           [e-mail]      107 ~ River Dr. `Sacramento`, "CA"      95820

Sample output (json data) :

[
  {
    FIRST_NAME: 'Debra',
    LAST_NAME: 'Burks',
    NUMBER: '880012XXXX',
    EMAIL: '[e-mail]',
    ADDRESS: '9273 Thome Ave., Orchard Park, NY - 14127'
  },
  {
    FIRST_NAME: 'Kasha',
    LAST_NAME: 'Todd',
    NUMBER: null,
    EMAIL: '[e-mail]',
    ADDRESS: '910, Vine Street, Campbell, CA - 95008'
  },
  {
    FIRST_NAME: 'Tameka',
    LAST_NAME: 'Fisher',
    NUMBER: '880111XXXX',
    EMAIL: '[e-mail]',
    ADDRESS: '7693 Honey Creek St., Redondo Beach, CA - 90278'
  },
  {
    FIRST_NAME: 'Daryl',
    LAST_NAME: 'Spence',
    NUMBER: '990015XXXX',
    EMAIL: null,
    ADDRESS: '988 Pearl Lane!!! (Uniondale), NY - 11553'
  },
  {
    FIRST_NAME: 'Charolette',
    LAST_NAME: 'Rice',
    NUMBER: '720012XXXX',
    EMAIL: '[e-mail]',
    ADDRESS: '107 ~ River Dr. `Sacramento`, "CA"      95820'
  }
]

Use noOfRecords key along with filePath or data key to get data of specific number of rows.

const txtToJson = require("txt-file-to-json");
const dataInJSON = txtToJSON({ filePath: "./filePath.txt", noOfRecords: 1 });

Sample output when noOfRecords is 1 (json data) :

[
  {
    FIRST_NAME: 'Debra',
    LAST_NAME: 'Burks',
    NUMBER: '880012XXXX',
    EMAIL: '[e-mail]',
    ADDRESS: '9273 Thome Ave., Orchard Park, NY - 14127'
  }
]