topic Re: treplacelist issue in Talend Studio

treplacelist issue

JSey — Thu, 01 Oct 2020 15:42:43 GMT

I have a job that is using a treplacelist component. In the replacelist file, it goes something like this

Lost time, WS1

Lost time (but xxx), WS2

The problem is for rows where the value is Lost time (but xxx), it is all replaced with WS1. How can I resolve this? I have already tried using text enclose in the schema for the file delimited. Thank you for your help.

Re: treplacelist issue

pakapi_ — Thu, 01 Oct 2020 17:25:51 GMT

Hi Jsey,

I've never used this component before, but I will try to help. Can you paste a job example, to better understand what you want to do ? Espacially some input samples.

Re: treplacelist issue

JSey — Thu, 01 Oct 2020 17:58:48 GMT

Sure, here you go, thanks for your help.

So the treplacelist reads a csv with a column for original match values, and a column for the replace values. This is what the work status csv looks like in part:

The issue is it is only matching on lost time - allowed and replacing with ws1. When the values are "lost time - allowed(but not payable)", it will return "ws1 (but not payable)". It is not matching on "lost time - allow (but not payable)" and will not return "ws2". In the treplace component, I don't see any option to match the whole word.

Re: treplacelist issue

pakapi_ — Thu, 01 Oct 2020 19:15:53 GMT

Hi JSey,

thanks for your example. It looks like a bug in this component. Maybe try to use tMap insted:

Re: treplacelist issue

JSey — Fri, 02 Oct 2020 00:36:49 GMT

Doesn't look like a bug to me, it is matching on a subset of the words. I could also have used treplace, but I wanted to use a replacelist so that the list can be maintained externally. Are there any other workarounds?

Re: treplacelist issue

pakapi_ — Fri, 02 Oct 2020 06:33:54 GMT

Hi JSey,

true, maybe it's not a bug, it's a feature 😉

I don't udderstand - what is the problem to externally maintain your list with tMap approach ? It's just a csv file. Could you please explain ?

Re: treplacelist issue

JSey — Mon, 05 Oct 2020 19:20:43 GMT

Still hoping there is a work around or a fix. Any option from anyone else? What else can I use beside treplacelist or treplace?

Re: treplacelist issue

JSey — Wed, 07 Oct 2020 14:17:35 GMT

This is a bug from 2014 and is still unresolved. Is there any workaround? This bug makes treplacelist essentially unusable.

https://jira.talendforge.org/browse/TDI-30413

Re: treplacelist issue

pakapi_ — Wed, 07 Oct 2020 14:55:28 GMT

Why not tMap ?

Re: treplacelist issue

pakapi_ — Sun, 11 Oct 2020 10:03:24 GMT

Still don't know what is the problem with tMap? Can you please explain ?