|Joe Blow||123 Anywhere Lane||Sometown||NH||03212||Match|
|Mary Smith||14 Someplace Else||Anothertown||NH||03121||No-Match|
|Lars Yerky||14000 Apache Blvd.|
Scenario.... I have a 10,000 row mailing list which I run through SmartyStreets, a validator which returns the address1,city,st,zip of the list as a ASCII delimited file, and a flag of MATCH or NO-MATCH in the first column of the returned file. Subsequent fields are the addres1, city, state zipcodes, and may or may not be valid....especially if there is a no match.
I'd like to import this file into my existing 10,000 record FM table, by adding additional MATCH field to the end of the original table , and have the information from SmartyStreets added to the field for each record.
Subsequently, I can do a FIND search on No-Match, and deal with the found set...
Both files in are in the same order but there is no key field (and the key field woudln't be returned by the validator in any case).
I know that I can paste the original file in Excel, and then paste the matched file into an additional Excel file (this is how I deal with this right now....but was wondering if there is a a way to do the import directly in FM.