0003 Replace LF character with space within the file
A practical Advanced ETL Processor example for building, testing, and adapting one automation workflow.
Use this example to build one working automation package, test it safely, and then adapt it to your own files, folders, or data rules. Start small. Automation is helpful; automated mistakes are just faster mistakes.
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 - Advanced ETL Processor transformation function
- The writer writes the result into the file within the target directory
Source file example
Result file
Related Advanced ETL Processor resources
For more automation examples, review the Advanced ETL Processor tutorials, read the WIKI, or download the Advanced ETL Processor Enterprise trial.