cancel
Showing results for 
Search instead for 
Did you mean: 

Searching for terms that contain an apostrophe in Clearwell

Rick_McLuckie
Level 2

I am having difficulty searching for terms that contain an apostrophe in Clearwell.  For example, I want to look for the word "fed's" throughout the data set.  I know that Clearwell treats an apostrophe as a trim character and will only return the word "fed".  Is there a way to return the words that contain the apostrophe or do I need to change how Clearwell handles the apostrophe?

1 ACCEPTED SOLUTION

Accepted Solutions

Daly
Level 5
Partner Employee Accredited Certified

Hello Rick,

I've just tried with the example "I'll" [i will] on stock data, it did return as expected. I also tried with the wildcard char ?, so "I?ll", this also worked.

With the single char wildcard, does this return expected results?

View solution in original post

3 REPLIES 3

Daly
Level 5
Partner Employee Accredited Certified

Hello Rick,

I've just tried with the example "I'll" [i will] on stock data, it did return as expected. I also tried with the wildcard char ?, so "I?ll", this also worked.

With the single char wildcard, does this return expected results?

JimmyNeutron
Level 6
Partner Accredited

since theres not many iterations of words starting with fed just use fed*

JimmyNeutron
Level 6
Partner Accredited

Hi,

Did you get this resolved?