You are viewing limited content. For full access, please sign in.

Question

Question

Split a Field Value on a Variable to a Multi Valued Token

asked on February 5, 2019

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 

 

0 0

Answer

SELECTED ANSWER
replied on February 5, 2019

You need to check the Allow token to have multiple values box, otherwise you'll only get the first value.

1 0

Replies

replied on February 5, 2019

Haha, staring me RIGHT in the face and didn't even see it.

 

Thanks, that worked!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.