topic Re: treplacelist missing letter after replacement in Talend Studio

treplacelist missing letter after replacement

FelixEva — Wed, 18 May 2022 09:26:52 GMT

Hi there! I Hope u can help me as i don´t know what else i should do.

Problem is, that my data is running through "treplacelist" with a "tfileinput" external csv for matching and the input data is coming from the database. When the data is going through the treplacelist component the export csv always misses the letter "m".

Example:

input data "TrialMoodle" --> mapping with treplacelist "Moodle" (should be the output) --> output "oodle" (so the "m" is gone although the csv for matching contains the "m")

Hope u understand my problem. Thanks in advance!

Regards Felix

Re: treplacelist missing letter after replacement

Anonymous — Thu, 19 May 2022 03:00:29 GMT

Hello,

How did you set your "lookup search column" and "lookup replacement column"

Would you mind posting your tReplaceList component setting screenshot on community? Which will be helpful for us to address your issue.

Please mask your sensitive data as well.

Best regards

Sabrina

Re: treplacelist missing letter after replacement

FelixEva — Mon, 23 May 2022 14:52:36 GMT

Thanks for your answer. You mean with "posting on community" this thread, or where should I idealy post it?

Attached a screenshot from the excel tfileinput data and a screenshot from the tReplaceList component.

Re: treplacelist missing letter after replacement

FelixEva — Wed, 01 Jun 2022 09:58:17 GMT

Did u find out anything?

Re: treplacelist missing letter after replacement

FelixEva — Tue, 14 Jun 2022 08:56:26 GMT

Re: treplacelist missing letter after replacement

Anonymous — Tue, 14 Jun 2022 09:23:10 GMT

Hello,

Sorry for delay. I haven't found any issue from your setting and I'm discussing this issue with my team to see if there is something missing.

Best regards

Sabrina