Incorrect spaces with PLSQL

[mhagnumdw]

This:

String sql = "select h.*, c.name as country_name from Holiday h inner join Country c on h.country_id = c.id where h.year = :year and h.name != 'xpto' order by h.name";
String sqlFormatted = SqlFormatter.of(Dialect.PlSql).format(sql);

Produces:

select
  h. *,
--  ^ (there shouldn't be that space, which was after dot)
  c .name as country_name
-- ^ (there shouldn't be that space, which was before dot)
from
  Holiday h
  inner join Country c on h.country_id = c .id
--                                        ^ (there shouldn't be that space, which was before dot)
where
  h.year = :year
  and h.name != 'xpto'
order by
  h.name

Is there any solution to remove these spaces?

[potla43]

sqlFormatted = sqlFormatted.replaceAll("\.\s+", ".");
using this after . space removed