How to split with regex in javascript?

Question

If I have the string

PercentageValue = 99.9,\r\nCaseID = 9745683 PercentageValue = 90.3,\r\nCaseID = 9387593 PercentageValue = 88.6,\r\nCaseID = 4893448

How can I parse it into:

[
    {PercentageValue : '99.9', CaseID : '9745683'},
    {PercentageValue : '90.3', CaseID : '9387593'},
    {PercentageValue : '88.6', CaseID : '4893448'}
]

There seems to be a space delimiter, but the issue is there are other spaces too.

Thanks

The JSON format you want to achieve is not correct. Maybe you would like : instead of = ? — quirimmo
– quirimmo, Commented May 28, 2017 at 19:34

quirimmo · Accepted Answer · 2017-05-28 19:46:33Z

1

var str = 'PercentageValue = 99.9,\r\nCaseID = 9745683 PercentageValue = 90.3,\r\nCaseID = 9387593 PercentageValue = 88.6,\r\nCaseID = 4893448';
var array = str.replace(/\r\n/g, '').replace(/\s=\s/g, ':').split(' ');
var objs = array.map((el) => {
  return {
  	[el.split(',')[0].split(':')[0]]: el.split(',')[0].split(':')[1],
  	[el.split(',')[1].split(':')[0]]: el.split(',')[1].split(':')[1] 	
  }
});
console.log(objs);

answered May 28, 2017 at 19:46

quirimmo

10k3 gold badges33 silver badges46 bronze badges

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

Comments

alessandrio · Accepted Answer · 2017-05-28 21:05:07Z

1

var str = "PercentageValue = 99.9,\r\nCaseID = 9745683 PercentageValue = 90.3,\r\nCaseID = 9387593 PercentageValue = 88.6,\r\nCaseID = 4893448";
var parse = "["+str.replace(/(\w+)\s=\s(\d+(\.\d)?),\r\n(\w+)\s=\s(\d+)/g, "{\"$1\":\"$2\",\"$4\":$5}").replace(/\}\s\{/g, "},{")+"]";
console.log(JSON.parse(parse));

answered May 28, 2017 at 21:05

alessandrio

4,3802 gold badges31 silver badges42 bronze badges

Comments

amiramw · Accepted Answer · 2017-05-28 20:10:00Z

0

var input = "PercentageValue = 99.9,\r\nCaseID = 9745683 PercentageValue = 90.3,\r\nCaseID = 9387593 PercentageValue = 88.6,\r\nCaseID = 4893448";
var res, resArray = [], re = /PercentageValue = (.*),\r\nCaseID = (\d*) ?/g; 
while (res = re.exec(input)) 
   resArray.push({PercentageValue: res[1], CaseID: res[2]})

answered May 28, 2017 at 20:10

amiramw

5162 silver badges10 bronze badges

Comments

Tomas Langkaas · Accepted Answer · 2017-05-29 08:25:09Z

0

As shown by other answers, there are several ways to solve this. Here is an approach with .reduce():

var str = 'PercentageValue = 99.9,\r\nCaseID = 9745683 ' +     
          'PercentageValue = 90.3,\r\nCaseID = 9387593 ' +
          'PercentageValue = 88.6,\r\nCaseID = 4893448';

console.log(
  str
    .split(/ = |,?\s+/)
    .reduce(
      function(c, v, i, a){
        return i & 3 == 3 && (c[i >> 2] = {
          PercentageValue: a[i - 2], 
          CaseID: v
        }), c
      }, []
    )
)

edited May 29, 2017 at 8:25

answered May 28, 2017 at 22:39

Tomas Langkaas

4,7492 gold badges23 silver badges38 bronze badges

Collectives™ on Stack Overflow

How to split with regex in javascript?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related