#!/bin/bash
# ideone boilerplate: run in temp dir
t=$(mktemp -d -t ideone.XXXXXXXX) || exit
trap 'rm -rf "$t"' ERR EXIT
cd "$t"
cat <<\: >file1
2001009
@vanti Finserv Co.
2001009
Fund #1
11:11 - capital
MS&CO(NY)
American Friends Org, Inc. 12X32
Domain-Name (LLC)
MS&CO(NY)
MS&CO(NY)
Ivy/Estate Rd
E*Trade wholesale
:
cat <<\: >file2
<>span class="table">Records
| Rec1 |
Rec2 |
Rec3 |
Rec4 |
Rec5 |
Rec6 |
Rec7 |
Rec8 |
| @vanti Finserv Co. |
11:11 - Capital |
MS&CO(NY) |
New York |
CDX98XSD |
E*Trade wholesale |
Domain-Name (LLC) |
Ivy/Estate Rd |
|
| @vanti Finserv Co. |
|
MS&CO(NY) |
2 |
2 |
MS&CO(NY) |
MS&CO(NY) |
Ivy/Estate Rd |
:
awk 'NR==FNR {
regex = $0;
gsub(/[][(){}|\\*+?.^$]/, "\\\\&", regex);
a[++n] = regex;
print "## a[" n "] = \047" regex "\047"
gsub(/[A-Za-z0-9]/, "#");
gsub(/&/, "\\\\&");
b[n] = $0;
next
}
{ for(i=1;i<=n;++i)
gsub(a[i], b[i])
} 1' file1 file2