Golang : How to convert strange string to JSON with json.MarshalIndent
Problem:
Your database is spewing out a funny looking string that looks like this {"width";800;"height";450}
and you want to map that string into something like this
[
{
width: 800,
height: 450,
}
]
You've tried converting the string to byte and decode with json.Unmarshal without luck. Is there a way to convert the string?
Solution:
First, clean up the funny/strange
string into something sensible with strings.Replace()
function and then format it to JSON with json.MarshalIndent()
function. json.MarshalIndent()
is to pretty-print the JSON output to multiple lines instead of lumping everything into a single line.
Here you go!
package main
import (
"encoding/json"
"fmt"
"os"
"strings"
)
func main() {
strFromDB := `{"width";800;"height";450}`
// deal with ;
// change ; to : after "
dealtWith := strings.Replace(strFromDB, "\";", "\":", -1)
fmt.Println("Converted to : ", dealtWith)
// trim and split
noCurlyBraces := strings.Replace(dealtWith, "{", "", -1)
noCurlyBraces = strings.Replace(noCurlyBraces, "}", "", -1)
// turn to slice
strSliceWithQuote := strings.Split(noCurlyBraces, ";")
fmt.Println("Slice : ", strSliceWithQuote)
jsonWithQuote, err := json.MarshalIndent(strSliceWithQuote, "", " ")
if err != nil {
fmt.Println(err)
os.Exit(-1)
}
fmt.Println("JSON : \n",string(jsonWithQuote))
}
Output :
Converted to : {"width":800;"height":450}
Slice : ["width":800 "height":450]
JSON :
[
"\"width\":800",
"\"height\":450"
]
See also : Golang : How to convert JSON string to map and slice
By Adam Ng
IF you gain some knowledge or the information here solved your programming problem. Please consider donating to the less fortunate or some charities that you like. Apart from donation, planting trees, volunteering or reducing your carbon footprint will be great too.
Advertisement
Tutorials
+8.2k Golang : Terminate-stay-resident or daemonize your program?
+17.9k Golang : Check if directory exist and create if does not exist
+7.3k Python : Fix SyntaxError: Non-ASCII character in file, but no encoding declared
+6k Golang : How to iterate a slice without using for loop?
+14.4k Golang : Loop each day of the current month example
+9.3k JavaScript/JQuery : Detect or intercept enter key pressed example
+8.4k Golang : Launch Mac OS X Preview (or other OS) application from your program example
+50.5k Golang : How to get time in milliseconds?
+5.6k Golang : How to setup a disk space used monitoring service with Telegram bot
+4.7k Fix yum-complete-transaction error
+5.6k Golang : Skip or discard items of non-interest when iterating example
+6.5k Golang : Detect sample rate, channels or latency with PortAudio