PICK
Formula Explanation
Splits a string using a delimiter and extracts the nth segment.
Formula Syntax
pick("string", "delimiter", pick_number)
- Both parameters can use column references, which are the CODEs at the top of each column in the table. For example: AA1.
Usage Example
Extract the first 4 characters from column DT2 and write the result into column DT3.
DT3 = pick(DT2,"-",1)