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

Tee
can someone please explain to me how Enum.reduce works with maps
New
lessless
I believe there are people here who are dealing with CSV files import on the daily basis, and since Excel is a really popular tool there ...
New
ycv005
I have followed this StackOverflow post to install the specific version of Erlang. And When I am running mix ecto.setup then getting fol...
New
freewebwithme
Using vs code and installed ElixirLS: support and debugger. And I got an error popped up on start up says Failed to run ‘elixir’ comma...
New
aadeshere1
I have a another noob question about loop. Since elixir is immutable, while loop is not directly possible. total = 10 while total != 0 ...
New
mathew4509
I have a list say x = ["23gh", "56kh", "97mh"] I would like to pass each element to Val in each iteration. Say, in iteration 1 -------...
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
Patoshizzle
After calling mix ecto.create I get this error: 17:00:32.162 [error] GenServer #PID<0.412.0> terminating ** (Postgrex.Error) FATAL...
New
jay1
Why is it that the mnesia database isn’t the most preferred database for use in Elixir/Phoenix?
New
idi527
I’ve been re-reading swift book again and noticed that multiline strings there don’t have a trailing line break, unlike in elixir iex(2)...
New

Other popular topics Top

yurko
Here are few pieces of (common) Linux knowledge that we use for reasonably small one server apps. We use Ubuntu but this should work for ...
New
Tee
can someone please explain to me how Enum.reduce works with maps
New
chrismccord
This release brings a number of exciting features, including integration with the new Phoenix LiveDashboard and Phoenix LiveView. There h...
New
script
If I have a string “1000 cfu/ml” . I want to remove the characters and / and space . So the string is like this "1000" What is the ...
New
vac
Hi, I'm quite new in Elixir and I'm trying to format a string to a PEM format. I have the certificate value like MIIDBTCCAe2...... and ...
New
freewebwithme
Using vs code and installed ElixirLS: support and debugger. And I got an error popped up on start up says Failed to run ‘elixir’ comma...
New
chensan
I have a User schema with a :from_id field set to type :string: defmodule TweetBot.Repo.Migrations.CreateUsers do use Ecto.Migration ...
New
msaraiva
Surface is an experimental library built on top of Phoenix LiveView and its new LiveComponent API that aims to provide a more declarative...
564 42633 214
New
ovidiubadita
Hey all, I discovered Elixir and I love it. I always wanted to learn a functional programming and I intended to go for Haskell, but afte...
New
baxterw3b
Hi guys, i’m new in the Elixir world, and i have to say, that i love it! i’m having some problem to understand anonymous functions with ...
New

We're in Beta

About us Mission Statement