topic Re: Using treplace to replace a number in a field in Talend Studio

Using treplace to replace a number in a field

_AnonymousUser — Sat, 16 Nov 2024 12:57:50 GMT

Hi,
I am having issues using treplace to replace a number in a column. The database column is a tinyint, and I want to replace the number 3 with a 4. I can get it to work perfectly on a varchar field, it appears to be the tinyint field that causes the issue. This is the error message that I get:
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
The method replaceAllStrictly(String, String, String, boolean, boolean) in the type StringUtils is not applicable for the arguments (Short, String, String, boolean, boolean)

I see that the arguments do not match, but I am not sure what to change. I have attached an image of the component settings. Thanks for any help.

Re: Using treplace to replace a number in a field

Anonymous — Fri, 22 Apr 2011 03:00:46 GMT

Hi
It is a compilation error, the method replaceAllStrictly requires a string type, but the data type of input column is short. You need convert short to string first. Please see my screenshots.
Best regards
Shong

Re: Using treplace to replace a number in a field

Abakostar — Sun, 30 Oct 2022 08:22:18 GMT

Hello. Can I see your screenshots. I have the same problem.

Re: Using treplace to replace a number in a field

Abakostar — Sun, 30 Oct 2022 09:24:05 GMT

I want to replace the field of number with another by using treplace component. Thanks for any help