Thanks, I made good headway with Excel. I am waiting for some more data.
Sent from my iPhone
> On Dec 18, 2021, at 1:18 PM, Brian Webster wrote:
>
>
> Chuck if you don’t get that task done send the files to me and I can probably
> link them up and merge the file. My GIS software lets me
We have interference from Mexico but most is on this side...water and gas
utilities are deploying 11GHz for ptp and 5GHz for ptmp...that's all recent
noise...I have seen new ICE/BP trucks with on board radars...guess they
tracking drones and small planes...there are mountains all over plus with
Chuck if you don’t get that task done send the files to me and I can probably
link them up and merge the file. My GIS software lets me work with csv files
and tables and do some cool stuff with matching and such.
Thank you,
Brian Webster
www.wirelessmapping.com
From: AF
If the common thing between them is something like an email address or
account number, I wonder if the venerable vlookup or the new xlookup will
work?
Then I agree with making a new file or sheet and put that common value in
one column and remove duplicates.
Then use columns B,C,D,E,F, etc to
The DBI module in perl can read csv files like a database. It would be
pretty quick to open one with say names and addresses, then search second
for matching addresses, update the first with the phones, then search the
3rd with matching phones and update the first with email addresses. This
That is helpful, thanks.
From: Bill Prince
Sent: Saturday, December 18, 2021 10:38 AM
To: af@af.afmug.com
Subject: Re: [AFMUG] OT Merging Data
I would start with a 4th spreadsheet with all the columns you need (names,
addresses, phone numbers, and email addresses).
Then the challenge is
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:
I have watched a few excel videos about it this morning but they are more
focused on merging similar records.
From: Steve Jones
Sent: Saturday, December 18, 2021 10:30 AM
To: AnimalFarm Microwave Users Group
Subject: Re: [AFMUG] OT Merging Data
I've done this stuff before. Takes a lot of
I've done this stuff before. Takes a lot of google foo and formatting of
each file. And the first time you achieve your goal, it will visually
present the way you want then randomly revert.
Once it's done you'll never retain the knowlege and have to start the
google foo again next time.
But yes,
Fiber is all there is. Theres enough fed money in play that there should be
no new funded wireless going up
On Fri, Dec 17, 2021, 12:19 PM Chuck McCown via AF wrote:
> Fiber
>
> *From:* Jaime Solorza
> *Sent:* Friday, December 17, 2021 9:34 AM
> *To:* AnimalFarm Microwave Users Group
>
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
11 matches
Mail list logo