Filtering empty properties

When checked, the Filter Empty Properties setting on the General tab of the Record Adapter editor filters out empty property values when the source data is read into the Data Foundry.

For example, assume the following source data contains properties delimited by the pipe ('|') character.

WineID|Region|WineType|Price

1||Merlot|8.99

2||Chardonay|14.99

3||Chianti|19.99

4|||10.99

5||Merlot|18.99

6||Spumante

7|Sonoma|Chablis|9.99

A record adapter with Filter Empty Properties checked would filter the Region property from records 1 through 6, and the Region and WineType properties from record 4. If Filter Empty Properties is not checked, an empty string (' ') is assigned to the empty properties.