I understand what you have and what you would need to do.
I just tested to see if you can easily use the list for lookup but that
does not work, that will only work when you split the file with the
lists to have 1 name and 1 number in it.
You should create a second table in the first file to enter these values
and then you can create a relation between the 2 land plat numbers
You can then easily create a portal to either show all owners from the
view of the land plat view.
Kind regards, Maarten.
On 23-4-2023 15:21, Charles Hartley wrote:
Maarten, thank you for responding. I had thought of separating the
entries into separate fields, but I still need to compare fields in
separate files.
Perhaps if I explain in more detail what I need to do, it may be
helpful. I have in one file 1,745 records, each containing two fields:
(1) names of land plats, and (2) reference numbers for the plats.
In the second file containing over 4,000 records I have a field that
contains names of people, and a second field that lists all the land
plats where that person's name is found, separated by semicolons. This
field contains a minimum of two entries, up to one containing 56
entries (separated with semicolons).
What I had hoped to do was use a script to capture each entry from
file 2, field 2, and then compare it to the records in file 1, field
1, and upon finding a match copy the reference number from file 1 back
to file 2.
Thanks for your patience.
Charlie
On Sun, Apr 23, 2023 at 2:13 AM Maarten Sjouw <[email protected]> wrote:
Hey Charlie,
You can use lookup for what you want to do, however I would not do
it that way, no need for scripting at all, just export the second
file to a CSV file, use a text editor and check which separator is
used between the first and second piece of data and replace the
semicolon with that.
sample:
"field1","field2-part1;part2;part3"
Change this to:
"field1","field2-part1","part2","part3"
No make sure you have enough fields in your file you want the data
to be moved into and import the just created CSV text file.
Kind regards, Maarten.
On 23-4-2023 3:53, Charles Hartley wrote:
Hi.
Hopefully this is a simple thing and you won't mind helping an
old man whose mind isn't as sharp as it once was.
I have two files, the first with two fields, one containing known
data, and the second empty. The second file also contains two
fields, one that matches the first field in the first file, and
the second contains data that I want to place in the first file's
empty folder by matching the other fields.
I would just combine the files with matching data except that the
matching field in the first file actually contains multiple
pieces of data separated by semicolons. What I hope to do is
write a script in the first file that first grabs one piece of
data from that field and then match it to the second file field,
and then copy the other field's data into the first file's empty
field. Hope this makes sense.
Is this doable?
Thanks,
Charlie
