Remove spaces from compose function (parse email)

(0) Share

Report

Posted on by shelleyb

193

Hello,

Could anyone assist, I found this great article which had the following expression, to parse email text and its worked a treat on the majority of the email body.

trim(Split(Split(body('Html_to_text'), 'ENGINEER SIGN OFF SHEET')[1], 'Has')[0])

Result it generates the following output

LINE 1

space
LINE 2

space
LINE 3

space
LINE 4

How do I get it to remove the space from the output?

Many thanks in advance 🙂

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @shelleyb

Are you expecting LINE 1LINE 2LINE 3LINE 4

OR

LINE 1

LINE 2

LINE 3

LINE 4

Please confirm?

Thanks

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!
Declare variable called seperator and press enter 2 times in the value.

Then use split function and split using this variable... Refer example below

split(variables('test'), variables('seperator'))

Was this reply helpful? Yes No
shelleyb 193 on at

Like (1)

Report
Copy link

Link copied!

LINE 1LINE 2LINE 3LINE 4

would be good 🙂

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @shelleyb

Thanks for your reply. Please see below.

Above expression is as follows:

replace(outputs('Compose'),outputs('Compose_2'),'')

My Test Result

Thanks

Was this reply helpful? Yes No
Verified answer

shelleyb 193 on at

Like (0)

Report
Copy link

Link copied!

Perfect! Thank you 🙂

Was this reply helpful? Yes No