Suppose you have the following field:

Order ID

FL$\mathrm{.}2023\mathrm{.}17.$XS

MA$\mathrm{.}2022\mathrm{.}52.$S

MA$\mathrm{.}2023\mathrm{.}9.$M

CA$\mathrm{.}2020\mathrm{.}18.$XL

Note that the Order ID has four components: the state abbreviation, the year, the item number, and the size. For

example, looking at the first value $($FL$\mathrm{.}2023\mathrm{.}17.$XS$)$:

$FL$

Year: $2023$

Item number: $17$

$,$ Size: $x$

If you were to create a calculated field using the formula: SPLIT$([$Order ID$],"/,",1)$

What piece of information would be returned?

State

Year

Item Number

Size

None of the above; the formula needs to be updated in order to return one of the four values.