Name: Field function
Author: Rob Vonk
Language: Informatica
Description:
This function returns the n-th field from a given string divided by a delimiter
Snippet:
Function Field(Source, Veldnummer, Delimiter)
substr(Source,
instr(Delimiter
SourceDelimiter, Delimiter, 1, KolNr),
instr(DelimiterSourceDelimiter, Delimiter, 1, KolNr+1) - instr(DelimiterSourceDelimiter, Delimiter, 1, KolNr) -1)