story-json | Story JSON document format | JSON Processing library
kandi X-RAY | story-json Summary
kandi X-RAY | story-json Summary
Story JSON document format
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of story-json
story-json Key Features
story-json Examples and Code Snippets
Community Discussions
Trending Discussions on story-json
QUESTION
I have a series of gigantic (40-80mb) exported Google Location History JSON
files, with which I've been tasked to analyze select activity data. Unfortunately Google has no parameter or option at their download site to choose anything except "one giant JSON containing forever". (The KML
option is twice as big.)
Obvious choices like JSON-Converter
(laexcel-test incarnation of VBA-JSON
); parsing line-by line with VBA; even Notepad++. They all crash and burn. I'm thinking RegEx might be the answer.
This Python script can extract the timestamp and location from a 40mb file in two seconds (with RegEx?). How is Python doing it so fast? (Would it be as fast in VBA?)
I'd be able to extract everything I need, piece by piece, if only I had a magic chunk of
RegEx
, perhaps with this logic:Delete everything except:
WhentimestampMs
andWALKING
appear between the *same set of[
square brackets]
:- I need the 13-digit number that follows
timestampMS
, and, - the one- to three- digit number that follows
WALKING
.
- I need the 13-digit number that follows
If it's simpler to include a little more data, like "all the timestamps", or "all activities", I could easily sift through it later. The goal is to make the file small enough that I can manipulate it without the need to rent a supercomputer, lol.
I tried adapting existing RegEx's but I have a serious issue with both RegEx and musical instruments: doesn't how hard I try, I just can't wrap my head around it. So, this is indeed a "please write code for me" question, but it's just one expression, and I'll pay it forward by writing code for others today! Thanks... ☺ .
...ANSWER
Answered 2018-Apr-05 at 13:12You may try this
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install story-json
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page