The array within the JSON object holds vital information [Typescript]

Question

The array within the JSON object holds vital information [Typescript]

I have some data stored in an Excel file that I want to import into my database. The first step was exporting the file as a CSV and then parsing it into a JSON object.

fname,lname,phone
Terry,Doe,[123456789]
Jane,Doe,[123456788, 123456787]

Upon converting the CSV to a JSON object, I noticed that the phone numbers were being treated like strings within arrays.

[
 {
   "fname": "Terry",
   "lname": "Doe",
   "phone": "[123456789]",
 },
 {
   "fname": "Jane",
   "lname": "Doe",
   "phone": "[123456788", 123456787]"
 }
]

What I really need is a JavaScript object where I can interact with the data more easily, such as accessing individual elements like:

convertedData[0].phone[0]

Is there a way to achieve this?

javascript arrays json typescript csv

Answer 1

Answer №1

Although accessing data[0].phone directly may not work, you can achieve the same result by using data[0]["phone"] instead.

//This section can be customized for your CSV parsing needs - I organized it this way for easy testing.
const rawData = "fname,lname,phone\nTerry,Doe,[123456789]\nJane,Doe,[123456788, 123456787]";
const lines = rawData.split("\n");

const data = [];
const keys = [];
lines[0].split(",").forEach((key) => keys.push(key));
for (let i = 1; i < lines.length; i++) {
    const line = lines[i];
    const parsedLine = {}
    line.split(",").forEach((value, index) => parsedLine[keys[index]] = value);
    data.push(parsedLine);
}

//Test case example
console.log(data[0]["phone"])

Answer 2

Although accessing data[0].phone directly may not work, you can achieve the same result by using data[0]["phone"] instead.

//This section can be customized for your CSV parsing needs - I organized it this way for easy testing.
const rawData = "fname,lname,phone\nTerry,Doe,[123456789]\nJane,Doe,[123456788, 123456787]";
const lines = rawData.split("\n");

const data = [];
const keys = [];
lines[0].split(",").forEach((key) => keys.push(key));
for (let i = 1; i < lines.length; i++) {
    const line = lines[i];
    const parsedLine = {}
    line.split(",").forEach((value, index) => parsedLine[keys[index]] = value);
    data.push(parsedLine);
}

//Test case example
console.log(data[0]["phone"])

The array within the JSON object holds vital information [Typescript]

Answer №1

Similar questions

Selecting JSONB keys in a case-insensitive manner in PostgreSQL (version 9.4 and newer)

Align Image According to Dimensions of the Browser

What is the most efficient approach to handle the next state after calling setState in react with immer?

Oops! Looks like the table you're trying to reference hasn't been defined yet

Is there a Wordpress floating bar similar to the one seen on 9gag?

Identifying the length of a division element following its addition

Persistent change issue with JQuery CSS function

Transition smoothly with a fade-in effect as you scroll through the images, and proceed to

How can I transform Json data into XML format with namespaces included?

What is the method for retrieving this data using Javascript?

Creating a custom loading page in Next.js 13: A step-by-step guide

What is the best way to convert an object into an array of objects for use in a select search functionality

Create a div element that expands to occupy the remaining space of the screen's height

What is the source of this error message "Exceeding maximum characters in string literal"?

The error type currently displayed relates to window['angularComponentReference']

Ways to ascertain whether a user has successfully logged in

Incorporate a redirect function following an alert using jQuery, AJAX,

Utilizing Smart Table for Data Binding with JSON Dataset

In Python, bring in a CSV file that is tab-delimited and remove any newline characters and commas from the

How can I switch the values of two select components in React js when clicked?