replace expression in tMap

[CSmith1605109986]

Hi

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

[evansdar · Accepted solution]

use replaceAll to catch multiple conditions. Something like this

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

[CSmith1605109986]

Thanks, that works great.