Error running query in Talend

[Anonymous]

I'm having a problem running an update query in Talend.  I get the error that is attached.  I can run the following query just fine in Snowflake without an issue.  I works ok in Snowflake, but not in Talend.  I have used other update statements in Talend with snowflake.  

update "EMS"."PUBLIC"."PGA_CLEAN_SUBSCRIBED"
SET rydercup_2020 =
replace (rydercup_2020,'"','')
where email_address <> ''

[Anonymous]

Hi,

     It seems you have created two posts for same query. Please refrain from creating multiple posts for same query as it will dilute the focus of Talend community members.

     Since your other thread is more active and lot of solutions are already there, could you please close the current post?

https://community.talend.com/t5/Design-and-Development/Error-running-query-in-Talend/m-p/154819#M946...

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

I tried the solution.  It only works partly.  It does remove the double quotes at the beginning of the field, but it does not remove the double quotes at the end of the field.  

[Anonymous]

Hi,

Could you please share a sample record in code section, the Talend code you are using to do the task the current output?

Please share the screen shots of the conversion component.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

I just added the project

EMS_PGA_Clean_Subscribers.zip

[Anonymous]

Here's a screen print.  

Talend code example.PNG

[Anonymous]

Here's a partial input file.  

cleaned_members_export_52e91289a2-version2.txt

[Anonymous]

Hi,

    I could see that you have not given escape character to double quote.

Could you please try like below and let us know the results?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

I'm confused as that is a copy of the query that I was sent earlier.  Now you are saying that it shouldn't work?

[Anonymous]

In your earlier query, you have not marked the double quotes as escape character. So your query must be breaking mid way.

Did you check the results after including the escape character?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