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

Question

Question

regular expression to find capitalized word in a full text search

asked on April 24, 2018

Hello,

Can anyone help with the expression I would use to find the word CHARTER - all uppercase -  in a text search?  

Thanks!

Linda

0 0

Replies

replied on April 24, 2018

The Pattern Matching activity has a checkbox that you can enable or disable to return case sensitive matches. Alternately, you can try (?-i)CHARTER to match all uppercase.

0 0
replied on April 24, 2018

I did try some different combinations in pattern matching in the workflow designer but they did not work when I tried the advanced search in the client.  Unfortunately (?-1)CHARTER didn't work either :(  Any other suggestions? 

0 0
replied on April 24, 2018

Hi Linda, just to double-check, were you using (?-1) or (?-i) in the pattern? It should be the latter, a lowercase letter i.

If that was your pattern, do you mean that this works when testing in the Workflow Designer, but not when used against document text in practice?

0 0
replied on April 24, 2018

Alternatively, are you just asking how to specify casing in a full-text search of entry text in the repository? If that's the case, this wouldn't be done per-search in the search syntax.

1. Repository defaults can be set in the Administration Console.
2. Per user, this can be set in user options.
3. The per-user option in (2) is equivalent to setting the [Settings]SearchCollationRule attribute. To set it to "Case Sensitive, Accent Sensitive" this would take the value "CS,AS".

0 0
replied on April 26, 2018

Hi James, we did try your suggestions without any luck. 

 

 

We are still getting lowercase in the searches. We also tried Karina suggestion for an Advanced Search and we are still getting mixed and lowercase results in our searches. 

 

0 0
replied on April 26, 2018

That's my bad. The attribute does not apply to indexed searches, and full-text search is definitely an indexed search. Sorry about that.

I'm actually not sure whether the index itself supports case sensitivity.

0 0
replied on April 26, 2018

No worries, I saw that and thought I didn't understand something about indexing smiley

I appreciate your trying to help.  

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

Sign in to reply to this post.