I imported a plain text file and discovered that some words have hyphens that shouldn't be there. Perhaps due to someone along the way copied word data and pasted to a plain text file. I ended up using a text editor and doing a manual find and replace for each file in order to correct the issue. Does anyone have an idea if this could be automated for future situations?
One could not simply do a find and replace because there are words that legitimately should be hyphenated. Or would it require building a list of hyphenating words and end up being more time consuming than manually reviewing each instance of a find and replace? Field in question is Long Text.
Remove hyphen:
re-search ==> research
Keep hyphen:
interest-free ==> interest-free
One could not simply do a find and replace because there are words that legitimately should be hyphenated. Or would it require building a list of hyphenating words and end up being more time consuming than manually reviewing each instance of a find and replace? Field in question is Long Text.
Remove hyphen:
re-search ==> research
Keep hyphen:
interest-free ==> interest-free