I wonder...I know that sed would work to find and replace the terms in all
of the csv files that I am indexing but would it work to find and replace
key terms in the index?
find C:\\tmp\\index\\data -type f -exec sed -i 's/AF/AFGHANISTAN/g' {} \;
That command would iterate through all the files in the data directory and
replace the country code with the full country name. I many just back up the
directory and try it. I have it running on csv files right now and it's
working wonderfully. For those of you interested, I am indexing the entire
Geonames dataset http://download.geonames.org/export/dump/ (allCountries.zip)
which gives me a pretty comprehensive world gazetteer. My next step is gonna
be to display the results as KML to view over a google globe.
Thoughts?
Adam
On Fri, Dec 3, 2010 at 7:57 AM, Erick Erickson <erickerick...@gmail.com>wrote:
> No, there's no equivalent to SQL update for all values in a column. You'll
> have to reindex all the documents.
>
> On Thu, Dec 2, 2010 at 10:52 PM, Adam Estrada <
> estrada.adam.gro...@gmail.com
> > wrote:
>
> > OK part 2 of my previous question...
> >
> > Is there a way to batch update field values based on a certain criteria?
> > For example, if thousands of documents have a field value of 'US' can I
> > update all of them to 'United States' programmatically?
> >
> > Adam
>
