CSV Export 2 extra spaces

Comments

• OlegK

  April 2010 edited 4:09AM

  Try to align your memos, and make them same size.
• Jimmy Van den Bliek

  April 2010 edited 4:09AM

  See the export example below:
  
  "206 ";;"23.11.1999 ";;"product ";"DC ";"Free License ";"number ";;"customer name ";
  
  It is actually on each field and not between the fields that I have 2 extra spaces. These 2 spaces are not part of the field value. Any idea?
• OlegK

  April 2010 edited 4:09AM

  Can you attach sample report (fr3-file), which reproduce this problem?
• Anu de Deus Hampshire, UK

  April 2010 edited April 2010

  I wrote the reply below without reading your problem properly, the answer described is for the extra fields ( ; ) separators, not the the extra spaces.
  Because I believe you also have the extra field problem, I'll leave the answer for that here:
  
  Jimmy, I had a similar problem, but solved it.
  It happens because the items are not aligned in the page, like Oleg said.
  Try to align every single memoview component vertically, both left and width properties identical with its header, or whatever other memoview object you have in the same vertical area in your page.
  Try to visualise your page as columns, and for each column (i.e. each element displayed), you might have a new field in the export.
  I suggest to start aligning your MasterData band objects with whatever header it has right above it (PageHeader, ColumnHeader, Header).
  Also, make sure they don't overlap horizontally, preferably set autosize to false and adjust the width manually for all components.
• Jimmy Van den Bliek

  April 2010 edited 4:09AM

  Here is the report
  
  dongles.fr3
• Anu de Deus Hampshire, UK

  April 2010 edited 4:09AM

  I can't load your Fr3 file, it's giving me 'invalid file format' error.
  Anyway, try my DoTrim function like explained here:
  
  http://www.fast-report.com/en/forum/?p=/discussion/6677