LinuxQuestions.org - [SOLVED] Collapsing 4 lines into 1

- Programming (https://www.linuxquestions.org/questions/programming-9/)

- - Collapsing 4 lines into 1 (https://www.linuxquestions.org/questions/programming-9/collapsing-4-lines-into-1-a-4175590119/)

Collapsing 4 lines into 1

I want to collapse 4 lines into 1 line, between { and }.

Using this sed regular expression, it's only collapsing the first line.

Any tips would be warmly welcomed.

Code:

$ egrep -v '({|})' file | sed 'N;s/\n/ /'

  "weather": "terrible",  "Food": "biscuits",

  "Hotel": "Fawlty Towers",  "country": "United Kingdom"

  "weather": "good",  "Food": "porridge",

  "Hotel": "La Palma",  "country": "Spain"

Target data should be formatted like this

Code:

  "weather": "terrible",  "Food": "biscuits",  "Hotel": "Fawlty Towers",  "country": "United Kingdom"

  "weather": "good",  "Food": "porridge",  "Hotel": "La Palma",  "country": "Spain"

Original data

Code:

{

  "weather": "terrible",

  "Food": "biscuits",

  "Hotel": "Fawlty Towers",

  "country": "United Kingdom"

}

{

  "weather": "good",

  "Food": "porridge",

  "Hotel": "La Palma",

  "country": "Spain"

}

Quote:

Originally Posted by dazdaz (Post 5609841)

I want to collapse 4 lines into 1 line, between { and }.

Consider using tr to ...
1) replace all instances of newline with blank
2) replace all instances of } with blank
3) replace all instances of { with newline

Code:

tr "\n}{" " \n" <$InFile >$OutFile

Daniel B. Martin

Code:

awk '/{/{next}/}/{$0=RS}ORS="\0"' file

Similar idea, skips lines with '{' and sets lines with '}' to a newline

Same idea

Code:

perl -pe 's/{?\n|}//' file