pankaj-ag

pankaj-ag

How to escape a backslash in a string while decoding it in a JSON object

Hello

Let me define the problem first.

I have a jsonb database column called results in my Postgres DB. When I save a value (i.e 12\25) it saves like that in the DB.

{"attri": {"input": "12\\25"}}

Now I have a JSON string

"{ "custom_key": "@attri.input"}"

When I replace the above map values in this string I got the following results.

"{\"custom_key\": \"12\\25\"}"

All this is good and working as expected but when I try to decode this string into JSON

Like this Jason.decode("{\"custom_key\": \"12\\25\"}") it gives me an error.

I also try to escape the value before replacing it in string and in that case, it gives me the following results.

"{ \"custom_key\": \"\"12\\\\25\"\"}"

And I am not able to parse this string into JSON as well.

Please let me know in case I am missing something here or you need any other clarification on the problem.

Most Liked

al2o3cr

al2o3cr

Forum tip: telling the reader “it gives me an error” is vastly less helpful than showing the reader the output of trying that:

iex(1)> Jason.decode("{\"custom_key\": \"12\\25\"}")
{:error,
 %Jason.DecodeError{
   data: "{\"custom_key\": \"12\\25\"}",
   position: 19,
   token: nil
 }}

Printing the string involved makes it clearer what’s going on:

iex(2)> s = "{\"custom_key\": \"12\\25\"}"          
"{\"custom_key\": \"12\\25\"}"
iex(3)> IO.puts s
{"custom_key": "12\25"}
:ok

So the JSON parser complains about the lone \ in the input.

In your second example, this happens:

iex(4)> s = "{ \"custom_key\": \"\"12\\\\25\"\"}"
"{ \"custom_key\": \"\"12\\\\25\"\"}"
iex(5)> Jason.decode(s)
{:error,
 %Jason.DecodeError{
   data: "{ \"custom_key\": \"\"12\\\\25\"\"}",
   position: 18,
   token: nil
 }}
iex(6)> IO.puts s
{ "custom_key": ""12\\25""}
:ok

Now the extra "s around 12\\25 throw the whole thing off.

My advice: don’t try to replace values in JSON by string-replacing the whole thing - parse the JSON, do the replacements there, then re-encode.

Where Next?

Popular in Questions Top

albydarned
Hello all! I am typing this post from my new MacBook Pro with the M1 chip. I’m loving it so far, and will probably use it as my daily dr...
New
JeremM34
Hello, how can I check the Phoenix version ? Thanks !
New
tduccuong
Hi, is there any work on GUI with Elixir, that is similar to Electron/Javascript? My idea is to bundle Phoenix and BEAM into a single se...
New
Fl4m3Ph03n1x
About me? ( if you have nothing better to do than reading about some random guy in the internet :stuck_out_tongue: ) Hello all, this is ...
New
earth10
Hi, I’m just starting to build a side-project with Elixir and Phoenix and doing some basic test with Elixir alone. What strikes me is th...
New
Emily
I have VueJS GUIs with the project generated using Webpack. I have Elixir modules that will need to be used by the VueJS GUIs. I forese...
New
belgoros
I’m not a pro in using Regex and can’t figure out why the following behaviour happens, especially if we take into account the difference ...
New
rms.mrcs
Hi, I need to transform a list of numbers into a map where the keys are the indexes and the values are the original values of the list. ...
New
dotdotdotPaul
Okay, I’m having a heck of a time trying to figure out how to best handle the validation of belongs_to associations in Ecto. I’m sure I’...
New
WestKeys
Currently suffering from paralysis by [HTTP client] analysis. This is rather unusual in Elixirland as there tends to be consensus on the ...
New

Other popular topics Top

Harrisonl
We have an ECS cluster with 4 services, where each task joins a single cluster, via discovery ECS discovery service. Currently when I de...
New
AstonJ
Posting this to see if we can make things easier for people to get into Neovim. If you use Neovim and have a favourite distro please let ...
New
TunkShif
This post is an instruction guide to help you setup your Neovim for Elixir development from scratch. It includes general information on h...
274 41539 114
New
albydarned
Hello all! I am typing this post from my new MacBook Pro with the M1 chip. I’m loving it so far, and will probably use it as my daily dr...
New
shahryarjb
Hello, I have map which I want to convert it to string like this: the map: %{last_name: "tavakkoli", name: "shahryar"} the string I ne...
New
stefanchrobot
What’s the safe way to decode a JSON string into a struct? I want to avoid calling String.to_atom. Jason.decode can give me a map with st...
New
dokuzbir
I want to highlight html closing tags when i click a html tag. That works in .html files but doesnt work for html.eex templates. How can...
New
Emily
I have VueJS GUIs with the project generated using Webpack. I have Elixir modules that will need to be used by the VueJS GUIs. I forese...
New
ashish173
I am using Ecto timestamps with postgres, I can see the timestamps() use the :naive_dateime but for my use case I wanted to store the ti...
New
boundedvariable
I am going through the kafka architecture. All the features what the kafka is providing are already in Erlang. I would like hear your opi...
New

We're in Beta

About us Mission Statement