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]> 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* > > > >
