Consider the Apartment Rental data source. Let's say the naming convention of the apartment actually has the building and the unit number; for example, the apartment named A-2 is unit 2 in building A.
In the Chapter 03 workbook, create a couple of calculated fields. Name the first building with the following code:
SPLIT([Apartment], "-", 1)
Then create another calculated field named Unit with the following code:
SPLIT([Apartment], "-", 2)
Both of these functions use the Split() function, which splits a string into multiple values and keeps one based on a delimiter and a token number. The function takes three arguments: the string, the delimiter (value separator), and the token number (which value to keep from the split: ...
