[Qgis-user] Problems occur when copying large amounts to Excel
Janneke van Dijk
janneke.qgis at gmail.com
Mon Nov 30 03:44:53 PST 2015
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>
More information about the Qgis-user
mailing list