cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Responsive Resident
Responsive Resident

Replace/Substitute a New Line

Hello,

 

I have a situation where i am parsing an email, i grab my necessary data point which results like this:

566

 

a new line is under the data point i grabbed, how can i remove this newline under the captured data.

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Replace/Substitute a New Line

yes @mmattar  you can you need to use the function replace, but first I reccomend you to transform that output into Uri component se my example

 

UriCOmponent.PNG

 

see then %0A represents a line break and I just replace it with nothing



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

Re: Replace/Substitute a New Line

yes @mmattar  you can you need to use the function replace, but first I reccomend you to transform that output into Uri component se my example

 

UriCOmponent.PNG

 

see then %0A represents a line break and I just replace it with nothing



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

Highlighted
Responsive Resident
Responsive Resident

Re: Replace/Substitute a New Line

I transformed the out to a Uri component and got this: 566%0D. But the replace function just gave me back the same result of: 566%0D. 

this is the forumla i used to replace,   replace(outputs('Compose_3'),'%20%0A%0A','')

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (3,616)