Which command should be used first, the eval or the sort?

A user wants to convert numeric field values to strings and also to sort on those values.

Which command should be used first, the eval or the sort?
A . It doesn’t matter whether eval or sort is used first.
B . Convert the numeric to a string with eval first, then sort.
C . Use sort first, then convert the numeric to a string with eval.
D . You cannot use the sort command and the eval command on the same field.

View Answer

Answer: C

Explanation:

The eval command is used to create new fields or modify existing fields based on an expression2. The sort command is used to sort the results by one or more fields in ascending or descending order2. If you want to convert numeric field values to strings and also sort on those values, you should use the sort command first, then use the eval command to convert the values to strings2. This way, the sort command will use the original numeric values for sorting, rather than the converted string values which may not sort correctly. Therefore, option C is correct, while options A, B and D are incorrect.