tReplaceList queries

[noobTalendDev]

I am taking in an 'xls' file and there is one column on which i want to change the data so it will be easier to use.

input -> expected output

24 hours -> 1

5 days -> 5

1 month -> 30

1 year -> 365

so I am given the string and want to change it to the numerical interger.

I was thinking of using tReplaceList, 

but wanted to see what other options were out there to handle this. 

Full workflow:

Taking in an xls file and reading the values and adding up all of these integers based on the user to give you the full picture. So after this change i will be transforming the data still.

[Anonymous]

Hi

I think tReplaceList is the best component to replace the values , another way is to use tJavaRow to replace the values with Java code after reading the data from xls file.

Regards

Shong

[noobTalendDev]

for some reason tReplaceList doesn't do anything to my output, I used tJavaRow instead. Am I using tReplaceList wrong?

[Anonymous]

Would you like to share some screenshots to what you are doing with tReplacdList, we can check it.

Regards

Shong