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.

You seem to be mixing (in the 2 Variables) | and , as delimiter which will not work. If you want to use | (which might not work) you need to use comma as delimiter throughout.

---