Transforming text to numbers in JSON with JavaScript

Question

Transforming text to numbers in JSON with JavaScript

Below is the JSON data that I have:

{
  "Title": "Test",
  "StartDate": {
    "Month": "3",
    "Year": "1973"
  },
  "EndDate": {
    "Month": "4",
    "Year": "1974"
  }
}

I am looking to extract the Month and Year values from both StartDate and EndDate fields without quotes, as shown below:

{
  "Title": "Test",
  "StartDate": {
    "Month": 3,
    "Year": 1973
  },
  "EndDate": {
    "Month": 4,
    "Year": 1974
  }
}

EDIT I want to clarify that I am not generating this JSON using JSON.stringify(). The JSON is being created by a Form Builder module in Angular 2. Despite specifying the type as number, the values are still encapsulated in quotes.

javascript json

Answer 1

Answer №1

To ensure your JSON is properly formatted, make sure to utilize the parseInt() function for converting values into integers before saving. This will eliminate any unnecessary quotes.

JSON.stringify({
    Year: parseInt( data , 10);
})

For more information, refer to this resource.

Answer 2

To ensure your JSON is properly formatted, make sure to utilize the parseInt() function for converting values into integers before saving. This will eliminate any unnecessary quotes.

JSON.stringify({
    Year: parseInt( data , 10);
})

For more information, refer to this resource.

Answer 3

Answer №2

UPDATE

If you initially created the JSON Object in your JavaScript code, follow @Adrian Lambertz's solution. However, if you received the JSON as a String from another source and need to convert it, refer to my method :

Here's my original approach

In case you have a JSON string within your JavaScript code, here is how you can transform specific values into integers :

var data = JSON.parse(JSONStringToTransform);

// Assuming the JSON String consists of events each with Title, StartDate, and EndDate properties
for (var j = 0; j < data.length; j++) {
    // If the JSON String does not contain an array of events, adjust the logic accordingly
    data[j].StartDate.Month = parseInt(data[j].StartDate.Month);
    data[j].StartDate.Year = parseInt(data[j].StartDate.Year);
    data[j].EndDate.Month = parseInt(data[j].EndDate.Month);
    data[j].EndDate.Year = parseInt(data[j].EndDate.Year);
}

// Generate a JSON String without quotation marks around Month and Year values
var convertedJSONString = JSON.stringify(data);

Answer 4

UPDATE

If you initially created the JSON Object in your JavaScript code, follow @Adrian Lambertz's solution. However, if you received the JSON as a String from another source and need to convert it, refer to my method :

Here's my original approach

In case you have a JSON string within your JavaScript code, here is how you can transform specific values into integers :

var data = JSON.parse(JSONStringToTransform);

// Assuming the JSON String consists of events each with Title, StartDate, and EndDate properties
for (var j = 0; j < data.length; j++) {
    // If the JSON String does not contain an array of events, adjust the logic accordingly
    data[j].StartDate.Month = parseInt(data[j].StartDate.Month);
    data[j].StartDate.Year = parseInt(data[j].StartDate.Year);
    data[j].EndDate.Month = parseInt(data[j].EndDate.Month);
    data[j].EndDate.Year = parseInt(data[j].EndDate.Year);
}

// Generate a JSON String without quotation marks around Month and Year values
var convertedJSONString = JSON.stringify(data);

Answer 5

Answer №3

Simply transform the text into numerical values. Feel free to customize this code snippet based on your specific object setup.

function convertToNumbers(data) {
  for (const key of ['StartMonth', 'EndYear']) {
    for (const value of ['Day', 'Hour']) {
      data[key][value] = Number(data[key][value]);
    }
  }
}

Answer 6

Simply transform the text into numerical values. Feel free to customize this code snippet based on your specific object setup.

function convertToNumbers(data) {
  for (const key of ['StartMonth', 'EndYear']) {
    for (const value of ['Day', 'Hour']) {
      data[key][value] = Number(data[key][value]);
    }
  }
}

