topic Re: Talend Studio - Data Quality - regular expression error within a built-in sql script in Data Quality

Talend Studio - Data Quality - regular expression error within a built-in sql script

Anonymous — Mon, 19 Feb 2018 11:20:07 GMT

The following sql script works correctly in MySQL workbench however when I copy this sql script into an tmysqlinput built-in component in a Talend job the script is changed by Talend when I run it.

The original script is:

SELECT
name_sur
,regexp_substr (name_sur,'\\S*Admin+') as new_field2

FROM debtrecovery.bailiff
where name_sur like '%Admin%'

whereas the amended version is:

SELECT
name_sur
,regexp_substr (name_sur,'S*Admin+') as new_field2

FROM debtrecovery.bailiff
where name_sur like '%Admin%'

Talend is removing the two backslashes in front of the capital S i.e.

original regex: '\\S*Admin+'

amended regex: 'S*Admin+'

This is amending my final output, giving me incorrect data.

Is this a known bug or is there any specific work around I can use.

Thanks

Kevin

Re: Talend Studio - Data Quality - regular expression error within a built-in sql script

Anonymous — Tue, 27 Feb 2018 02:41:07 GMT

Hello,

Could you please clarify in which Talend version/edition you are?

Best regards

Sabrina

Re: Talend Studio - Data Quality - regular expression error within a built-in sql script

Anonymous — Wed, 28 Feb 2018 10:22:55 GMT

Hi Sabrina,

Thanks for looking into this issue for me. The version that I am using is Talend 6.4.1

Regards,

Kevin

Re: Talend Studio - Data Quality - regular expression error within a built-in sql script

Anonymous — Fri, 09 Mar 2018 08:03:56 GMT

Hello,

Are you trying to write 4 backslashes in your sql script to see if your final output correct?

Best regards

Sabrina

Re: Talend Studio - Data Quality - regular expression error within a built-in sql script

Anonymous — Tue, 20 Mar 2018 16:43:32 GMT

Hi Sabrina,

It was an escape char issue so thanks for your suggestion. This works fine now

Regards,

Kevin