Answered

Need help removing extra space after text splitting

(0) Share

Report

Posted on by ZachB4

Very new to power automate (so be kind lol) and trying to just make a simple flow to help with some stuff at work. I want to split the text from a standardized email template, which will eventually be directed into an excel table. I am having an issue where there seems to be extra space added after the text I want parsed (code shows the raw input is " Spar\n\n"). But the input from the email is "Spar"

Please see below for the result and code:

Email Template:

rug: Spar

pic: xxxxxxx xxxxxxxxx

ight: xxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx

rce: KL

First Line: first(skip(split(first(split(body('Html_to_text'),'pic')),'rug: '),1))

Second Line: first(skip(split(first(split(body('Html_to_text'),'ight')),'pic: '),1))

Third line: first(skip(split(first(split(body('Html_to_text'),'rce')),'ight: '),1))

Fourth Line (which is not having the issue, so no picture): first(skip(split(body('Html_to_text'),'rce: '),1))

Looking for any help or suggestions on how to fix this! Thanks!

Categories:

General topics

All responses (5)

Answers (1)

Sort by

Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Use trim() to remove leading and trailing whitespace.
ZachB4 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Okay awesome! Question: where in the code should I apply the trim()? Sorry.. like I said. New to this lol
Verified answer

Jcook 7,783 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@ZachB4

Try:
First Line:
trim(first(skip(split(first(split(body('Html_to_text'),'pic')),'rug: '),1)))

Second Line:
trim(first(skip(split(first(split(body('Html_to_text'),'ight')),'pic: '),1)))

Third Line:
trim(first(skip(split(first(split(body('Html_to_text'),'rce')),'ight: '),1)))

Fourth Line:
trim(first(skip(split(body('Html_to_text'),'rce: '),1)))
ZachB4 7 on at

Like
a
(0)

Report
Copy link

Link copied!

@Jcook @Kaif_Siddique Thanks both! This worked!
Ximbalou 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Jcook ,

Wish you a excellent 2024.

Not sure if you can help me, but I am trying to do something similar to this, but I am struggling.

I want to extract the 2nd link, but I am getting the 1st one.

Using this formula from html to text:
trim(first(split(last(split(body('Html_to_text'),'Invoice PDF')),']')))