You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2015-06-17 09:44:58

Alex020181
Member
10 posts

Alex020181 said:

Transform or Convert a string to resolve an operation

Hi
I have a problem for you. I have a string like
- "1+123" and i would like to obtain the decimal result 1 (*1000) + 123 = 1123
- "1+1234" and i would like to obtain the decimal result 1 (*1000) + 1234 = 2234
- "12+123" and i would like to obtain the decimal result 12 (*1000) + 123 = 12123
- "12+1234" and i would like to obtain the decimal result 12 (*1000) + 1234 = 13234
- "1-123" and i would like to obtain the decimal result 1 (*1000) - 123 = 877
- "1-1234" and i would like to obtain the decimal result 1 (*1000) - 1234 = -234
- "12-123" and i would like to obtain the decimal result 12 (*1000) - 123 = 11877
- "12-1234" and i would like to obtain the decimal result 12 (*1000) - 1234 = 10766
The schema; All numbers in the left are * 1000 and next make a sum or a difference with all numbers in the right.
Is it possible ? Does a component do that ?
Thanks a lot.

Offline

#2 2015-06-26 08:42:59

xdshi
Talend Team


xdshi said:

Re: Transform or Convert a string to resolve an operation

Hi Alex020181,


Have you tried to use tMap to do your operation?
Best regards
Sabrina


What we can do is to make sure that Talend will be your best choice!

Offline

#3 2015-07-03 15:34:45

Alex020181
Member
10 posts

Alex020181 said:

Re: Transform or Convert a string to resolve an operation

Hi xdshi

Look at talendforge.org/forum/viewtopic.php?id=44589

I had not read again your response. Sorry.

Last edited by Alex020181 (2015-07-03 15:35:18)

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy