How to compare 2 field from 2 separated file

Linux and Unix-Like UNIX and Linux Applications
1

I have a problem here. I'm trying to compare multiple fields. Files are like this:

File 1:

Email,Account Number,Contact,Status,Date

File 2:

Name|Address|Contact|Email|Account Number|0000000

#!/bin/bash

myFolder=`pwd`
TEMPFILE=$myFolder/tempfile

APFILE=$myFolder/file 1.csv
APID=$myFolder/file 1.src

AAPFILE=`ls $myFolder/$1`
AAPID=$myFolder/file 2.src
AAPID2=$myFolder/file 2.src

AAPXAP=$myFolder/Result.csv

if [ -f $APFILE -a -f $AAPFILE ]
then
 cat $APFILE | cut -f1 -d, | sed 's/ //g' | sort | uniq > $APID
 cat $AAPFILE | cut  -f37 -d"|" | sort | uniq > $AAPID
 comm -23 $AAPID $APID > $AAPXAP

 echo "AAP vs AP done!"
fi

Thank You