I should. I did a few projects with it where the sample code was essentially all I needed. Just a few tweaks. But that whole reference to functions or libraries that are somewhere else thing tripped me up.
From: Bill Prince Sent: Monday, December 20, 2021 10:16 AM To: [email protected] Subject: Re: [AFMUG] OT Merging Data You should learn python. It is made for stuff like this. bp <part15sbs{at}gmail{dot}com>On 12/20/2021 7:33 AM, Chuck McCown via AF wrote: 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 mailto:[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
-- AF mailing list [email protected] http://af.afmug.com/mailman/listinfo/af_af.afmug.com
