Skip to Content
0

Remove Spaces in Flat file

Apr 23 at 05:45 AM

25

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Rajan Burad Apr 23 at 06:09 AM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Rajan,

Thanks for your reply.

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

Regards,

Saikrishna

0
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

0