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

Question

Search While Ignoring Hyphens in [Workflow] 9.1

Workflow Version 9 Laserfiche Search and Retrieval

Updated March 4, 2015

asked on February 25, 2015

What is the Workflow syntax in order to perform search while ignoring hyphens?

We have a TaxID field that contains SSNs & TINs that is within a Search Repository task. I need Search to locate string entries that are duplicated, but with hyphens in different places. For example 11-1111111 & 111-11-1111.

0 0

Answer

SELECTED ANSWER

replied on March 4, 2015

Using Glenn's suggestion, I created 2 tokens and updated my Search Repository task with an 'OR' clause enclosed within parenthesis:

{LF:LOOKIN="DEV\Provider Services\Provider Filing Cabinet"} & {LF:Name="*", Type="F"} & {[]:[LastName_Entity]="%(LastName)*"} & (({[]:[TaxID]="%(TaxID_FEIN)"})|({[]:[TaxID]="%(TaxID_SSN)"}))

0 0

Replies

replied on February 26, 2015

You will need to use pattern matching and regular expressions to break apart the numbers and remove the hyphens, then use the regular expression tokens to perform the search. I have used this where our old CIS system stored names in the format of "last/first mi". I had to create two pattern matching tokens to break apart the name, then put it back together using the two newly created tokens.

Token 1

Token 2

Hope this example helps.

1 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked February 25, 2015
Updated March 4, 2015
223 views