Re: Separar Colunas com quantidade incerta

[Cristiano]

--- Em address@hidden, Robson Alexandre <alexandrerobson@...> escreveu
>
> Só pra não ficar mostrengo, e utilizar do loop nas repetições
> numericas, e pra estressar totalmente o assunto, melhorado ficou assim
> em sed. (Graças a um exemplo do meu amigo Marcio Gil em duvidas
> anteriores)
> 
> sed -r 's/ /;/;s/([[:alpha:][:space:]]{1,})
> /\1;/;:a;s/([0-9]{1,2},[0-9]{2}) /\1;/;ta' /tmp/arq.txt
> 
> 170.00259604/3;JOSE LUIZ MOREIRA;10,00;1,00;11,00;24,00;46,00;ELIMINADO 4.1.9
> 170.00285361/7;JOSELIO RICARDO NUNES
> COELHO;6,00;0,00;4,00;9,00;19,00;ELIMINADO 4.1.9
> 170.00242788/9;JULIANO DA SILVA
> CHAVES;8,00;1,00;7,00;21,00;37,00;ELIMINADO 4.1.9
> 170.00254924/0;LEANDRO DO NASCIMENTO
> SAMORA;8,00;2,00;9,00;30,00;49,00;ELIMINADO 4.1.9
> 170.00263869/8;MARCELA GOUVEIA FERRAZ;10,00;5,00;6,00;9,00;30,00;ELIMINADO 
> 4.1.9
> 170.00237205/9;MARCELO ALVES DRUMMOND DE
> OLIVEIRA;12,00;4,00;5,00;42,00;63,00;HABILITADO ITEM 4.3.3
> 170.00239439/7;MARCOS ANTONIO LIMA;8,00;3,00;3,00;12,00;26,00;ELIMINADO 4.1.9
> 170.00240727/2;MARINA DE OLIVEIRA
> PEREIRA;10,00;1,00;1,00;9,00;21,00;ELIMINADO 4.1.9
> 170.00283022/0;MEI YUNG KO;10,00;3,00;6,00;9,00;28,00;ELIMINADO 4.1.9
> 170.00261006/2;PHILIP TEIXEIRA ROCHA;8,00;1,00;6,00;15,00;30,00;ELIMINADO 
> 4.1.9
> 170.00265535/0;RODRIGO JOSE BUENO;12,00;1,00;7,00;3,00;23,00;ELIMINADO 4.1.9
> 170.00280447/0;SIRLANE DE ARAUJO CAMURCA
> FERNANDES;10,00;3,00;6,00;24,00;43,00;ELIMINADO 4.1.9
> 170.00237871/9;VALDECI ANTONIO DE
> SOUZA;2,00;2,00;4,00;18,00;26,00;ELIMINADO 4.1.9
> 170.00252405/5;WAGNER ALVES RIBEIRO
> MAIA;16,00;5,00;6,00;33,00;60,00;HABILITADO ITEM 4.3.3
> 170.00266490/0;ABELARDO DE JESUS;6,00;2,00;3,00;18,00;29,00;ELIMINADO 4.1.9
> 170.00252228/6;ABNER AUGUSTO VIANA
> THOMAZ;6,00;3,00;3,00;24,00;36,00;ELIMINADO 4.1.9
> 170.00271565/4;ABNER VISCONTI VIEIRA;8,00;3,00;10,00;30,00;51,00;ELIMINADO 
> 4.3.4
> 
> 
> Att Robson Alexandre
>

Vixe, eu ia propor um one liner com sed, usando conceito de retrovisor, mas 
agora fique até com vergonha.

Este sed do Robson ficou realmente um show. Parabéns.

Se alguém quiser ver um 'monstrengo' do tipo do ele se referia, aí vai:

sed 's/\(^[^ ]*\) \([a-Z ]*\) \([^ ]*\) \([^ ]*\) \([^ ]*\) \([^ ]*\) \([^ ]*\) 
\([^ ]*\) \(.*$\)/\1;\2;\3;\4;\5;\6;\7\;\8;\9/g' /tmp/lixo.txt