Parsing text using regex javascript

Question

guys i am stuck while parsing following text into object. I have created two separate regex but i want to make only one. Below i am posting sample text as well as my following regex pattern.

PAYER:\r\n\r\n   MCNA \r\n\r\nPROVIDER:\r\n\r\n   MY KHAN \r\n   Provider ID: 115446397114\r\n   Tax ID: 27222193992\r\n\r\nINSURED:\r\n\r\n   VICTORY OKOYO\r\n   Member ID: 60451158048\r\n   Birth Date: 05/04/2008\r\n   Gender: Male\r\n\r\nCOVERAGE TYPE:\r\n\r\n   Dental Care

REGEX:

 re = new RegExp('(.*?):\r\n\r\n(.*?)(?:\r\n|$)', 'g');
re2 = new RegExp('(.*?):(.*?)(?:\r\n|$)', 'g');

Expected result:

{
  payer: 'MCNA',
  provider: 'MY KHAN'
}

What is the result you're trying to achieve? Could it be possible to simplify the input used in your question? — Kevin Pastor
– Kevin Pastor, Commented Dec 21, 2022 at 19:08
i want object like this => { payer: 'MCNA', provider: 'MY KHAN'}; — Muhammad Faisal
– Muhammad Faisal, Commented Dec 21, 2022 at 19:09
@MuhammadFaisal That belongs in the question, not in a comment. — I0_ol
– I0_ol, Commented Dec 21, 2022 at 19:10
I'm not sure regex is the right tool here. At least not entirely. Maybe you could split on new lines and iterate through the result of that to create your object? — I0_ol
– I0_ol, Commented Dec 21, 2022 at 19:12

Peter Thoeny · Accepted Answer · 2022-12-21 20:27:46Z

3

This turns your input into an object that contains all key/value pairs:

const input = 'PAYER:\r\n\r\n   MCNA \r\n\r\nPROVIDER:\r\n\r\n   MY KHAN \r\n   Provider ID: 115446397114\r\n   Tax ID: 27222193992\r\n\r\nINSURED:\r\n\r\n   VICTORY OKO\r\n   Member ID: 60451158048\r\n   Birth Date: 05/04/2009\r\n   Gender: Male\r\n\r\nCOVERAGE TYPE:\r\n\r\n   Dental Care';

let result = Object.fromEntries(input
  .replace(/([^:]+):\s+([^\n\r]+)\s*/g, (m, c1, c2) => c1.toLowerCase() + '\r' + c2 + '\n')
  .split('\n')
  .filter(Boolean)
  .map(item => item.trim().split('\r'))
);
console.log(result);

Output:

{
  "payer": "MCNA",
  "provider": "MY KHAN",
  "provider id": "115446397114",
  "tax id": "27222193992",
  "insured": "VICTORY OKO",
  "member id": "60451158048",
  "birth date": "05/04/2009",
  "gender": "Male",
  "coverage type": "Dental Care"
}

Explanation:

Object.fromEntries() -- convert a 2D array to object, ex: [ ['a', 1], ['b', 2] ] => {a: 1, b: 2}
.replace() regex /([^:]+):\s+([^\n\r]+)\s*/g -- two capture groups, one for key, one for value
replace action c1.toLowerCase() + '\r' + c2 + '\n' -- convert key to lowercase, separate key/value pairs with newline
.split('\n') -- split by newline
.filter(Boolean): -- remove empty items
.map(item => item.trim().split('\r')) -- change array item to [key, value], e.g. change flat array to 2D array

You could add one more filter after the .map() to keep only keys of interest.

answered Dec 21, 2022 at 20:27

Peter Thoeny

7,6381 gold badge16 silver badges24 bronze badges

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

3 Comments

Muhammad Faisal Over a year ago

Hello peter thanks for helping out but i need one more thing. Following i am posting little bit of change structure

Peter Thoeny Over a year ago

@MuhammadFaisal: I believe I answered your original question, let me know if not. The example input in your new question is more complex, it's unlikely that it can be done in one regex. The first one with address that spans multiple lines possibly can, but COVERAGE DATES: Plan Date: 05/01/2022 - 02/28/2223 has two consecutive keys, thus is non-deterministic and needs clarification.

Muhammad Faisal Over a year ago

you answered my original question without a doubt.

Collectives™ on Stack Overflow

Parsing text using regex javascript

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related