Using regular expressions in Sublime Text 2 to replace text in JSON files can greatly improve your workflow

After using an online web tool to convert an Excel file to JSON, I now require assistance in replacing certain values within the JSON. Currently, I am using Sublime Text 2.

{"Time (GMT-04:00)":"2010-07-06 08:30:00","Skin temp - average":"34,2043","Step Counter":172,"Sleep":"0,0","Physical Activity":1,"Energy expenditure":"11,4371","Annotations":"Running"}

It is evident that some numbers were mistakenly converted to strings due to the presence of a comma:

"Skin temp - average":"34,2043"

My goal is to remove the quotes surrounding all numbers and replace the commas with periods. Is it feasible to achieve this using regular expressions in ST2?

For example:

"Skin temp - average":34.2043

I appreciate any assistance provided. Thank you.

javascriptregexjsonsublimetext2

Answer №1

Try searching for the following:

"(\d+),(\d+)"

Then, replace it with:

$1.$2

To Find & Replace in the current document, you can utilize the Ctrl (Cmd) + Alt + f keyboard shortcut.

Similar questions

If you have not found the answer to your question or you are interested in this topic, then look at other similar questions below or use the search

Local host's attempt to retrieve data from an external site via an Axios GET request was rejected

I'm currently attempting to execute a GET request on an external website in order to scrape some information. Unfortunately, my axios GET request is returning a connection error. I suspect that this issue may be related to the fact that I am sending t ...

javascripthttpexpressaxios

Using JQuery, ensure that the scroll function runs in advance of the ajax call finishing

I am currently working on using jQuery to scroll down to a text box when the click event occurs. However, I have noticed that the scroll event is happening after the AJAX call within the function. $("#execute_btn").click(function(){ $('html, b ...

javascriptjqueryajax

Tips for updating HTML Ajax content when the back button is clicked

I created a search page with filters that update the URL parameters to prevent values from being lost if the page is refreshed. q = $('#form input[name=q]').val(), srchtype= $('#filter input[name=srchtype]:checked').val(), sortBy ...

javascriptjqueryajax

Unable to construct React/Next project - identified page lacking a React Component as default export (context api file)

When attempting to compile my Next.js project, I encountered an error message in the terminal: Error: Build optimization failed: found page without a React Component as default export in pages/components/context/Context The file in question is utilizing ...

javascriptreactjsnext.js

Encountering an undefined array within a click function nested inside a for loop

Being a newbie in this field, I seem to have overlooked a simple detail. The for loop is functioning correctly, but within it, I encounter an issue with an undefined variable. var categories_info = ["history","excellence","art","social","facilities","p ...

javascriptjquery

Using the function to show content by calling its assigned ID

<script type="text/javascript"> function selectRow(id){ $.get("http://inactive/test.php?id=" + id, function(data,status){ return data; }); } </script> <script type="text/javascript"> $("tr").click(function() { window.l ...

javascriptjqueryhtmlajax

Creating a regular expression for date and time formatting in order to perform replacements

When working on a python script, I have the task of formatting a specific string. The original input is as follows: em|2017-08-24|PE|TETE|USD||AR|2017-08-25 06:54:40|-98.58 I am required to transform it into the following format: em|2017/08/24|PE|TETE|US ...

pythonregex

When implementing v-model on a v-dialog component, it causes the element within an array to

There is an array of apps with links, and a Dialog component that has v-model="dialog" to close it. However, after adding v-model to the v-dialog, the functionality of the apps is affected. The current app is passed as a prop to Dialog, but it always sends ...

javascriptvue.jsvuetify.js

Checking File Upload Progress in HTML and PHP

As a newcomer, I've been struggling to find a solution to an issue I'm facing. My concern is regarding a form that is meant to upload a file and send it via email. How can I display the progress status of the file being uploaded? It seems that us ...

javascriptphphtmlformsfile-upload

Assess JavaScript for Fetch API implementation

Currently, I am utilizing node.js on Windows with the express module to create an HTML page where I need to retrieve data from a server-side function called getfiledata() (I want to keep my Javascript and text file private). I have attempted to use fetch( ...

javascripthtmlnode.jspromisefetch

Proper approach for mapping JSON data to a table using the Fetch API in a React.js application

Struggling to map some elements of JSON to a Table in Customers.jsx, but can't seem to figure out the correct way. How do I properly insert my Fetch Method into Customers.jsx? Specifically managing the renderBody part and the bodyData={/The JsonData/} ...

javascriptreactjsjsonuitableviewfetch-api

Checkbox malfunctioning when trying to add values after being checked

I have successfully completed a calculation system project using JavaScript. Everything works well, the calculations are accurate and taxes are included properly. However, I am facing an issue where the tax is not being included when I click on the checkbo ...

javascripthtmljqueryinnerhtml

"Exciting developments in Angular 17 with the introduction of the new @

I need to output elements from an array of strings starting at index 1. arr = [ "str1", "str2", "str3", "str4", "str5" ] The desired output is: str2 str3 str4 str5 To achieve this, use a new @for loop in ...

javascripthtmlangulartypescriptangular17

What is the best way to include multiple hostnames and pathnames in a Next.js configuration file for image assets?

My attempt to import multiple images from different hostnames for next/image is not working as expected. In my next.config.js, I have tried the following setup: module.exports = { images: { remotePatterns: [ { protocol: 'https&apos ...

javascriptreactjsnext.js

Issue with Ref when used in a distinct HTML template

I have encountered a frustrating issue with my simple Vue project. When I separate the template and code into individual files, the ref stops working and I end up with an undefined value in the HTML template. This scenario works fine: map.component.vue ...

javascripthtmlvue.jsvuejs3

Steps for updating a value in a JSON file using PHP

Trying to modify a value within a JSON file for a specific object is throwing me off balance. The issue arises from having multiple siblings in the same JSON file sharing identical key-value pairs. The JSON structure I'm dealing with appears as follo ...

javascriptphpjsonajax

Having difficulty entering text into a "Search Input Field" that is a react component in testcafe

Struggling to input text in a "Type to search dropdown" that is a react component. While able to click on the component, typing any text seems to be an issue. Listed below is an example of the code: import { Selector } from 'testcafe'; test(&ap ...

javascriptreactjsautomated-testse2e-testingtestcafe

Bringing JSON data into a MySQL database

Dealing with a large and intricate .JSON file with over 200k lines that I need to store in MySQL for querying purposes. The .JSON file is split into two main sections, "edges" and "nodes", an example of which is provided below: { "edges": [ { ...

phpmysqlsqljsonmysql-workbench

How can you refresh the information shown in a separate component from the search input with a live search bar?

Currently, I am working on integrating a live search functionality into my Next.js application. While I have successfully managed to capture input changes, I am facing difficulties in filtering the results based on the user input. Here is a snippet of the ...

javascriptreactjsnext.js

Tips for utilizing import alongside require in Javascript/Typescript

In my file named index.ts, I have the following code snippet: const start = () => {...} Now, in another file called app.ts, the code is as follows: const dotenv = require('dotenv'); dotenv.config(); const express = require('express' ...

javascriptnode.jstypescriptexpress