Skip to Content

Remove Spaces in Flat file

Hi,

My source is sql table and my target is Flat file(.csv),i am getting spaces in csv format(target).

How can i remove the spaces in query transform before data goes to target.

Regards,

Saikrishna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 23 at 06:09 AM

    Hello Saikrishna,

    Try to use ltrim_blanks and rterim_blanks function on that column for which you're getting blanks.

    Eg: rtrim_blanks(ltrim_blanks(Table.col))

    Let us know if this helps!

    Thanks,

    Rajan

    Add comment
    10|10000 characters needed characters exceeded

    • Rajan Burad SAIKRISHNA BUYYAVARAPU

      Hello,

      There is one more solution which I can think of:

      Dump the data first into a temp table and then connect other dataflow.

      Use rtrim_blanks(ltrim_blanks(Table.col)) while dumping data in temp table.

      In that dataflow use temp table as a source and do one to one mapping in Query transform. After this dump the data in csv file.

      Let us know if this helps!

      Thanks,

      Rajan