Remove Spaces in Flat file

[former_member573000]

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

[rajan_burad]

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

[former_member573000]

Hi Rajan,

Thanks for your reply.

It is not working,can u havr the alternate solution for this.

Regards,

Saikrishna

[rajan_burad]

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