Multiple choice technology

Field(‘Jhon|Micky|gail|’,’|’,1) = ?

  1. Micky

  2. Jhon

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

The Field function extracts substrings based on delimiter position. Field('Jhon|Micky|gail|', '|', 1) returns 'Jhon' because it extracts the substring after the first delimiter '|'. The first delimiter is at position 0, so index 1 gives us 'Jhon'. The trailing delimiter doesn't create an empty field that's returned by index 1.

Keep practicing — related questions