cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kris_T
Frequent Visitor

Removing CR from text string

Hello,

 

I am reading a text string in a variable, but I need to get rid of any CR (line break) characters in this variable so that I end up with one very long text value.

Any tips or advice on how to do this would be appreciated.

Thanks,

 

Kris_Belgium

1 ACCEPTED SOLUTION

Accepted Solutions
eric-cheng
Solution Sage
Solution Sage

Hi @kris_T ,

 

Check out this post with a few options and see if it helps

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

View solution in original post

2 REPLIES 2
eric-cheng
Solution Sage
Solution Sage

Hi @kris_T ,

 

Check out this post with a few options and see if it helps

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Nived_Nambiar
Resolver I
Resolver I

Hi @kris_T 

 

Try this way as below

Nived_Nambiar_0-1629807450400.png

 

 

First I intialized a variable [for demo] which contains values as below

Nived_Nambiar_5-1629807687210.png

 

 

Now using formulas

 

I did like this below

formula used in compose action :  

join(split(variables('Data'),decodeUriComponent('%0A')),'')
 
 
This way i am able to replace the new lines an join them together:
Nived_Nambiar_6-1629807724366.png

 

 
 
Regards,
Nived N

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (1,339)