Question: For example, the first value ( FL . 2 0 2 3 . 1 7 . XS ) can be broken down as follows: State:

For example, the first value (FL.2023.17.XS) can be broken down as follows:
State: FL
Year: 2023
Item number: 17
Size: XL
What formula should be used to create a calculated field that holds the item number?
a) SPLIT([OrderID],1,,)
b) Split(2,[Order ID],".")
c) Split("/",1,[Order ID])
d) Order ID],".",3)
 For example, the first value (FL.2023.17.XS) can be broken down as

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!