Cleaning Inconsistent Log Data in Excel

What functions would you use to clean inconsistent log file data in Excel?

Translate this cleaning task into PostgreSQL. Normalize whitespace, capitalization, blank values, event labels, timestamps, and source codes, while identifying rows that need review.

Output

1. One row per raw log, ordered by log_id ascending.
2. Columns: log_id, source_name, cleaned_event_type, cleaned_user_id, cleaned_event_at, cleaned_message, and data_quality_status.
3. Use CLEAN when required cleaned fields and the source match are valid; otherwise use REVIEW.

Output details

• Trim source codes, uppercase them for matching, and emit Unknown source when no matching source exists.
• Lowercase event labels, trim them, collapse whitespace, and replace whitespace runs with underscores.
• Convert blank user_id and message values to NULL; treat blank event labels and source codes likewise.
• Parse timestamps only in YYYY-MM-DD HH:MM:SS or YYYY/MM/DD HH:MM formats; represent all others as NULL.
• Set data_quality_status to CLEAN only when the source matches and cleaned event type, user ID, timestamp, and message are non-NULL; otherwise use REVIEW.