Hi Friends,
Can anyone help me with comparing the records in twofiles,
I have two files (csv)
FILE1:
1023,SMITH JAMES , (203) 789-1249
1023,HARRY POTTER , (213) 789-1249
1023,JONES D, (903) 789-1249
FILE1:
1023,SMITH ,2037891249
1023,HARRY , 2137891249
1023,JONES, 7037891249
it should return only one row i.e 1023,JONES, 7037891249 as they are different,It has to supress the "(" chareacters and blank ones.
Thanks in advance for your help.
S
(203) 789-1249 and 2037891249,
I have to compare these