Cleaning Project Report

Summary

PropertyValue
Right File Cleaner Version1.0.0.0
Report Created22.03.2010 15:12
Source FileD:\ImportInfoQ4.txt
Output FileD:\ImportInfoQ4_clear.txt
Save Duplicated Records toD:\ImportInfoQ4.dup.txt
Save Broken Records toD:\ImportInfoQ4.broken.txt
Save Cleaning Report toD:\ImportInfoQ4.html
Number of Data Columns4

General Cleaning Rules

OptionProperty
Capitalization modeWord Word Word...
Remove leading spacesTrue
Remove trailing spacesTrue
Remove duplicated spacesFalse
Add lost spacesFalse
Remove non-printable symbolsTrue

Column Level Cleaning Rules

ColumnOptionProperty
IDCapitalization modeWord Word Word...
IDRemove leading spacesTrue
IDRemove trailing spacesTrue
IDRemove duplicated spacesFalse
IDAdd lost spacesFalse
IDRemove non-printable symbolsTrue
ProviderCapitalization modeWord Word Word...
ProviderRemove leading spacesTrue
ProviderRemove trailing spacesTrue
ProviderRemove duplicated spacesFalse
ProviderAdd lost spacesTrue
ProviderRemove non-printable symbolsTrue
ItemCapitalization modeWord Word Word...
ItemRemove leading spacesTrue
ItemRemove trailing spacesTrue
ItemRemove duplicated spacesFalse
ItemAdd lost spacesFalse
ItemRemove non-printable symbolsTrue
QtyCapitalization modeWord Word Word...
QtyRemove leading spacesTrue
QtyRemove trailing spacesTrue
QtyRemove duplicated spacesFalse
QtyAdd lost spacesFalse
QtyRemove non-printable symbolsTrue