File Mover Blog

January 15, 2022

SQL output trailing delimiter at end of row

Trailing delimiter at end of each row

Q: We are using Limagito File Mover, SQL as source, database is MSSQL.

SQL statement (Source)

select

  person_last_name as last_name

  , person_first_name as first_name

from
my_table

Common Options

Limagito File Mover SQL Common options

Issue

The value for the delimiter is appended at the end of each row. Is there a way to prevent this from happening? The output file is being automatically imported into a system, and that system does not like that extra delimiter at the end of the file. To explain what I’m talking about, the output to the file is currently like this:

last_name,first_name,

Doe,John,

Smith,Mary,

What we would like to see is this:

last_name,first_name

Doe,John

Smith,Mary

Thank you for any assistance you can give.

A: In version v2021.1.15.0 we added some extra options:

  • SQL Common options (default Enabled):
    • Trailing Line Break: Determines whether to add a line Break after the last line or not.
    • Trailing Line Delimiter: When enabled the value for the delimiter is appended at the end of each row

Please disable ‘Trailing Line Delimiter’. This will remove the delimiter at the end of each row.

Limagito File Mover SQL Common options

If you need any info about this option, please let us know.

Best regards,

Limagito Team

By Limagito SQL , , Share: