Removing a "\r" character from a string

(0) Share

Report

Posted on by Zurias

Howdy all,

Currently my flow has a string that has a "\r" character in it and I cannot figure out how to remove. There's two compose actions where I could remove it,

In the first one the string is produced by: first(input array) and the string output looks like this:

"84739,99294,35243.04,49535,0.393,1.481\r"
 
In the second one that string is converted to an array via the split() function and combined with another array into a single long string that looks like:
"84739,99294,35243.04,49535,0.393,1.481\rTE545063,Company,Employee,650,...." The string continues bit the \r is show there.
 
That 1.481 number will change as it's a varied test result so I can't reference that directly.
 
It can be changed in either compose statement, I just need the \r to not be there.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Pstork1 69,169 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

/r is what you get for an escaped carriage return. Try doing a replace() with Char(13) as the target and replace it with a space.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Garima_PowerPlatform 170 on at

Like (1)

Report
Copy link

Link copied!
Hi
Step 1: Removing from a string

Compose Action:
replace(first(outputs('Your_Input_Array')), '\r', '')

Step 2: After Splitting and Combining

Compose Action:
replace(outputs('SplitArrayCombined'), '\r', '')

Replace outputs('Your_Input_Array') and outputs('SplitArrayCombined') with the appropriate flow outputs.

Notes:

The replace() function in Power Automate replaces all instances of the specified substring.

Ensure the context matches where the string with the \r appears and apply the replacement.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.

Was this reply helpful? Yes No
Suggested answer

Garima_PowerPlatform 170 on at

Like (1)

Report
Copy link

Link copied!
Hi

Step 1: Removing from a string

Compose Action:
replace(first(outputs('Your_Input_Array')), '\r', '')

Step 2: After Splitting and Combining

Compose Action:
replace(outputs('SplitArrayCombined'), '\r', '')

Replace outputs('Your_Input_Array') and outputs('SplitArrayCombined') with the appropriate flow outputs.

Notes:

The replace() function in Power Automate replaces all instances of the specified substring.

Ensure the context matches where the string with the \r appears and apply the replacement.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.

Was this reply helpful? Yes No
BS-16011335-0 2 on at

Like (0)

Report
Copy link

Link copied!

I was able to get it to work using this replace:

replace(outputs('Prior_Step_Name'),decodeUriComponent('%0D') ,'')

For my specific example, I was trying to remove blank lines that looked like '\r\n\r\n' (want to replace double line feeds with a single), and for that I used this:

replace(outputs('Prior_Step_Name'),decodeUriComponent('%0D%0A%0D%0A') ,decodeUriComponent('%0D%0A'))

Was this reply helpful? Yes No