REPORTS - rename bank reports

RBA csv format

03-1,FSTM1106934995_20260605.pdf
06-1,FSTM1106934995_20260420.pdf
10-01-001,FSTM1106934995_20260204.pdf
10-01-002,FSTM1106934995_20260226.pdf

csv gsheet formula

=ARRAYFORMULA(IF((BQ3:BQ666="")+(BR3:BR666="");"";BQ3:BQ666&","&BR3:BR666))

RBA shell skripta

chmod +x rename_files_RBA.sh
./rename_files_RBA.sh renames_RBA.csv "/path/to/your/local/Drive/folder"

#!/bin/bash
# usage: ./rename_files.sh renames.csv /path/to/your/drive/folder

CSV="$1"
ROOT="$2"
DEST="./renamed"

mkdir -p "$DEST"

cat "$CSV" | while IFS=',' read -r ref filename; do
  match=$(find "$ROOT" -type f -iname "$filename" | head -n 1)

  if [ -z "$match" ]; then
    echo "NOT FOUND: $filename"
    continue
  fi

  newname="${ref}-${filename}"
  cp -v "$match" "$DEST/$newname"
done

e.g.

FSTM1106934995_20260101.* > 01-1-FSTM1106934995_20260101.*