#!/usr/bin/env bash
f=/home/claude/amd-agent-downloads/CareTeamRosterByProvider.xlsx
out=/tmp/amd_phi_result4.txt
{
  echo "=== PHI keyword hits in sheet1.xml ==="
  unzip -p "$f" xl/worksheets/sheet1.xml 2>/dev/null \
    | grep -o -i -E "PatientName|ChartNumber|Patient|Chart|DOB|MRN|SSN|FirstName|LastName" \
    | sort | uniq -c
  echo "=== first 1500 chars of sheet1.xml ==="
  unzip -p "$f" xl/worksheets/sheet1.xml 2>/dev/null | head -c 1500
  echo ""
  echo "=== docProps/app.xml (sheet/title metadata) ==="
  unzip -p "$f" docProps/app.xml 2>/dev/null
  echo ""
  echo "=== END ==="
} > "$out" 2>&1