Reads a text file, CSV 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.
Can also filter data on given number of records and returns only required data in array.
Installation
npm i --save data-to-json
Usage
data-to-json
support CommonJS.
In module system
Use filePath
key to provide TEXT or CSV data from a file
.
const dataToJson = ;
Use .txt
to use TXT data.
const dataInJSON = dataToJson;
OR
Use .csv
to use CSV data.
const dataInJSON = dataToJson;
Use data
key to provide TEXT data from variable or directly
.
const dataInJSON = dataToJson;
OR
const dataInJSON = dataToJson;
Sample input (txt data) :
FIRST_NAME LAST_NAME NUMBER EMAIL ADDRESS
Debra Burks 880012XXXX debra.burks@yahoo.com 9273 Thome Ave., `Orchard Park`, NY - 14127
Kasha Todd null kasha.todd@yahoo.com 910, Vine Street!!!, (Campbell), CA - 95008
Tameka Fisher 880111XXXX null 7693 ~ Honey Creek St., Redondo Beach, "CA" 90278
Sample input (csv data) :
FIRST_NAME,LAST_NAME,NUMBER,EMAIL,ADDRESS
Debra,Burks,880012XXXX,debra.burks@yahoo.com,"9273 Thome Ave., `Orchard Park`, NY - 14127"
Kasha,Todd,null,kasha.todd@yahoo.com,"910, Vine Street!!!, (Campbell), CA - 95008"
Tameka,Fisher,8800111XXX,null,"7693 ~ Honey Creek St., Redondo Beach, "CA" 90278"
Sample output (json data) :
[
{
FIRST_NAME: 'Debra',
LAST_NAME: 'Burks',
NUMBER: '880012XXXX',
EMAIL: 'debra.burks@yahoo.com',
ADDRESS: '9273 Thome Ave., `Orchard Park`, NY - 14127'
},
{
FIRST_NAME: 'Kasha',
LAST_NAME: 'Todd',
NUMBER: null,
EMAIL: 'kasha.todd@yahoo.com',
ADDRESS: '910, Vine Street!!!, (Campbell), CA - 95008'
},
{
FIRST_NAME: 'Tameka',
LAST_NAME: 'Fisher',
NUMBER: '880111XXXX',
EMAIL: null,
ADDRESS: '7693 ~ Honey Creek St., Redondo Beach, "CA" 90278'
}
]
Use .records
to get required number of rows.
const dataInJSON = dataToJson;
OR
const dataInJSON = dataToJson;
.records
is 1
(json data) :
Sample output when [
{
FIRST_NAME: 'Debra',
LAST_NAME: 'Burks',
NUMBER: '880012XXXX',
EMAIL: 'debra.burks@yahoo.com',
ADDRESS: '9273 Thome Ave., `Orchard Park`, NY - 14127'
}
]
References
- To convert only text to json. Try - https://www.npmjs.com/package/txt-file-to-json
- To convert only csv to json. Try - https://www.npmjs.com/package/csv-file-to-json