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
