Hi Henrik
I am trying the new(ish) GetColumn function and it doesn't seem to be doing what I would expect it to do.
I am reading a delimited file with 2 Rows with a vertical bar delimiter '|'. This file was created by VC and is used numerous times throguh many jobs.
I am assigning the results (STDOUT) of the previous step to a variable using this syntax:
{STRING(GetColumn|2|\r\n|25|||{TASK(5f29f8a0-d9c0-4029-a1ad-3fc2e867328d,StdOut)})}
I have tried it with and without Row Delimiters (\r\n) and also using a comma as a delimiter instead of the vert bar.
I have tried it with the Direct ID of the STDOUT of the Read File task, and also with Active Task, but still no luck.
Whatever I try I get 'Error in Argument'.
If I change the delimiter in the external file from a '|' to a comma or a '#' it works, so it seems as though the function is sensitive to particular delimiters, i.e. the '|'.
It is a huge task to change all VC jobs now that reference this external file so is there a way to use GetColumn with the '|' delimiter?
Cheers
Andy
p.s this seems to be an issue with all the 'Get.....' functions.