topic Replace function error in T oracle component in Talend Studio

Replace function error in T oracle component

Divya3 — Sat, 16 Nov 2024 01:48:30 GMT

Hi,

I'm trying to run the select query with replace,substr function in T Oracle component. The job is throwing error. can you help?

"SELECT substr(ATLD_ID,1,8) as XXX

from YYYY"

Anonymous — Mon, 27 Jul 2020 07:14:14 GMT

Hello,

Could you please give us more information about the error message you're getting? In this way, we could address your issue in a quick way.

Best regards

Sabrina

Divya3 — Mon, 27 Jul 2020 07:28:21 GMT

Hi,

I was actually trying to use this expression in Talend,

replace(REGEXP_SUBSTR(ATLT.atlt_to_name,'[^,]+',1,1),'"','') as Member_Firstname

The function works well in Oracle query but not in Talend. Can you please help?