Multiple choice technology

FIELD ("+1+2+3ABAC","+", 2,2) =?

  1. 1

  2. 1+2

  3. 3ABAC

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The FIELD function extracts a substring between two occurrences of a delimiter. FIELD("+1+2+3ABAC", "+", 2, 4) means: find the substring between the 2nd and 4th occurrences of "+". The delimiters are at positions: 1st at 0, 2nd at 2, 3rd at 4, 4th at 6. The substring between positions 2 and 4 is "1+2".

Keep practicing — related questions