#!/bin/bash

while read -r p; do
  USER=$(echo "$p" | sed 's/\s.*$//')
  ID=$(echo "$p" | sed 's/.* //')
  echo "$USER" "$ID"
  sed "s/\$UID/$USER/g" replacements.txt | sed "s/\$LDAPID/$ID/g" - >>replacements.sql
done <ldap_users.txt