Lured by the promise of data entry automation, my client, a 3rd party freight forwarder, has made an investment that involves receiving Carrier invoices via EDI. With EDI, everything comes in as a flat file, with only the carrier's name assigned an industry wide identification number called the SCAC Code ID. I do not believe the shippers nor the consignees are entered in uniformly with assigned I.D.'s amongst the carriers. I need to make a report that will group affiliated stores that are consignees. I do not know for certain that these carriers use relative databases, particularly if they receive EDI transmissions from others.
My first thought is to trim away spaces and punctuation (to minimize variations in naming conventions used) & then take the first 4 - 6 characters from what is left, & stripping away any trailing store numbers to create a common corporate name.
Does anyone have any better ideas on how to do this?
My first thought is to trim away spaces and punctuation (to minimize variations in naming conventions used) & then take the first 4 - 6 characters from what is left, & stripping away any trailing store numbers to create a common corporate name.
Does anyone have any better ideas on how to do this?