Thanks Hans The 'minimal width' button fixed my issue.
Rob ------ Original Message ------ From "Hans Van Akelyen" <[email protected]<mailto:[email protected]>> To [email protected]<mailto:[email protected]> Date 6/03/2025 9:32:55 am Subject Re: Remove white space from CSV created using 'Text file output' step Hi Rob, Make sure your fields have no length specified. You can also use the “minimal width” button. It will basically clear the length field in the grid. Hope this helps, Hans On Wed, 5 Mar 2025 at 21:21, Rob Burgess <[email protected]<mailto:[email protected]>> wrote: Hi I'm trying to export data from a SQL Server View to a CSV file. I have been able to do this using the 'Table Input' and 'Text file output' steps. How do I remove the white space to the right of the last column in the CSV file? I have tried Using RTRIM() in my View SQL and tried the Trim Type option in the Fields tab of the 'Text file output' step. Thanks Rob
