topic replace expression in tMap in Talend Studio

replace expression in tMap

CSmith1605109986 — Tue, 12 Jan 2021 16:01:02 GMT

Beginner alert!

I am having trouble replacing two items of text in the tMap expression editor.

I can replace the text: /Published/ with nothing using the following:

in.ReportPath.replace("/Published/","")

But I also want to replace more text in the same column.

For example:

/University/Pub/

How do I add the text: /University/Pub/ into: in.ReportPath.replace("/Published/","") so both /Published/ & /University/Pub/ gets replaced with nothing (removing the text from column)

Thanks

Chris

Re: replace expression in tMap

evansdar — Tue, 12 Jan 2021 19:43:41 GMT

use replaceAll to catch multiple conditions. Something like this

ReportPath.replaceAll("/Published/|/University/|/Pub/","")

Re: replace expression in tMap

CSmith1605109986 — Wed, 13 Jan 2021 08:17:19 GMT

Thanks, that works great.