Unanswered

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

I have the same question (0)

All responses (5)

Answers (1)

Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report

Use trim() to remove leading and trailing whitespace.

Was this reply helpful? Yes No
ZachB4 7 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Jcook 7,781 Most Valuable Professional on at

Like (1)

Report
@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)))

Was this reply helpful? Yes No
ZachB4 7 on at

Like (0)

Report

@Jcook @Kaif_Siddique Thanks both! This worked!

Was this reply helpful? Yes No
Ximbalou 6 on at

Like (0)

Report

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')),']')))

Was this reply helpful? Yes No