Notepad++ macro to transform JSON array

Question

Not too savvy with macros in notepad++, but essentially I want to take this input:

"BAILIFF": [
    "The prisoners will all stand.",
    "All present, stand and make respectful attention to honouredJudge.",
    "Before this gracious court now appear these prisoners toanswer for the multiple and grievous savageries of their species. Howplead you, criminal?",
    "Criminals keep silence!",
    "You will answer the charges, criminals.",
    "Criminal, you will read the charges to the court.",
    "All present, respectfully stand. Q",
    "This honourable court is adjourned. Stand respectfully. Q"
],
"MCCOY": [
    "Hold it right there, boy.",
    "What about my age?",
    "Troubles me? What's so damned troubling about not having died? How old do you think I am?",
    "Explain how you remember that so exactly.",
    "I don't see any points on your ears, boy, but you sound like aVulcan.",
    "Almost as bad.",
    "They are, they are. And damned annoying at times.",
    "Well, this is a new ship, but she's got the right name. Now youremember that, you hear.",
    "You treat her like a lady, and she'll always bring you home."
],

and transition it to:

"The prisoners will all stand." "BAILIFF"

"All present, stand and make respectful attention to honouredJudge." "BAILIFF"

"Before this gracious court now appear these prisoners toanswer for the multiple and grievous savageries of their species. Howplead you, criminal?" "BAILIFF"

"Criminals keep silence!" "BAILIFF"

"You will answer the charges, criminals." "BAILIFF"

"Criminal, you will read the charges to the court." "BAILIFF"

"All present, respectfully stand. Q" "BAILIFF"

"This honourable court is adjourned. Stand respectfully. Q" "BAILIFF"

"Hold it right there, boy." "MCCOY"

"What about my age?" "MCCOY"

"Troubles me? What's so damned troubling about not having died? How old do you think I am?" "MCCOY"

"Explain how you remember that so exactly." "MCCOY"

"I don't see any points on your ears, boy, but you sound like aVulcan." "MCCOY"

"Almost as bad." "MCCOY"

"They are, they are. And damned annoying at times "MCCOY"

"Well, this is a new ship, but she's got the right name. Now youremember that, you hear." "MCCOY"

"You treat her like a lady, and she'll always bring you home." "MCCOY"

Any help is appreciated. Thanks.

Julio · Accepted Answer · 2019-05-22 18:21:03Z

3

Try with this macro:

Record macro
Control + H (search and replace)
Search what: ^("[^"]+")\s*:\s*\[\s*("[^\n]*?")\s*,(?=\R)|^("[^\n]*?") ("[^"]+")\R\K\h+("[^\n]*?)(?:,(?=\R)|\s*\],?)
Replace by: (?2\2 \1)(?3\5 \4)
Replace all
Next >
Replace all
Stop recording macro.
Now play the macro with the option: Run macro multiple times and Run until the end of file

answered May 22, 2019 at 18:21

Julio

5,3161 gold badge16 silver badges46 bronze badges

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

Collectives™ on Stack Overflow

Notepad++ macro to transform JSON array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related