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