[Qgis-user] Problems occur when copying large amounts to Excel

[Janneke van Dijk]

Hi Yann,

I had this the other day. With me it was caused by a new line character 
in one of the fields in the database, causing the line to be split over 
two lines. As my data were in Postgres I was able to clean up my data by 
using:

update mytable set myfield = regexp_replace(myfield, 
E'[\\n\\r\\u2028]+', ' ', 'g' );

Janneke

On 30/11/2015 13:39, Yann Raes wrote:
>
> Hello
>
> When I copy my attributes (+6000 attributes) to Excel I get several 
> lines that are not copied correct.  The lines split in half and makes 
> a new line; so one line turns into two split lines…
>
> Anyone a solution for this bug?
>
> Thanx.
>
> Yann
>
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20151130/fda7df9c/attachment.html>