Remove part of a string

(0) Share

Report

Posted on by Phil_NPO

102

Hi,

I have got an email text that contains a disclaimer that starts with "This email"...

I want to remove this party of the email. I have tried it using First(Split( ... but I get an error.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

tom_riha 10,187 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!
Hello @Phil_NPO ,

you can use the replace(...) expression to replace it with '' (nothing)

replace(SourceString, StringToReplace, ReplacementSting) example: replace([EmailTextDynamicContent],'This email','')

Was this reply helpful? Yes No
Phil_NPO 102 on at

Like (0)

Report
Copy link

Link copied!

Hi Tom,

thanks for your reply. The problem is, that the text is not allways the same. The disclaimer contains a link with a result of a virus scan and this is allway different. So I only can search for the beginning of the disclaimer

Was this reply helpful? Yes No
Verified answer

Phil_NPO 102 on at

Like (0)

Report
Copy link

Link copied!
My solution is
first(split(triggerOutputs()?['body/body'],'--'))
This -- is just in front of the string, which should be deleted.

I tried this before I have asked here, but I had a error at the syntax.

Was this reply helpful? Yes No
tom_riha 10,187 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
What error did you get? If it's an email I'd convert it from 'HTML to Text' first (there's an action Html to text) and remove that string after it's converted to text. The final expression could look like this:

replace([EmailTextDynamicContent],first(split([EmailTextDynamicContent],'--')),'')

Was this reply helpful? Yes No
Phil_NPO 102 on at

Like (0)

Report
Copy link

Link copied!
No, my problem often is the syntax (german and english using " instead of ') or something like this.

It works fine with
first(split(triggerOutputs()?['body/body'],'--'))

Thanks for your help!

Was this reply helpful? Yes No