#!/usr/bin/env bash
f=/home/claude/amd-agent-downloads/CareTeamRosterByProvider.xlsx
out=/tmp/amd_phi_result.txt
{
  echo "=== zip contents ==="
  unzip -l "$f" 2>/dev/null
  echo "=== PHI keyword scan across all xml parts ==="
  for part in $(unzip -Z1 "$f" 2>/dev/null | grep -i xml); do
    unzip -p "$f" "$part" 2>/dev/null \
      | grep -o -i -E "PatientName|ChartNumber|Patient|Chart|DOB|MRN|SSN|FirstName|LastName" \
      | sort -u | sed "s/^/[$part] /"
  done
  echo "=== first 2000 chars of sharedStrings ==="
  unzip -p "$f" xl/sharedStrings.xml 2>/dev/null | head -c 2000
  echo ""
  echo "=== END ==="
} > "$out" 2>&1