Extract the String data from a JSON file

Question

Extract the String data from a JSON file

valeurs_d = "";
                for (var i = 0; i < keys.length -1 ; i++)
                    valeurs_d += + event[keys[i]] + ", ";
                var str5 = ",";
                var str6 = str5.concat(valeurs_d);
                var valeurs = str6.substring (0, str6.length - 2);
                console.log(valeurs);

I am working with a JSON document structured like this:

 {
              "temperature" : 12.45,
              "lala" : 45.75,
              "humidite" : 45.78,
              "toto" : "gvvgvh",
              "topic" : "sk1_001/data"
             }

However, the issue arises when attempting to retrieve the values as I get: 12.45, 45.75, 45.78, NaN!

Is there a way to retrieve my string instead of NaN?

On another note, does typeof in Javascript return number or string? I want to specify varchar for strings and double for numbers.

This is essential for updating my Apache Cassandra database using node.js.

How can I achieve returning varchar and double accurately?

javascript json

Answer 1

Answer №1

It seems like you are looking to extract all the values from your object. Here is a simple solution for that:

const obj = {
  "temperature": 12.45,
  "lala": 45.75,
  "humidite": 45.78,
  "toto": "gvvgvh",
  "topic": "sk1_001/data"
};

const values = Object.keys(obj).map(key => obj[key]);

console.log(values);

This code will store all the values in an array, but if you prefer a string format, you can use values.join(",").

Answer 2

It seems like you are looking to extract all the values from your object. Here is a simple solution for that:

const obj = {
  "temperature": 12.45,
  "lala": 45.75,
  "humidite": 45.78,
  "toto": "gvvgvh",
  "topic": "sk1_001/data"
};

const values = Object.keys(obj).map(key => obj[key]);

console.log(values);

This code will store all the values in an array, but if you prefer a string format, you can use values.join(",").

Answer 3

Answer №2

To concatenate all values within a string using commas as separators, implement the code snippet below

var myObject = {
 "temperature" : 24.32,
 "sample" : 34.56,
 "humidity" : 67.89,
 "test" : "abcde",
 "title" : "sk2_002/info"
 };


var newArray = []; 
for(var key in myObject){
  newArray.push(myObject[key].toString());
}
var finalResult = newArray.join(",");
console.log(finalResult);

Answer 4

To concatenate all values within a string using commas as separators, implement the code snippet below

var myObject = {
 "temperature" : 24.32,
 "sample" : 34.56,
 "humidity" : 67.89,
 "test" : "abcde",
 "title" : "sk2_002/info"
 };


var newArray = []; 
for(var key in myObject){
  newArray.push(myObject[key].toString());
}
var finalResult = newArray.join(",");
console.log(finalResult);

Extract the String data from a JSON file

Answer №1

Answer №2

Similar questions

JavaScript is unable to execute anything that comes after the initial code, specifically document.get

What is the best way to combine a collection of strings and HTML elements in a React application?

Encoding a string in JSON that contains the "#" symbol along with other special characters

What steps are necessary to configure .eslintrc to identify the use of 'require'?

Having trouble updating the icon on my website using FontAwsome

Guide on extracting Nolhmann JSON objects and converting them into individual strings

Ensure that clicking on an element closes any currently visible elements before opening a new element

Can you explain the process of extracting images from JSON data using AJAX and jQuery?

Leveraging AngularJS $filter in conjunction with ng-disabled

What is the process for creating static pages that can access local data within a NextJS 13 application?

Deleting the previous ion-view from DOM in Ionic v1 with Angular

Can React components receive props or data when they are inserted into regular HTML code?

What causes the other array to be affected when one is changed?

What is the best way to combine a list of jsonNodes into a single jsonNode?

creating a distinct angular service for every controller

Creating interactive functionality for textareas and input fields in Vue: A beginner's guide

Unable to show the name of the chosen file

What is the best method for incorporating a JSON framework into a project

Ways to update the text alongside a slider form with JavaScript

Why won't my AngularJS checkbox stay checked?