Quote:
Originally Posted by
ghostdog74
for your example files, what's your output look like?
sorry, output would look like this:
File 1:
1692 @00000000201@00000205@20090402@000015000
1692 @00000000202@00000206@20090402@000010000
263157760@00000000401@00000201@20090402@000056250
510584583@00000000300@00000207@20090402@000030000
571764164@00000000100@00000128@20090402@000000500
571764164@00000000202@00000147@20090402@000005000
770000464@00000000100@00000125@20090402@000005000
770000464@00000000201@00000000@ @000005000
File 2:
1692 @RONALD F. SZOPA, DMD
004408365@STRESS REDUCTION SYSTEMS
010555926@B. FAREID, DDS A PROFESSIONAL CORP.
571764164@METABOLIC IMAGING MEDICAL GROUP
033464787@DAVID YUNG NING LI
770000464@COMPREHENSIVE MEDICAL G
263157760@TEST
510584583@PHOTO
Output:
1692 @00000000201@00000205@20090402@000015000@RONALD F. SZOPA, DMD
1692 @00000000202@00000206@20090402@000010000@RONALD F. SZOPA, DMD
263157760@00000000401@00000201@20090402@000056250@TEST
510584583@00000000300@00000207@20090402@000030000@PHOTO
571764164@00000000100@00000128@20090402@000000500@METABOLIC IMAGING MEDICAL GROUP
571764164@00000000202@00000147@20090402@000005000@METABOLIC IMAGING MEDICAL GROUP
770000464@00000000100@00000125@20090402@000005000@COMPREHENSIVE MEDICAL G
770000464@00000000201@00000000@ @000005000@COMPREHENSIVE MEDICAL G
I need all data from file 1 however there are a lot on File 2 that I do not need if it doesn't match file 1 field 1. Thank you for your help.