I have a field which stores 1 or 2 ID values.
I am trying to separate out the two by using Split function but I am not able to print the 2 values.
after separating the Two Ids, I need to fetch data from another database using these 2 Ids.
my code is :
If Count (Split ({Command.id},',' )) = 1 then Right({Command.id}, 11)
else
Right((Split ({Command.id},',' )[1]),11);
Right((Split ({Command.id},',' )[-1]),11);
it only print the last value. I want to print both. How do I do it?
I am using Right function to remove some char at the beginning of each ID.
Thanks in advance!