Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Power Automate Desktop
Answered

Replace - can see it - can't catch it :(

(1) ShareShare
ReportReport
Posted on by 14
Hello World

Please see the screendump and attached file. 
What is the character to the left in all lines ?
It is NOT whitespace.
I can see it but when I try to copy it and use Replace action it doesn't work.

Any advice ?

Categories:
  • Verified answer
    eetuRobo Profile Picture
    3,587 Super User 2025 Season 1 on at
    Replace - can see it - can't catch it :(
    I think they are white space. I used replace to replace all spaces with X and this is the result:


    Remember that to replace whitespace you need to use %' '% 


    It could be that you used Trim text and thought it has to be something else since it doesn't trim the spaces in the second row. Thats because it trims only whitespaces from the begining and the end of the whole text content.


    So you need to either loop each row individually or use regex to match white space that is at the end or at the begining of the line

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492