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

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
openscript
Hello! Sorry for this astonishing simple question, but I’m really stuck. I try to set up the intellij-elixir plugin, but I don’t know ho...
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
greenz1
I have a phoenix application from which a user can download multiple(5-6) files of size 1MB. I couldn’t find anything related to sending ...
New
9mm
I am constructing a JSON object (map) and I need to conditionally set a field. I’m trying to write proper elixir-way code… and I’m at a l...
New
gshaw
What is the idiomatic way of matching for not nil in Elixir? E.g., First way: defp halt_if_not_signed_in(conn, signed_in_account) when...
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

Other popular topics Top

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
nsuchy
Hi. I’ve noticed that Windows Powershell has it’s own IEX command and you cannot access Elixir’s IEX due to the conflict. This isn’t a cr...
New
sergio_101
I am VERY much an elixir newbie. I have taken one elixir course and one phoenix course on Udemy. During that course, I saw the instructor...
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
dblack
I’ve got an issue with an app and I’ve no idea of how to troubleshoot it. I’m hoping someone here might have seen something similar. I p...
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

We're in Beta

About us Mission Statement