Using treplace to replace a number in a field

One Star

Using treplace to replace a number in a field

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.
Community Manager

Re: Using treplace to replace a number in a field

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
----------------------------------------------------------
Talend | Data Agility for Modern Business