pattern case sensitive

Highlighted
One Star

pattern case sensitive

hi,

I only recognize lowercase letters ... how can I fix it? I can suggest a pattern for MySql that works correctly in the program ... These examples do not work'[[: lower:]]' '[a-z]'...Thank you in advance Yours sincerely
Employee

Re: pattern case sensitive

Hi safari,

which version of Talend Open Profiler are you using?
In the "Regular expression matching" indicator, you should see
SELECT COUNT(CASE WHEN <%=__COLUMN_NAMES__%> REGEXP BINARY <%=__PATTERN_EXPR__%> THEN 1 END), COUNT(*) FROM <%=__TABLE_NAME__%> <%=__WHERE_CLAUSE__%>

The BINARY keyword implies that the generated query is case sensitive.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read