Well I thought that this would be a fairly straight forward operation but perhaps I'm complicating it more in my mind. I have a simple data.txt file containing candidate information in the following format:
"ANTONIA ROJAS SALES" "Feminino"
"13/06/1954" "Casado(a)"
"Brasileira (naturalizada)" "CRUZEIRO DO SUL / AC"
"Superior completo" "Deputado"
"Partido do Movimento Democr�tico Brasileiro -
"ANTONIO NIZOMAR DOS SANTOS" "Masculino"
.....
Wanting to transpose each candidate into a *single* row looking like:
"ANTONIA ROJAS SALES" "Feminino" "13/06/1954" "Casado(a)" Brasileira (naturalizada)" "CRUZEIRO DO SUL / AC" "Superior completo" "Deputado" "Partido do Movimento Democr�tico Brasileiro
Current code looks like this:
awk '{printf "%-15s ", $1}!(NR % 5){printf "\n"}' done.txt
however this only returns the first field, when I want the entire string:
"ANTONIA "13/06/1954" "Brasileira "Superior "Partido
Any ideas? Thanks!