Hi ..
I executed the same script as you given above.but then I am getting the report like,
```text
Account_Id Date Id Balance
44 9 1000.00n 30
15-10-2173 10 1000.00 42
15-10-2173 10 1200.00 53
01-01-2008 10 1200.00
```
Then I tried to execute this with one small change in your script,
```text
sed "s/\.00/.00 \n/" |awk '{ (Just given a single space in between .00 and \n )
```
Then I am getting the result as follows,
Account_Id Date Id Balance
44 9 1000.00 n
30 15-10-2173 10 1000.00
42 15-10-2173 10 1200.00
53 01-01-2008 10 1200.00
To keep the forums high quality for all users, please take the time to format your posts correctly.
First of all, use Code Tags when you post any code or data samples so others can easily read your code. You can easily do this by highlighting your code and then clicking on the # in the editing menu. (You can also type code tags
```text
and
```
by hand.)
Second, avoid adding color or different fonts and font size to your posts. Selective use of color to highlight a single word or phrase can be useful at times, but using color, in general, makes the forums harder to read, especially bright colors like red.
Third, be careful when you cut-and-paste, edit any odd characters and make sure all links are working property.
The idea is to split fields in group of 4. If the second field of that group is not a date, offset the field order by one.
NR>1{
for(i=1;i<=NF;i++){
dummy=""
# if every second field is a not a date
if(i+n==(2+(j*4)) && $i !~ /^[0-9][0-9]-/){
dummy=" " # set space for missing date
n+=1 # offset fields order by one
}
sep=" "
if(!((i+n)%4)){ # line break every 4 field
sep="\n"
j++
}
printf dummy $i sep
}
}