How to Split String {} with Multiple Values

Question

Let's say that I have a type STRING column 'debugdata'. An example value for a given user looks like this:

{"TITLE_DESCRIPTION":"approve","CATEGORY":"approve"}

However, let's say there can be multiple values for the TITLE_DESCRIPTION

{"TITLE_DESCRIPTION":"No, name does not match,No, summary is not clear","CATEGORY":"Yes"}

How can I split out the "No, name does not match" and "No, summary is not clear" into two columns?

I've tried using JSON_EXTRACT and JSON_ARRAY_GET and other JSON syntax, but I can't quite break this up into two columns. Thanks!

Possible duplicate of [Can you split/explode a field in a MySQL query?](https://stackoverflow.com/questions/471914/can-you-split-explode-a-field-in-a-mysql-query) — Sakura Kinomoto, Jun 01 '17 at 23:04
This does not make much sense. Why would you split it only on the 2nd comma? Think what would happen with other `"TITLE_DESCRIPTION"` values that contain multiple commas. — David דודו Markovitz, Jun 02 '17 at 05:34

itay · Answer 1 · 2017-06-01T23:11:34.337

0

lets say x is your map from your example

let x = {"TITLE_DESCRIPTION":"No, name does not match,No, summary is not clear","CATEGORY":"Yes"}

so all you need to do is this:

let b = (x.TITLE_DESCRIPTION).split(',')

edit: in you example you split the sentences with ',' but have ',' in the string himself so use char escape for ',' or use other char for split the sentences and send it to the split function instead of ','.

edited Jun 01 '17 at 23:11

answered Jun 01 '17 at 23:04

itay

357
4
16

This is not an SQL answer nor what the OP requested (which is unclear by itself) – David דודו Markovitz Jun 02 '17 at 05:36

score 0 · Answer 2 · answered Jun 03 '17 at 04:08

0

What about first use json_extract and then use the String function split?

answered Jun 03 '17 at 04:08

FreePeter

752
6
6

This is not an answer – David דודו Markovitz Jun 03 '17 at 09:24

How to Split String {} with Multiple Values

2 Answers2