Like function

[matthiaschoy]

Hi,

I am filtering data from source file to source file using a transformer. I have a condition which is getting all the tariff which contains USSD. The SQL is [if tariff like '%USSD%' then]. Which function should I use in DS 7.5 to perform that ?

[roy]

Hi And welcome aboard ,
you can use Basic Match operator for one, or any other function that can veify the existance of a string in a bigger string like Count()/Locate(),Index() and such.

IHTH,

[ray.wurlod]

Match is the best, as Roy suggested. However it uses idiosyncratic syntax, for example for its wildcard. One syntax that will do the job you seek is the expression

Code: Select all

InLink.Tariff Match "...USSD..." 

(the three dots represent a wildcard). A variant in which "0X" is the wildcard is

Code: Select all

InLink.Tariff Matches "0X'USSD'0X"

(Matches is a synonym for Match).

The expression

Code: Select all

Index(InLink.Tariff, "USSD", 1) 

finds the first occurrence of "USSD" in Tariff, and may be more efficient. It returns 0 if not found, or the (positive) character position of where it was found.

[matthiaschoy]

It works... Thanks guys....