AWK or SED for correct columns

Shell Programming and Scripting
1

Hello, I have the following file, but one of his columns is not in place, and tried with SED and AWK, how I can correct format?

In the second line break is wrong, and puts it after the first column of next line

I would appreciate if you could guide me on the subject.

2

Let's try this one

awk 'BEGIN{FS=OFS=","}{if(int($NF)!=$NF){sub(int($NF),int($NF)RS);ORS=" "}else{ORS=RS}}1' file
3

Hi
u can try this..

[root@sistem1lnx ~]# cat dos
LECOLAMSTERDAKS COL.MOD.AMSTERDAM K.S LESTE 2,950 8,900 6,325 4,900
LECOLBERLINQS COL MOD.BERLIN Q.S LESTE 1,674 5,350 3,800 2,950LECOLBRUSELASMAT
COL.MOD.BRUSELAS MAT LESTE 1,816 5,500 3,900 2,975
LECOLBRUSELASQS COL.MOD.BRUSELAS Q.S LESTE 2,070 6,275 4,475 3,450

pattern=$( (sed '/[0-9][0-9] *$/d' dos | sed 's/\(.*\)\([0-9][,][0-9][0-9]*\)\(.*$\)/\3/') )

 
patternnew=$pattern

[root@sistem1lnx ~]# sed -e "s/$pattern/\n&/" dos | sed -e "/[^\$pattern]$/{;N}" -e "s/$patternnew\n/$patternnew /"
LECOLAMSTERDAKS COL.MOD.AMSTERDAM K.S LESTE 2,950 8,900 6,325 4,900
LECOLBERLINQS COL MOD.BERLIN Q.S LESTE 1,674 5,350 3,800 2,950
LECOLBRUSELASMAT COL.MOD.BRUSELAS MAT LESTE 1,816 5,500 3,900 2,975
LECOLBRUSELASQS COL.MOD.BRUSELAS Q.S LESTE 2,070 6,275 4,475 3,450

Regards
Ygemici

4

Thanks, both ideas are good, I need to study them to understand especially the second, the state generally good, but in a register near the end it does not, but I'll solve it.

They are very nice and I will learn a lot here.

5 
$ cat nitwh
LECOLAMSTERDAKS COL.MOD.AMSTERDAM K.S LESTE 2,950 8,900 6,325 4,900
LECOLBERLINQS COL MOD.BERLIN Q.S LESTE 1,674 5,350 3,800 2,950LECOLBRUSELASMAT
COL.MOD.BRUSELAS MAT LESTE 1,816 5,500 3,900 2,975
LECOLBRUSELASQS COL.MOD.BRUSELAS Q.S LESTE 2,070 6,275 4,475 3,450
VIBECOLPALERMOMA COL.MOD.PALERMO MAT VITOR 1,414 4,250 3,025 2,295
WIRLA7MLSR6332JT LAVADORA MOD.7HLSR-6332 WIRPO 3,600 10,900 7,750 5,675WIRLA7MWT-98825
LAVADORA MOD.7MWT-98825 WIRPO 4,865 14,350 10,100 7,350

$ sed '/ [0-9][,0-9]*$/!{h;s/\(.* [,0-9]*\)\(.*\)/\1/p;g;s//\2/;N;y/\n/ /;}' nitwh    
LECOLAMSTERDAKS COL.MOD.AMSTERDAM K.S LESTE 2,950 8,900 6,325 4,900
LECOLBERLINQS COL MOD.BERLIN Q.S LESTE 1,674 5,350 3,800 2,950
LECOLBRUSELASMAT COL.MOD.BRUSELAS MAT LESTE 1,816 5,500 3,900 2,975
LECOLBRUSELASQS COL.MOD.BRUSELAS Q.S LESTE 2,070 6,275 4,475 3,450
VIBECOLPALERMOMA COL.MOD.PALERMO MAT VITOR 1,414 4,250 3,025 2,295
WIRLA7MLSR6332JT LAVADORA MOD.7HLSR-6332 WIRPO 3,600 10,900 7,750 5,675
WIRLA7MWT-98825 LAVADORA MOD.7MWT-98825 WIRPO 4,865 14,350 10,100 7,350