Conversion table or other options?
Hi, We pull our well data from a source that doesn't spell check or account for different versions of the same name.
Example: these are all "Devon"
DEVON
DEVON ENERGY
DEVON ...
Forum Discussion
I had a similar issue and in my head there is no solution besides manually programming it in a formula text field, (so for this example, if(Contains,[Company],"Devon"),"Devon" and then do this 50 or 100 times or however many scenarios you have).
I believe the only other possible solution would be if ALL of your instances followed the same pattern, ie if in every scenario you were ALWAYS taking the first word as the final, then that of course is a simple formula. But if all your situations are unique, then that is equivalent to needing to write a code where an AI system can evaluate the entire string and start guessing at what the final answer should be.
------------------------------
Mike Tamoush
------------------------------
I believe the only other possible solution would be if ALL of your instances followed the same pattern, ie if in every scenario you were ALWAYS taking the first word as the final, then that of course is a simple formula. But if all your situations are unique, then that is equivalent to needing to write a code where an AI system can evaluate the entire string and start guessing at what the final answer should be.
------------------------------
Mike Tamoush
------------------------------