Shell Programming and Scripting

That example demonstrates why awk is more suitable for anything more than simple selection and replacement.

Hello,

Thank you for the code. Now i need more of it (sorry I am really new with awk)

I need 2 different scripts which can rearrange the data like this:

xy=CreateDB|head.queue|head.source|head.definition|rtf.edit
abc|source|divine|line4
def|source||line2

head.queue=abc
head.source=source
head.definition=divine
rtf.edit=line4

head.queue=def
head.source=source
head.definition=
rtf.edit=line2

quirkasaurus has helped me with this, but how can I add a blank line between different set of data value?

I also need a reverse of this, from:

head.queue=abc
head.source=source
head.definition=divine
rtf.edit=line4

head.queue=def
head.source=source
head.definition=
rtf.edit=line2

to:

xy=CreateDB|head.queue|head.source|head.definition|rtf.edit
abc|source|divine|line4
def|source||line2

Thank you for your help!

To add extra blank line just add the below bold red line to the same old nawk:-

Code:

nawk -F\| '{
  if ( NR == 1 ){
    for ( x = 2; x <= NF; x++ ){
      headers[x-1]=$x;
      }
    next;
    }

  for ( x = 1; x <= NF; x++ ){
    print headers[x] "=" $x;
    }
print ""
  }'

to reverse the action use the below nawk:-

Code:

nawk -F"\=" '
/head.queue/{c=5 ; b="xy=CreateDB""|"$1 ; s=$2 ; next}
c--{b=b"|"$1 ; s=s"|"$2}
!c--{print b,"\n",s ; b="" ;s=""}
' file.txt | nawk '!a[$0]++'

Hello Ahmad,

Thanks for the help, but the secondScript not really working properly.

When converted the Input file to:

head.queue=abc
head.source=source
head.definition=divine
rtf.edit=line4
rtf.task=5
rft.cut=true
rft.abc=
htc.lom=

head.queue=def
head.source=source
head.definition=divine
rtf.edit=line3
rtf.task=
rft.cut=true
rft.abc=
htc.lom=

After executing your script, it gives me back :
xy=CreateDB|head.queue|head.source|head.definition|rtf.edit|rtf.task
abc|source|divine|line4
def|source|divine|line3

Not all the data were reversed and there is a space in the front of the data set.

Can you help out?

Thank you in advance

Others have given the solution. My question is,

why put the file name xy=CreateDB in first line, can it be seperated into a single line? With that, the code can be easier and more Efficient.

Hello rdcwayx

I do need the same format as I posted. The xy=CreateDB has to be in the same line with the |head.queue|head.source|head.definition|....

Can anyone help out?

the first thread you put there were only 4 rows but now you are having 8 rows
kindly modify my code as below:-

Code:

nawk -F"\=" '
/head.queue/{c=8 ; b="xy=CreateDB""|"$1 ; s=$2 ; next}
--c{b=b"|"$1 ; s=s"|"$2}
!c{print b,"\n",s ; b="" ;s=""}
' file.txt | nawk '!a[$0]++'

where c= number of raws in each paragraph