I’m trying to extract a portion of a string that is delimited? I have a formula that concatenates three fields delimited by a comma. The concatenation allows me to distinctly identify a particular industry group a customer belongs to.

There are three fields in a customer record that I am interested in using, the source system it comes from, the customer number, and the industry group it belongs to. My concatenated string ({@industryIdentifier}) looks like this:

 

industry1, cust1, system1

industry2, cust2, system2

industry3, cust2, system2

industry3, cust3, system3

industry1, cust4, system1

industry2, cust5, system3

 

When I use the Split function; Split (({@industryIdentifier}, “,”, 1), I get the following message “The result of a formula cannot be an array”.  Can this be done?