This Example Demonstrates how to Replace LF character with space within the file(s)
  • Download and install Advanced ETL Processor [Link]
  • Download and Unzip example [Link]
  • Create a new transformation and open .ats file

Directory 

  • Double click on the reader and point the directory at the source directory

Directory

  • Repeat the process for the data writer (Point it at the target directory)
  • Run the transformation by pressing the green arrow.
How it works:
  • Data reader reads the entire content of the file into the memory
  • The transformation runs Replace characters transformation function
  • The writer writes the result into the file within the target directory

Directory

Directory

Source file example

Directory

Result file

Directory

Please contact us if you need help with transforming the data

Visit ETL Tools Forum