"Import data from a text file and store it as an array of objects using Types

Question

"Import data from a text file and store it as an array of objects using Types

I need assistance with converting the information in my text file into an array of objects. Below is a snippet of the data from the text file:

DOCNO   NETAMOUNT   IREF1   IREF2   DOCDT
001 30000   50  100 6/7/2020
2   40000   40  90  6/7/2020

Currently, this is my code implementation:

  reader.onload = (ev)=>{
        const data = reader.result;
        var txtData = data.toString();
        console.log(data,"txt data");
        var lines = txtData.split(' ');
        for(var line = 0; line < lines.length; line++){
            console.log(lines[line]);
        }
    
     };
    
     reader.readAsText(file);
}

The desired output format I am aiming for is as follows:

0: {DOCNO: "001", NETAMOUNT: "30000", IREF1: "50", IREF2: "100", DOCDT: "6/7/20"}

1: {DOCNO: "2", NETAMOUNT: "40000", IREF1: "40", IREF2: "90", DOCDT: "6/7/20"}

javascript arrays angular typescript

Answer 1

Answer №1

If you want to extract data from a structured text file, one approach is to use regular expressions (regex) to split the content by new lines and then further divide each line into individual words based on spaces. Finally, you can organize this information under appropriate headings using the reduce() function in JavaScript.

const sampleText = `
  ID   NAME   AGE   CITY
  1    John   25    New York
  2    Sara   30    Chicago
`;

// Split the text by newline characters
const lines = sampleText.trim().split(/\n/g);

// Separate each line into words based on spaces
const wordsPerLine = lines.map(line => line.trim().split(/\s+/g));

// The first line contains the headings
const headings = wordsPerLine.shift();

// Combine the data with the corresponding headings
const result = wordsPerLine.reduce((all, line) => {
  const obj = {};
  
  line.forEach((word, index) => {
    obj[headings[index]] = word;
  });
  
  all.push(obj);
  
  return all;
}, []);

console.log(result);

Answer 2

If you want to extract data from a structured text file, one approach is to use regular expressions (regex) to split the content by new lines and then further divide each line into individual words based on spaces. Finally, you can organize this information under appropriate headings using the reduce() function in JavaScript.

const sampleText = `
  ID   NAME   AGE   CITY
  1    John   25    New York
  2    Sara   30    Chicago
`;

// Split the text by newline characters
const lines = sampleText.trim().split(/\n/g);

// Separate each line into words based on spaces
const wordsPerLine = lines.map(line => line.trim().split(/\s+/g));

// The first line contains the headings
const headings = wordsPerLine.shift();

// Combine the data with the corresponding headings
const result = wordsPerLine.reduce((all, line) => {
  const obj = {};
  
  line.forEach((word, index) => {
    obj[headings[index]] = word;
  });
  
  all.push(obj);
  
  return all;
}, []);

console.log(result);

"Import data from a text file and store it as an array of objects using Types

Answer №1

Similar questions

The callback functions, such as afterMove, are not being executed

Looking to disable the back button in the browser using next.js?

I am creating accordion-style bootstrap tables using data generated from an ng-repeat loop, all without the use of ui.bootstrap or jquery

Having trouble retrieving parameters within the expressjs router.delete endpoint implementation

What are the methods for choosing various boxes using the UP/DOWN/RIGHT/LEFT arrow keys?

Discovering necessary information by iterating through JSON

Material-UI: The call stack has exceeded the maximum range, causing an Uncaught RangeError

Leveraging various techniques within a single controller in AngularJS

A guide on efficiently traversing a disk directory, recursively fetching all paths in relative format, and converting them into a JSON stream with node.js

Assistance needed for jQuery functions running too early

lint-staged executes various commands based on the specific folder

The onchange() function for a multi-checkbox dropdown is failing to work as

Utilizing HTML5/JavaScript to send a text message from a mobile device

When a text is wrapped by an HTML div using absolute positioning, is there a way to prevent it from wrapping without relying on white space

Tips for extracting the values of multiple input fields in JavaScript and displaying them on a webpage

Steps to retrieve a date from a form control

Unable to set the height for ul/div elements

``Is it possible to iterate through a collection of objects using a loop?

I'm looking to enhance security in my sign-up form by adding a custom shield using Angular for my Firebase database. How can

Keep things in line with async functions in Node JS