0

I need help with this trouble. In a transformation I create a text file delimited by semicolons from a table input, but when I look at the file, this shows me empty lines.

this is the transform I made: options in text file output

enter image description here

And this is the result: text file result

enter image description here

Ivan
  • 34,531
  • 8
  • 55
  • 100
SteveKhyuga
  • 1
  • 1
  • 1

2 Answers2

0

Try this:

In the Fields tab of the Text File Output step, make Trim Type = both for all the fields. Let me know how that goes.

Nikhil
  • 621
  • 1
  • 13
  • 25
  • Thnx for answer, but i put that configuration in the text file output step and the output is the same. – SteveKhyuga May 15 '17 at 14:05
  • the solution was make a function for delete the special characters, maybe some texts come with line jump or something. I appreciate the help. regards! – SteveKhyuga May 15 '17 at 15:23
0

Column8 seems to contain linebreaks. If the next consumer of your output CSV file is able to deal with linebreaks in text fields, enable option "Force the enclosure around fields", else you'll have to decide on whether you remove or replace those special characters which can be done on the server using SQL or on the client using a Replace-In-String step, for example.

marabu
  • 1,166
  • 7
  • 9
  • I try this, but the result is the same. Maybe was because i have 2 fields with CLOB type. Thanx for answer btw :) – SteveKhyuga May 15 '17 at 14:08
  • the solution was make a function for delete the special characters, maybe some texts come with line jump or something. I appreciate the help. regards! – SteveKhyuga May 15 '17 at 15:23