The DBI module in perl can read csv files like a database. It would be pretty quick to open one with say names and addresses, then search second for matching addresses, update the first with the phones, then search the 3rd with matching phones and update the first with email addresses. This presupposes the addresses and phones are in the same format in both like with number of spaces, etc. I suppose you could strip out all non alpha-numeric characters, make everything lowercase in the variables, and try to match that way if they are not identical info. Otherwise now you are looking at some regex to figure out matches.
On Sat, Dec 18, 2021 at 1:15 PM Chuck McCown via AF <[email protected]> wrote: > That is helpful, thanks. > > > > *From:* Bill Prince > *Sent:* Saturday, December 18, 2021 10:38 AM > *To:* [email protected] > *Subject:* Re: [AFMUG] OT Merging Data > > > I would start with a 4th spreadsheet with all the columns you need (names, > addresses, phone numbers, and email addresses). > > Then the challenge is the merge. > > Try something like this: > https://community.powerbi.com/t5/Desktop/Combine-multiple-excel-files-with-different-structure-columns/td-p/1372702 > > bp > <part15sbs{at}gmail{dot}com> > > On 12/18/2021 9:02 AM, Chuck McCown via AF wrote: > > > I have at least three files I need to merge. Spreadsheets. > > Say one has names and addresses > One has addresses and phone numbers > One has phone numbers and email addresses > > They are not the same length of file so certain records are missing in all > three files. > There is something common to allow one file to be merged into at least one > of the other files. > > I really don’t want to write code to parse and search. > I am hopeful there is some kind of feature in excel that could do this. > Or I guess I might be able to fire up a database and make it happen. > > Any suggestions? > > ------------------------------ > -- > AF mailing list > [email protected] > http://af.afmug.com/mailman/listinfo/af_af.afmug.com > > -- > AF mailing list > [email protected] > http://af.afmug.com/mailman/listinfo/af_af.afmug.com >
-- AF mailing list [email protected] http://af.afmug.com/mailman/listinfo/af_af.afmug.com
