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 |
