String comparision

[#1]

Hi All,

I have below scenario and need your inputs on how to solve this prob..

I have a variable with complex set analysis which will give the result as below. These are Comments_ID of a table Comment which are separated by ";".

vCommentsID= ( 173-Bogus_ID;1971-Bogus_ID;1972-Bogus_ID;1977-Bogus_ID;1978-Bogus_ID;1979-Bogus_ID)

Now, I need to compare above result set with the column Comments_ID from Comments and extract the remaining values like Comments_text, Comments_dt etc..

For this I used below expression where vcommentsID is the variable as descried above:

=if(SubStringCount('$(vCommentIds)',[comments_Id])>0,[comments_Id])

But the problem is, I'm getting all the desired result as well as few extra rows.

Ex: 173-Bogus_ID is resulting in 2 more ID's 73-Bogus_ID and 3-Bogus_ID from Comments table as these are also substring of the vCommentsId variable. But I don't want these 2 extra comment ID as they don't satisfy the criteria..

Can you please suggest if there is any other way to handle this situation?

Thanks a lot!!

[sunny_talwar · Accepted solution]

May be set this up like this:

vCommentsID = (|173-Bogus_ID|;|1971-Bogus_ID|;|1972-Bogus_ID|;|1977-Bogus_ID|;|1978-Bogus_ID|;|1979-Bogus_ID|)

and then this:

=if(SubStringCount('$(vCommentIds)', '|' & [comments_Id] & '|') > 0,[comments_Id])

[#3]

Thanks for your reply.. I will try to implement the same and see if it works..

[#4]

Thanks a lot sunny, it is working now.. Thanks again for ur time