Question

Apply Regular Expression to Tokens?

Connector

Updated April 21, 2015

asked on February 4, 2015

I have been using the LF Connector Test Utility with a 3rd party application and was wondering after the token is created from a field, can regular expressions be run against the tokens value? For instance, in our 3rd party application the social security number shows as 555-55-5555, but in Laserfiche they are stored as 555555555. Is there a way to take out the "-"?

0 0

Answer

SELECTED ANSWER

replied on February 4, 2015

LF Connector 9 doesn't support regular expressions running against the token values right now. But it provides some string manipulation functions such as sub-string, split, trim on the token values. As for your special instance, you can make it using those string manipulation functions.

1 0

Replies

replied on April 21, 2015

Forgive me for not fully understanding, but how/where would I manipulate the string to the output token? An example of the number I am working with is either 12345-001 or 123456-001 and I only want the part before the "-".

0 0

replied on April 21, 2015

See the help file for the example on SPLIT. You could split the value on the "-" and get the first value.

<Children>
   <Child name="SPLIT">
      <Attributes>
          <Attribute name="Delimiters" value="-"/>
          <Attribute name="IndexToReturn" value="1"/>
     </Attributes>
  </Child>
</Children>

2 0

replied on April 21, 2015

Thank you Miruna!

0 0

You are not allowed to follow up in this post.

Question

Question

Apply Regular Expression to Tokens?

Answer

Replies

Sign in to reply to this post.