Search

[kumar2k14]

Please let me know what is equivalent in ECl which is something use in sql like '%S'
Thanks for yur help

[rtaylor]

kumar2k14,

In ECL itself we have an entire pattern matching technology built around the PARSE function and its supporting PATTERN, TOKEN, and RULE definitions, along with the REGEXFIND and REGEXREPLACE functions that both do pattern matching using Perl-standard regular expressions.

For simple patterns, like your "%S" example, we also have several standard library functions available: STD.STR.EndsWith(), STD.STR.StartsWith(), STD.STR.Contains(), STD.STR.Find(), and a number of others that you may find useful -- all these are documented in the Standard Library Reference (press F1 in the IDE and its the third "book" in the help file, along with the Language Reference and Programmer's Guide).

HTH,

Richard

[kumar2k14]

Thanks Richard