I need to convert a specially formatted string to an javascript array

Question

I'm trying to convert a formatted string to a JavaScript multidimensional array.

I've tried split() and push() functions but neither seem to work. The format should be already right but I can't seem to figure out how to make the string into an array.

Here's the string:

[[24297, 'CWCS Sump 002', -121.50842, 38.54798, '2', 'SEWER SUMP'],[8035, 'CWCS Sump 002A (56)', -121.50842, 38.54798, '2A', 'SEWER SUMP'],[9334, 'CWCS Sump 001', -121.5110297, 38.5703431, '1', 'SEWER SUMP']]

I just want a JavaScript array that is 3x6 (if I counted that right) from that string. The number of rows will vary.

ggorlen · Accepted Answer · 2019-05-16 18:21:31Z

1

This is a good candidate for JSON.parse; however, single quotes should be converted to double quotes before it will work. Being careful for escaped quotes, you can try:

const raw = `[[24297, 'CWCS Sump 002', -121.50842, 38.54798, '2', 'SEWER SUMP'],[8035, 'CWCS Sump 002A (56)', -121.50842, 38.54798, '2A', 'SEWER SUMP'],[9334, 'CWCS Sump 001', -121.5110297, 38.5703431, '1', 'SEWER SUMP']]`;

const res = JSON.parse(raw.replace(/(?<!\\)'/g, `"`));
console.log(res);

edited May 16, 2019 at 18:21

answered May 16, 2019 at 18:16

ggorlen

59.3k8 gold badges119 silver badges173 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Randy Over a year ago

I can actually write the string however I want - I had chosen that because I was following a google maps example that had that format.. I am formatting the sting from a database result in traditional asp and returning it through an ajax call

Randy Over a year ago

here is the smae string formatted with double quotes on all values: [["24297", "CWCS Sump 002", "-121.50842", "38.54798", "2", "SEWER SUMP"],["8035", "CWCS Sump 002A (56)", "-121.50842", "38.54798", "2A", "SEWER SUMP"]]

Randy Over a year ago

I think this is working now once I double quoted the values. Thanks for the help!

dWinder · Accepted Answer · 2019-05-16 19:15:07Z

1

You can do it with JSON.parse as:

let str = '[[24297, "CWCS Sump 002", -121.50842, 38.54798, "2", "SEWER SUMP"],[8035, "CWCS Sump 002A (56)", -121.50842, 38.54798, "2A", "SEWER SUMP"]]';

let arr = JSON.parse(str);

Notice it better to have the ' around the entire string the " around the string inside. Can do that with:

str.replace("'", """);

edited May 16, 2019 at 19:15

answered May 16, 2019 at 17:54

dWinder

11.7k3 gold badges27 silver badges40 bronze badges

1 Comment

Randy Over a year ago

the string is being returned by an ajax call to a global variable.

Heinz Schilling · Accepted Answer · 2019-05-16 18:52:01Z

0

According to me It wont be straight forward. You can try like this.

let a = "[
    [24297,'CWCS Sump 002',-121.50842, 38.54798,'2','SEWER SUMP'],
    [8035,'CWCS Sump 002A (56)',-121.50842,38.54798,'2A','SEWER SUMP'],
    [9334,'CWCS Sump 001', -121.5110297,38.5703431,'1','SEWER SUMP']
]";
let c= [];

a.replace('[[','').replace(']]','').split('],[').forEach(
    (x)=>{c.push(x.split(','))}
);
//c is the result

edited May 16, 2019 at 18:52

Heinz Schilling

2,3474 gold badges23 silver badges36 bronze badges

answered May 16, 2019 at 18:13

Vivek Jain

441 silver badge6 bronze badges

Collectives™ on Stack Overflow

I need to convert a specially formatted string to an javascript array

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related