The EXTRACT function is used to split a string based on a delimiter and return the segment at the specified position. The campaign names are structured with the segment of interest followed by an '@' sign. Therefore, the formula needs to extract the segment before the '@'.
The correct formula is: EXTRACT(csv['campaign_name']; '@', 1). This will take the 'campaign_name' field, split it at the '@' sign, and return the first segment (position 1), which is the three-letter code that is required. The other options are incorrect because they do not properly specify the delimiter and the segment position in the way needed to achieve the desired outcome.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit