topic Re: [resolved] tReplace and wildcard? in Talend Studio

[resolved] tReplace and wildcard?

profuse — Fri, 08 Jul 2016 18:39:25 GMT

Hi,
In the tReplace search column can you use a wildcard? If so, what is the wildcard value?
Thanks

Re: [resolved] tReplace and wildcard?

Anonymous — Mon, 11 Jul 2016 05:01:33 GMT

Hi,
You can use wildcard in tReplace component, such as:$, *,. Please take a look at component reference :TalendHelpCenter:tReplace with related scenario.
What's your job requirement? Could you please set an example for us?
Best regards
Sabrina

Re: [resolved] tReplace and wildcard?

profuse — Mon, 11 Jul 2016 20:22:47 GMT

Hi Xdshi,
I have a column that contains Job Titles like: Area Sales Manager, Product Sales or Director of Sales. This is what I would like to do, if this column contains the word sales "sales", I want to replace the entire value such as (Area Sales Manager) to just the word "sales". Can this be done using the tReplace?
Thanks

Re: [resolved] tReplace and wildcard?

Anonymous — Tue, 12 Jul 2016 09:29:30 GMT

Hi,
If we understand your requirement very well, you can use tMap to achieve your goal.
Here is ternary if-else operator in tMap.
The expression should be:condition?(value if true): (value if false)
Please take a look at my screenshots for details

Best regards
Sabrina

Re: [resolved] tReplace and wildcard?

profuse — Tue, 12 Jul 2016 16:27:20 GMT

Hi Xdshi,
That works BUT how would I add more than one if-else to the same tMap?
row1.JobTitle.contains("Sales")?"Sales":row1.JobTitle
row1.JobTitle.contains(" Surgeon")?" Physician":row1.JobTitle
Thanks