Regular expression to enclose non-quoted values (numbers and boolean) within quotes

Question

Regular expression to enclose non-quoted values (numbers and boolean) within quotes

I have a JSON file that is valid, but I need to add quotes around the number values and boolean values in order to send this JSON to a wix repeater that requires quotes around them.

If anyone can assist me with this, I would greatly appreciate it.

Example of received JSON:

[{"id":1238890,"category_id":1,"season_id":14866,"venue_id":null,"referee_id":null,"slug":"2022-08-12-melbourne-knights-fc-altona-magic-sc","name":"Melbourne Knights FC – Altona Magic SC","status":"inprogress","time_details":{"prefix":"","initial":0,"max":2700,"timestamp":1660296540,"extra":540}, "_id":1}]

Example of needed JSON:

[{"id":"1238890","category_id":"1","season_id":"14866","venue_id":"null","referee_id":"null","slug":"2022-08-12-melbourne-knights-fc-altona-magic-sc","name":"Melbourne Knights FC – Altona Magic SC","status":"inprogress","time_details":{"prefix":"","initial":"0","max":"2700","timestamp":"1660296540","extra":"540"}, "_id":"1"}]

I attempted the code below to transform the json data, but did not achieve the desired outcome

J'ai essayé ce code là en transformant mon json en chaine string mais sans le résultat escompté..

const regex = /[^"\d,]?(\d+)/g;
const str = [{"id":"1238890","category_id":"1","season_id":"14866","venue_id":"null","referee_id":"null","slug":"2022-08-12-melbourne-knights-fc-altona-magic-sc","name":"Melbourne Knights FC – Altona Magic SC","status":"inprogress","time_details":{"prefix":"","initial":"0","max":"2700","timestamp":"1660296540","extra":"540"}, "_id":"1"}]

const subst = `:` + `"$1"`;

// The substituted value will be contained in the result variable
const result = str.replace(regex, subst);

console.log('Substitution result: ', result);

Kind regards

javascript json regex

Answer 1

Answer №1

To begin, decode the json and then use a replacer function to reformat it (check out MDN for more information). The following code snippet also includes handling of null:

const jsonData = JSON.parse(`[{"id":2534834,"category_id":3,"group_id":11234,"venue_id":null,"ref_id":null,"slug":"2022-12-05-team-a-vs-team-b-game","name":"Team A vs Team B Game","status":"completed","details":{"prefix":"","start":0,"end":2700,"timestamp":1492837400,"additional":540}, "_id":2, "isAvailable":true}]`);
 
console.log(JSON.stringify(jsonData, 
  (key, value) => 
    /number|boolean/.test(typeof value) || value === null ? `${value}` : value, 2));

.as-console-wrapper {
    max-height: 100% !important;
}

Answer 2

To begin, decode the json and then use a replacer function to reformat it (check out MDN for more information). The following code snippet also includes handling of null:

const jsonData = JSON.parse(`[{"id":2534834,"category_id":3,"group_id":11234,"venue_id":null,"ref_id":null,"slug":"2022-12-05-team-a-vs-team-b-game","name":"Team A vs Team B Game","status":"completed","details":{"prefix":"","start":0,"end":2700,"timestamp":1492837400,"additional":540}, "_id":2, "isAvailable":true}]`);
 
console.log(JSON.stringify(jsonData, 
  (key, value) => 
    /number|boolean/.test(typeof value) || value === null ? `${value}` : value, 2));

.as-console-wrapper {
    max-height: 100% !important;
}

Answer 3

Answer №2

Personally, I prefer converting the object instead of resorting to regex

const json = `[{"id":1238890,"category_id":1,"season_id":14866,"venue_id":null,"referee_id":null,"slug":"2022-08-12-melbourne-knights-fc-altona-magic-sc","name":"Melbourne Knights FC – Altona Magic SC","status":"inprogress","time_details":{"prefix":"","initial":0,"max":2700,"timestamp":1660296540,"extra":540}, "_id":1}]`

const data = JSON.parse(json)

const converted = convertToStrings(data)

console.log(converted)

function convertToStrings(obj) {
  if (['boolean', 'number'].includes(typeof obj)) {
    return obj.toString()
  }
  if (obj === null) {
    return 'null'
  }
  if (typeof obj === 'string') {
    return obj
  }
  if (Array.isArray(obj)) {
    const newArray = []
    for (const item of obj) {
      newArray.push(convertToStrings(item))
    }
    return newArray
  }
  if (typeof obj === 'object') {
    const newObj = {}
    for(const key in obj){
      newObj[key] = convertToStrings(obj[key])
    }
    return newObj
  }
  throw new Error('Unsupported property type ' + typeof obj)
}

Answer 4

Personally, I prefer converting the object instead of resorting to regex

const json = `[{"id":1238890,"category_id":1,"season_id":14866,"venue_id":null,"referee_id":null,"slug":"2022-08-12-melbourne-knights-fc-altona-magic-sc","name":"Melbourne Knights FC – Altona Magic SC","status":"inprogress","time_details":{"prefix":"","initial":0,"max":2700,"timestamp":1660296540,"extra":540}, "_id":1}]`

const data = JSON.parse(json)

const converted = convertToStrings(data)

console.log(converted)

function convertToStrings(obj) {
  if (['boolean', 'number'].includes(typeof obj)) {
    return obj.toString()
  }
  if (obj === null) {
    return 'null'
  }
  if (typeof obj === 'string') {
    return obj
  }
  if (Array.isArray(obj)) {
    const newArray = []
    for (const item of obj) {
      newArray.push(convertToStrings(item))
    }
    return newArray
  }
  if (typeof obj === 'object') {
    const newObj = {}
    for(const key in obj){
      newObj[key] = convertToStrings(obj[key])
    }
    return newObj
  }
  throw new Error('Unsupported property type ' + typeof obj)
}

Answer 5

Answer №3

Like others have mentioned, one method is to convert the JSON string into an object, manipulate the object, and then convert it back to a JSON string.

Alternatively, you can use this concise regular expression to directly modify the JSON string:

const jsonData = '[{"id":1238890,"category_id":1,"season_id":14866,"venue_id":null,"referee_id":null,"slug":"2022-08-12-melbourne-knights-fc-altona-magic-sc","name":"Melbourne Knights FC – Altona Magic SC","status":"inprogress","time_details":{"prefix":"","initial":0,"max":2700,"timestamp":1660296540,"extra":540}, "_id":1, "someBoolean":false}]';
const regex = /(":\s*)(\d+|true|false|null)(,\s*"|\s*[\}\]])/g;
console.log(jsonData.replace(regex, '$1"$2"$3'));

