I have a field which stores 1 or 2 IDs.
I am trying to separate them out by using the Split function.
But I am not able to print the ID values.
here is my code:
If Count (Split ({Command.d},',' )) = 1 then Right({Command.id}, 11)
else
Right((Split ({Command.id},',' )[1]),11);
Right((Split ({Command.id},',' )[-1]),11);
it only prints the second value. I need to print both. The 2 IDs are then used to pull out data from another database. Can someone please point out where am I going wrong?
I am using the Right function to remove some char at the beginning of the ID.
I also tried:
stringvar array eid := (Split ({Command.id},',' ));
numbervar length := count(eid);
numbervar x;
for x := 1 to length do eid[x]
the above code only Print 'True'
Help!!!