Sun Aug 14, 2022 9:47 pm
Login Register Lost Password? Contact Us

Please Note: The HPCC Systems forums are moving to Stack Overflow. We invite you to post your questions on Stack Overflow utilizing the tag hpcc-ecl ( This legacy forum will be active and monitored during our transition to Stack Overflow but will become read only beginning September 1, 2022.


Comments and questions related to the Enterprise Control Language

Thu Feb 06, 2014 10:07 pm Change Time Zone

Please let me know what is equivalent in ECl which is something use in sql like '%S'
Thanks for yur help
Posts: 15
Joined: Sat Jan 11, 2014 2:39 am

Fri Feb 07, 2014 2:41 pm Change Time Zone


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).


Community Advisory Board Member
Community Advisory Board Member
Posts: 1619
Joined: Wed Oct 26, 2011 7:40 pm

Fri Feb 07, 2014 2:50 pm Change Time Zone

Thanks Richard
Posts: 15
Joined: Sat Jan 11, 2014 2:39 am

Return to ECL

Who is online

Users browsing this forum: No registered users and 1 guest