OneLine replacement

[Luis Pecht]

Hi Gurus,

I was wondering if it is possible to insert { } to equalize the format, NOT using auxiliaries variables ( file is huge), but using just one line command (regex ?? ).

Of course it must adjust only eligible cases with no { }.

clear
input str67 var1
`"{  "Department": "Corporate Systems",  "Project": "Project Alpha"} "'
`""Department": "HR",  "Project": "Project Beta""'                     
end

     +---------------------------------------------------------------------+
     |                                                                var1 |
     |---------------------------------------------------------------------|
  1. | {  "Department": "Corporate Systems",  "Project": "Project Alpha"}  |
  2. |                      "Department": "HR",  "Project": "Project Beta" |
     +---------------------------------------------------------------------+

Desired Output:

     +---------------------------------------------------------------------+
     |                                                                var1 |
     |---------------------------------------------------------------------|
  1. | {  "Department": "Corporate Systems",  "Project": "Project Alpha"}  |
  2. |                   { "Department": "HR",  "Project": "Project Beta"} |
     +---------------------------------------------------------------------+

thks

[Clyde Schechter]

I'm not sure I understand what you are doing here, but is it:

replace var1 = "{  " + var1 + "}" if substr(var1, 1, 1) != "{"

[Luis Pecht]

thks, that is it!