Clean

File Cleaning will attempt to find and clean an input file to produce a cleaned, header free, extra newline removed file.

Please Note: File cleaning is built into every layer of Transforms. Even though there is a specific section to clean and re-download files, any file uploaded and used throughout the process is automatically cleaned before usage. Which means dropping the "dirty" sample property file below into a new transform will still clean it before transforming it.

A demo Property File

In this example our file contains extra "garbage" information above the real data. Much like a real "client file" we've all dealt with. It also has extra newlines between rows, and is generally pretty messed up for an automated system to read.

After sending it through the clean process, it produces a very clean, no-nonsense file that is capable of being read by most automated programs.

Last updated