Hi, everybody

I need to select a subset of a string field, e.g., substring(myfield,1,10)+ substring(myfield,25,5).
I thought in two approaches:

1- Create an calculated field and index it
2-Create a view with that subset and index it.

Is there any better or simpler way to do that?

TIA