Yes but I still like doing some things myself. Could do it in C if I had all the libraries from 30 years ago that I wrote when doing telco billing software.
Sent from my iPhone > On Dec 20, 2021, at 3:08 AM, Ryan Ray <[email protected]> wrote: > > > Do you have any software developers on staff? This should be pretty trivial > for them. > >> On Mon, Dec 20, 2021 at 1:53 AM Ryan Ray <[email protected]> wrote: >> regex and xlookup solves your issue >> >>> On Mon, Dec 20, 2021 at 1:41 AM Forrest Christian (List Account) >>> <[email protected]> wrote: >>> Sounds like a great project to learn python on. >>> >>> >>>> On Sun, Dec 19, 2021, 1:18 PM Chuck McCown via AF <[email protected]> wrote: >>>> Yes, hacking away. Mix of first name last and last name first. >>>> >>>> Sent from my iPhone >>>> >>>>>> On Dec 19, 2021, at 1:11 PM, Bill Prince <[email protected]> wrote: >>>>>> >>>>> >>>>> If the data isn't normalized, you are in for a lot of manual labor. >>>>> >>>>> >>>>> >>>>> bp >>>>> <part15sbs{at}gmail{dot}com> >>>>> On 12/19/2021 9:55 AM, Chuck McCown via AF wrote: >>>>>> My main problem is I don’t have consistent key field data. In one list >>>>>> names may have a middle initial or a middle initial with a period, it is >>>>>> totally missing in other lists or sporadically missing. Ditto >>>>>> addresses. But I am hacking away at it. I have something usable now. >>>>>> >>>>>> Chuck McCown >>>>>> McCown Technology Corporation >>>>>> 8401 N Commerce Dr >>>>>> Lake Point, Utah 84074 >>>>>> 801-250-9503 >>>>>> 435-830-4306 cell >>>>>> www.mccowntech.com >>>>>> www.microtrench-blades.com >>>>>> >>>>>> >>>>>> From: Mark - Myakka Technologies >>>>>> Sent: Sunday, December 19, 2021 10:44 AM >>>>>> To: AnimalFarm Microwave Users Group >>>>>> Subject: Re: [AFMUG] OT Merging Data >>>>>> >>>>>> Steve, >>>>>> >>>>>> If KEY fields match between data sets then VLOOKUP is the way to go. I >>>>>> think the new XLOOKUP is an enhanced option of VLOOKUP >>>>>> -- >>>>>> Best regards, >>>>>> Mark mailto:[email protected] >>>>>> >>>>>> Myakka Communications >>>>>> www.Myakka.com >>>>>> >>>>>> ------ >>>>>> >>>>>> Sunday, December 19, 2021, 12:23:28 PM, you wrote: >>>>>> >>>>>> >>>>>> That's what you have to do. I remember I just did multiple pages in one >>>>>> spreadsheet and it was a ton of sort commands and then the merging. I >>>>>> recall it does it all on the clip board and it's real easy to deselect >>>>>> the data for merging. >>>>>> >>>>>> I remember exporting data as csv helped by using notepad++ where I >>>>>> needed random blank cells added to get it in the right format. I dont >>>>>> remember the notepad++ plugin I had to use for that. >>>>>> >>>>>> Excel projects suck. Spend 30 hours learning to master a specific task >>>>>> that takes 2 minutes to perform and you will not remember how to do 2 >>>>>> years later when you need to do it again >>>>>> >>>>>> On Sat, Dec 18, 2021, 11:39 AM Bill Prince <[email protected]> wrote: >>>>>> >>>>>> 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 >>>> -- >>>> 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
-- AF mailing list [email protected] http://af.afmug.com/mailman/listinfo/af_af.afmug.com
