Utilize JavaScript to extract and transform plain text into a JSON object through the filtering process

Question

Utilize JavaScript to extract and transform plain text into a JSON object through the filtering process

After receiving the plain text data from an input source, I have the following information:

1 agri dev ban lt shortform1 346 346 343 343 9,671 346 3,330,659 78 -3.00 -0.87 3.00 0.87 361.80 400.07 449.86 472.00 283.00

2 Api Pwr Cpy shortform2 355 355 347 348 2,702 355 942,793 36 -7.00 -1.97 8.00 2.31 366.09 465.42 479.63 683.00 246.00

I now require an array that will hold JSON objects structured as follows:

[
 {
  traded: shortform1,
  close: 343,
  previousClose: 355
 },
 {
  traded: shortform2,
  close: 348,
  previousClose: 355
 }
]

javascript arrays json

Answer 1

Answer №1

Each line will be processed by this function to return an object. I trust you can handle the rest!

function parseLine(line)
{
  var splitLine = line.split(' '), offset=parseInt(splitLine[0]);
  return {traded:splitLine[6-offset],close:splitLine[10-offset],previousClose:splitLine[12-offset]}
}

Update: I realized that shortform may not always be in the same position. The code has been adjusted accordingly, although the information provided is limited.

Answer 2

Each line will be processed by this function to return an object. I trust you can handle the rest!

function parseLine(line)
{
  var splitLine = line.split(' '), offset=parseInt(splitLine[0]);
  return {traded:splitLine[6-offset],close:splitLine[10-offset],previousClose:splitLine[12-offset]}
}

Update: I realized that shortform may not always be in the same position. The code has been adjusted accordingly, although the information provided is limited.

Utilize JavaScript to extract and transform plain text into a JSON object through the filtering process

Answer №1

Similar questions

Remove a JSON object that corresponds to a particular value

When using translate.get with an array of strings in Angular 5, the function will return both the keys and values, not just

JavaScript is failing to update the table values as users interact with it

Setting the outcome of an Ajax call as a global variable in JavaScript

manipulating child element's innerHTML with javascript

Show a nested JSON object when the specific key is not recognized

What is the best method for extracting a specific value from this JSON data?

The attention remains fixed at the top of the page

Struggling to find a solution for your operating system issue?

Transforming Json data into an Object using Angular 6

Utilizing Isotope JS on your Wordpress website

Utilize Autocomplete component from Material UI to sift through distinct option values

Navigating JSON data using SwiftyJSON

Tools for parsing command strings in NodeJS

Leveraging PapaParse for CSV file parsing in a React application with JavaScript

Can a JavaScript function be sent through a REST API using Node.js and Express?

Achieving success with the "silent-scroll" technique

Select a different radio button to overwrite the currently checked one

Obtaining a result from a switch statement

AngularJS ng-repeat - cascading dropdown not refreshing