The tiny amount of python I have done seemed easy enough except for linking external libraries. I could compile samples that had external functions but failed when doing it from scratch.
Sent from my iPhone > On Dec 20, 2021, at 2:40 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
