Xlate IF Contains

Johnny,

IF ct =12

would check the contents of the Source and if it contains ’12’ anywhere the result would be true.

You can alos use the or connectors (or the and connectors) and I think parentheses as well to relate and order the conditions.

If you need more detail, email me and I will work with you.

Johnny,

What exactly do you want to check for? The actual charactrs “?? ?? ?? ??” or something else?

Johnny,

OK so you want to see if some piece of data (field, temp variable, etc.) contains one of many sets of characters.

Such as ‘Does @myvar contain 01 or 02 or 03’.

Your IF would look like this:

IF @myvar ct =01 || @myvar ct =02 || @myvar ct =03

The ‘||’ is obtained by selecting ‘LOGICAL’ from the ‘Category’ pull-down in the IF Action Properties.

Johnny,

Another way to do this (mostly with more items) is to populate a Lookup Table with the velues and each of the values returns something like a ‘Y’ with the default being ‘N’.

Then do a Table with the data item foloowed by and IF eq =Y and if that is true your data value was one of the table items – if not you did not match.

Simpler to change a Lookup table and purge caches than to change an Xlate and a long list of elements can run out of the display pane in the properties.