I am thinking of using the Calculated Fields option to extract one field.
I have following values in a field name "YOURFIELD"
I want to extract the characters before "_" in a new field "MYFIELD". The result will be:
Can please help me to extract this result in calculated fields using an EVAL function or any other method?