Here's a breakdown of the regular expression used:

(":\s*) -- captures the pattern before the values that need to be escaped
(\d+|true|false|null) -- captures the values that need to be escaped
(,\s*"|\s*[\}\]]) -- captures the pattern after the values that need to be escaped
/g -- allows for multiple replacements in the string

Answer 6

Like others have mentioned, one method is to convert the JSON string into an object, manipulate the object, and then convert it back to a JSON string.

Alternatively, you can use this concise regular expression to directly modify the JSON string:

const jsonData = '[{"id":1238890,"category_id":1,"season_id":14866,"venue_id":null,"referee_id":null,"slug":"2022-08-12-melbourne-knights-fc-altona-magic-sc","name":"Melbourne Knights FC – Altona Magic SC","status":"inprogress","time_details":{"prefix":"","initial":0,"max":2700,"timestamp":1660296540,"extra":540}, "_id":1, "someBoolean":false}]';
const regex = /(":\s*)(\d+|true|false|null)(,\s*"|\s*[\}\]])/g;
console.log(jsonData.replace(regex, '$1"$2"$3'));

Here's a breakdown of the regular expression used:

(":\s*) -- captures the pattern before the values that need to be escaped
(\d+|true|false|null) -- captures the values that need to be escaped
(,\s*"|\s*[\}\]]) -- captures the pattern after the values that need to be escaped
/g -- allows for multiple replacements in the string

Regular expression to enclose non-quoted values (numbers and boolean) within quotes

Answer №1

Answer №2

Answer №3

Similar questions

The error handler in AngularJS is failing to run

Vitest React Redux - anticipating that the "spy" will be invoked with certain arguments

Adjust the class based on the model's value in AngularJS

Reading S3 files in Lambda functions using Python: A complete guide

The error message angular.js:12408 is indicating a syntax error with ng-pattern in the $parse function

Restoring styles back to the default CSS settings

autoNumeric JS field text is cleared upon losing focus

Next.JS reported that it "Executed a greater number of hooks compared to the previous render"

"Encountering an unidentified custom element in Vue 2 while exploring Vue libraries

What is the best way to access data from outside a forEach loop in JavaScript?

How can I resolve the error message "Uncaught TypeError: Cannot use 'in' operator to search for 'length' in" to successfully display my data?

Trouble with jQuery UI add/remove class duration feature

Using Javascript code to draw particles at the cursor's position and then directing those particles towards the bottom of

Navigating without the need for a mouse click

Navigating Angular QueryList through loops

The knockout.js subscribe function isn't activating during the initial set

Vue JS: Easily Calculate the Total Sum of All Columns

Error occurs while attempting to return a JSON record using an Ajax request

File reading and processing must be completed before attempting to write to a new file. This is a promise-related stipulation

Display or conceal fields depending on custom object specifications