Rebuilding an Index

[Wickerman]

I have a field I am trying to clean up that has had inconsistent data-entry practices over time.  One area of variation is capitalization. When I popped open the index I saw things entries like things like:

Drama  /   comedy  /  Silent cinema  / Silent Cinema / silent cinema . . . 

So, I used  TextStyleAdd(FIELD ; Titlecase) to replace all the values with consistently capitalized words.  Worked great. 

Then i went to the field's Options panel and turned OFF indexing, saved changes, shut down the database, reopened, and then went back and set indexing to 'Minimal' since I'm just interested in the Values, not the individual words.  I saved, quit the database and reopened . . .

But when I enter the field, I STILL get the old  uncapitalized versions of the values, even though there are no such entries any longer.  When I search on "comedy" by clicking the term in the index, I get hits on "Comedy" -- there are no longer any "comedy".

So, how can I get those uncapitalized entries out of the Index?

[comment]

The TextStyleAdd() function does not modify the actual characters stored in the field - it merely styles them for display. To achieve your stated purpose, you need to use the Proper() function (and you should also add TextFormatRemove() to undo what you did). 

[Tom Assia]

Hello,

Just in addition of comment post, if ou want to rebuild and index of database you could use SQL with drop index and then create index.

Tell me if you want an example

Tom

[Wickerman]

Thanks Tom, I appreciate the offer, but comment's suggestion was on point, as usual 

Thanks to you both!

Edited September 12, 2018 by Lee Smith
corrected spelling of comment's name