Please I have a text file separated by spaces. I would like to output it to columns separated by ; example Input I use this code My output Output desired. Appreciate your help. Answer $1=$1 is a trick to rebuild $0 with the new separator OFS=';'.

Separate Text file to columns by ;

Please I have a text file separated by spaces. I would like to output it to columns separated by ;

example Input

31561 49215 10   1196825801480000
31561 49219 12   1196825801480000
31561 48665 14   1196825806980000

JavaScript
​x
 
31561 49215 10   119682580148000031561 49219 12   119682580148000031561 48665 14   1196825806980000​

I use this code

tr " " ";" < file

JavaScript
 
tr " " ";" < file​

My output

31561;49215;10;;;1196825801480000
31561;49219;12;;;1196825801480000
31561;48665;14;;;1196825806980000

JavaScript
 
31561;49215;10;;;119682580148000031561;49219;12;;;119682580148000031561;48665;14;;;1196825806980000​

Output desired.

31561;49215;10;1196825801480000
31561;49219;12;1196825801480000
31561;48665;14;1196825806980000

JavaScript
 
31561;49215;10;119682580148000031561;49219;12;119682580148000031561;48665;14;1196825806980000​

Appreciate your help.

awk -v OFS=';' '{$1=$1}1' file

JavaScript
 
awk -v OFS=';' '{$1=$1}1' file​

$1=$1 is a trick to rebuild $0 with the new separator OFS=';'.