graph TD
A[Input: Raw CSV Text] --> B[Split Text by Lines]
B --> C[Initial Validation]
C --> D{Has Required Fields?}
D -->|No| E[Discard Row]
D -->|Yes| F[Deduplicate Records]
F --> G[Phone Number Normalization]
G --> H[Clean Whitespace]
H --> I[Normalize City Case]
I --> J[Reorder Columns]
J --> K[Format Final CSV]
K --> L[Output: Clean CSV Text]
subgraph Deduplication Silo
F
end
subgraph Format Normalization Silo
G --> H --> I
end
subgraph CSV Finalization
J --> K
end