This function is used to extract components of long fields as delimited by a given fixed string. For example, suppose we had the following case fragment:
01 Jun 09 02 Nov 09 FullAddress Room 101 Bondi Beach Hotel^Campbell Pde^Bondi^NSW^2517 Room 99 Thirroul Hotel^Lawrence Hargreave Dve^Thirroul^NSW^2515
Then the Calculated Value Attribute with expression
part 3 of FullAddress split by “^”
would have values:
Bondi, Thirroul