regex and xlookup solves your issue
On Mon, Dec 20, 2021 at 1:41 AM Forrest Christian (List Account) <
li...@packetflux.com> wrote:
> Sounds like a great project to learn python on.
>
>
> On Sun, Dec 19, 2021, 1:18 PM Chuck McCown via AF <af@af.afmug.com> 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 <part15...@gmail.com> 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:m...@mailmt.com
>>
>> 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 <part15...@gmail.com> 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
>> AF@af.afmug.com
>> http://af.afmug.com/mailman/listinfo/af_af.afmug.com
>>
>> ------------------------------
>> --
>> AF mailing list
>> AF@af.afmug.com
>> http://af.afmug.com/mailman/listinfo/af_af.afmug.com
>>
>> --
>> AF mailing list
>> AF@af.afmug.com
>> http://af.afmug.com/mailman/listinfo/af_af.afmug.com
>>
>> --
>> AF mailing list
>> AF@af.afmug.com
>> http://af.afmug.com/mailman/listinfo/af_af.afmug.com
>>
> --
> AF mailing list
> AF@af.afmug.com
> http://af.afmug.com/mailman/listinfo/af_af.afmug.com
>
--
AF mailing list
AF@af.afmug.com
http://af.afmug.com/mailman/listinfo/af_af.afmug.com
