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
- Double-click on the reader and point the directory at the source 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
Source file example
Result file
Please contact us if you need help with transforming the data
Visit ETL Tools Forum |