I have a string field that is comma separated, the amount of commas can vary.
A, B, C
A, B, C, D
I would like to split and create a new field with the LAST value only, so from the above the new field value would be
I assume i would use a pipeline for this but functions like [-1] do not seem to work. Any ideas?
let abc_orig = to_string($message.testfield);
let abc = split(",\s*", abc_orig);
// and here the wheels fall off the bus [-1] does gives a processing error.