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

How to eliminate spaces while preserving line breaks in a textarea using JS or jQuery

Allowing for the acceptance of null values for strings using rapidjson within cereal by assigning them an empty string ""

Revamp your AngularJS controller for a fresh new look

What is the reason behind the def.reject code in setTimeout not executing when the sendToSocket operation is successful?

Can Next.js 13 support the usage of axios?

Calculate the total of an array with the help of the angular forEach function

Having trouble saving user input from a form to a database using axios, mongodb, and vue?

What is the best way to decode a field in Go that has the potential to be either an array or a string?

Creating a Related Entry in strapi v4: A Step-by-Step Guide

Submitting Files to the API using Vue.js

Ways to address Path Traversal vulnerability in the following code

Validating Angular UI without requiring an input field (validating an expression)

Leveraging both onmouseover and onmouseout for container expansion

Combining all elements of my application into a single HTML, JS, and CSS file

varied reactions between componentDidMount and useEffect when employing jquery emoji plugin

Verify the ability to view a webpage

Is it possible for (variable or {}) to function seamlessly across all web browsers when using Javascript

The datetimepicker is not functioning properly

Encountering a Typescript error while attempting to utilize mongoose functions

The error message "Data type must be consistent across all series on a single axis in Google Chart" may cause confusion