We have software that can bring in files from a shared drive, into Laserfiche. This software is SIMILAR to Import Agent, except it brings data in with each file and parses a text file that is pipe delimited that has metadata.
The downside to this software is that it does not have the ability to bring in Multi Valued Fields. So in the meantime, what I've decided to do as a work around, is "double plus" any values that have a multi value field, such as this
COMPANY HERE++COMPANY HERE TWO
Then what happens is as the files come in, a simple workflow runs that Grabs the Metadata Fields, determines in the metadata fields have a "++" in them, if they do, then split them into multi fields. Picture of the workflow below.
So in the Multi Value Field, I want it to be
"COMPANY HERE"
"COMPANY HERE TWO"
But instead what I'm getting is
But instead I'm getting
And I could index, but the problem is there could be so many names, etc, per field
Can anyone out there help and tell me why split function isn't working when trying to update the Multi Value field
Thanks