Unanswered

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)

Suggested answer

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

/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
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
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

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