forked from andrebradshaw/utilities
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathtableMatcher_testFile_FLMLS
More file actions
16 lines (16 loc) · 866 Bytes
/
tableMatcher_testFile_FLMLS
File metadata and controls
16 lines (16 loc) · 866 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
function mergeOnName(){
var temp = ['id', 'first name', 'last name', 'type', 'license num', 'status', 'issue date', 'expiry date', 'county', 'zip code', 'state', 'city', 'street', 'flmsFirst', 'flmsLast', 'phone1', 'phone2'. 'phone3', 'email', 'company', 'company phone'];
for(let i = 0; i < flmlsArr.length; i++){
for(let r = 0; r<dadeCounty.length; r++){
var flrecNameFirst = dadeCounty[r][1];
var flrecNameLast = dadeCounty[r][2];
var flmlsNameFirst = new RegExp(flmlsArr[i][0], 'i');
var flmlsNameLast = new RegExp(flmlsArr[i][1], 'i');
if(flmlsNameLast.test(flrecNameLast) && flmlsNameFirst.test(flrecNameFirst)){
var tarr = dadeCounty[r].concat([flmlsArr[i][0],flmlsArr[i][1],flmlsArr[i][2],flmlsArr[i][3],flmlsArr[i][4],flmlsArr[i][4],flmlsArr[i][5],flmlsArr[i][6]]);
temp.push(tarr)
}
}
}
}
var matchedArrFL = mergeOnName()