Page 1 of 1
Like function
Posted: Tue Jun 28, 2005 5:37 am
by 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 ?
Posted: Tue Jun 28, 2005 5:44 am
by 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,
Posted: Tue Jun 28, 2005 7:58 am
by 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
(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
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.
Posted: Tue Jun 28, 2005 9:00 pm
by matthiaschoy
It works... Thanks guys....