Answer 7

Answer №4

The order in which the data is expected may not be clear, so I will provide two versions below.

Object -> JSON (-> Object)

To convert an object to JSON and back to an object, you can use JSON.stringify along with a replacer function that converts certain keys like Month and Year into numbers.

var dataObj = { "Title": "Test", "StartDate": { "Month": "3", "Year": "1973" }, "EndDate": { "Month": "4", "Year": "1974" } },
    jsonStr = JSON.stringify(dataObj, function (k, v) {
        return ['Month', 'Year'].indexOf(k) !== -1 ? +v : v;
    }),
    parsed = JSON.parse(jsonStr);

console.log(jsonStr);
console.log(parsed);

JSON -> Object

If you want to convert JSON back to an object, you can use JSON.parse along with a reviver function that converts certain keys like Month and Year into numbers.

var jsonStr = '{ "Title": "Test", "StartDate": { "Month": "3", "Year": "1973" }, "EndDate": { "Month": "4", "Year": "1974" } }',
    parsed = JSON.parse(jsonStr, function (k, v) {
        return ['Month', 'Year'].indexOf(k) !== -1 ? +v : v;
    });

console.log(parsed);

Answer 8

The order in which the data is expected may not be clear, so I will provide two versions below.

Object -> JSON (-> Object)

To convert an object to JSON and back to an object, you can use JSON.stringify along with a replacer function that converts certain keys like Month and Year into numbers.

var dataObj = { "Title": "Test", "StartDate": { "Month": "3", "Year": "1973" }, "EndDate": { "Month": "4", "Year": "1974" } },
    jsonStr = JSON.stringify(dataObj, function (k, v) {
        return ['Month', 'Year'].indexOf(k) !== -1 ? +v : v;
    }),
    parsed = JSON.parse(jsonStr);

console.log(jsonStr);
console.log(parsed);

JSON -> Object

If you want to convert JSON back to an object, you can use JSON.parse along with a reviver function that converts certain keys like Month and Year into numbers.

var jsonStr = '{ "Title": "Test", "StartDate": { "Month": "3", "Year": "1973" }, "EndDate": { "Month": "4", "Year": "1974" } }',
    parsed = JSON.parse(jsonStr, function (k, v) {
        return ['Month', 'Year'].indexOf(k) !== -1 ? +v : v;
    });

console.log(parsed);

Transforming text to numbers in JSON with JavaScript

Answer №1

Answer №2

UPDATE

Here's my original approach

Answer №3

Answer №4

Object -> JSON (-> Object)

JSON -> Object

Similar questions

Is there a way to modify the output Json during serialization on a broader scale, even if the class definitions are not modifiable?

Executing a JavaScript/jQuery function on the following page

Watchify fails to detect any modifications in the directories above

Experiencing an error with Angular's $resource module: encountering an issue with unknown providers while trying to

How can I integrate both the ui-bootstrap datepicker and timepicker in an AngularJS application?

data.map` does not work as a function

Can Bootstrap buttons be manipulated to mimic checkbox behavior effectively?

Issue with React select dropdown not properly updating selected value

A method that sorts an array of objects based on their properties

The execution of 'observe' on 'MutationObserver' failed because parameter 1 is not the correct type of 'Node'. Ensure to use select2() instead

Extracting various data points from a JSON document

What is the method for configuring a dynamic default download folder in ChromeDriver using a JSON file?

When React-select is toggled, it displays the keyboard

Retrieve data from a server using an Ajax GET request to access information stored within an HTML

Elusive Essence: Mysterious Origins of the

Tips for utilizing the if statement within ng-repeat in Angular version 1.0.8

What is the process for duplicating a set of elements within an svg file and displaying the duplicate at a specific location?

Quirks in TailwindCSS template literals behavior

Discovering the power of Next.js Dynamic Import for handling multiple exportsI hope this

There seems to be an issue with the cookie functionality as it is not