On 18/09/12 08:45, Edson Richter wrote:
> Em 17/09/2012 16:32, Ryan Kelly escreveu:
>> On Mon, Sep 17, 2012 at 04:20:14PM -0300, Edson Richter wrote:
>>> Dear all,
>>>
>>> I've started collecting log information in CSV format, but I need a
>>> way to customize it.
>>> Problem is that I'm collecting slow statements, and the statements
>>> have \n (newline) character, and the piece of
>>>
>>> 2012-09-17 14:25:33.150
>>> BRT,"thedb","thedb",15660,"10.10.20.1:33485",5054d3ab.3d2c,1,"SELECT",2012-09-15
>>> 16:14:51 BRT,10/204822,0,LOG,00000,"duração: 505.494 ms executar
>>> <unnamed>: select A, B
>>> from C join D
>>> on C.id = D.c_id
>>>
>>> And so on.
>>>
>>> It's not possible to change the application (hours of testing after
>>> changes will not be feasible for 2 million LOC).
>>>
>>> How can I tell PostgreSQL that it should remove the line breaks (and
>>> change them into whitespace character) from SQL statements? Or there
>>> is an "regexp" I can use for this purpose?
>> CSV parsers should handle this correctly. What tools are you trying to
>> use?
>>
>>> Thanks,
>>>
>>> Edson
>>>
>> -Ryan Kelly
>>
>>
> Actually, tried with Apache OpenOffice 3.4.1, and it works as
> expected. So, I just kicked Excel and now using OO.
>
> Regards,
>
> Edson.
>
>
Try LibreOffice, as it has replaced OpenOffice for most practical purposes!
LibreOffice is up to version 3.6.1 with 3.6.2 out Real Soon Now
(probably in a couple of weeks), it has many bug fixes, enhancements,
and performance improvements over OpenOffice 3.4.1.
http://www.libreoffice.org/
Cheers,
Gavin