Python, and to a slightly lesser degree Perl are extremely flexible in matching up types between ascii and numerical.
bp
<part15sbs{at}gmail{dot}com>
On 12/20/2021 9:31 AM, Chuck McCown via
AF wrote:
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.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 issueOn 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
Sent: Sunday, December 19, 2021 10:44 AMSubject: Re: [AFMUG] OT Merging DataSteve,
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
