Skip to main content
Community site session details

Community site session details

Session Id : zcBjx+zoMXAMe6NJ0+6nZs
Power Automate - Building Flows
Answered

How to Remove tab spacing...

Like (1) ShareShare
ReportReport
Posted on 16 Apr 2021 01:03:26 by 124

Hi all,

 

So I'm stuck. I've got a array variable that contains a list of special characters that I'll apply to each and remove from a string by using the replace() expression and looping through the array. I've now come across a speed bump... I noticed some of the strings contain tab spacing. So not just normal spacing but tab spacing.

 

I tried adding into my array things like '\t' or just entering tab to replace it with null but it's not working. The tab spacing is still there. Any way of replacing tab spacing?

 

The annoying tab spacing. You can't see it in the string but it's there in the raw output.The annoying tab spacing. You can't see it in the string but it's there in the raw output.

  • Verified answer
    v-litu-msft Profile Picture
    on 16 Apr 2021 at 06:36:08
    Re: How to Remove tab spacing...

    Hi @Mick282,

     

    Cause Unicode of "tab" is 9, uniform resource identifier is %09, so you could use uriComponent function to encode the string, then use replace function to remove these "%09" in the encoded string, then use decodeUriComponent function decode it, then it will return the string that has no tab:

    decodeUriComponent(replace(uriComponent(outputs('Get_file_content_using_path')?['body']),'%09',''))

    Screenshot 2021-04-16 143518.jpg

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Achavan Profile Picture
    286 on 16 Apr 2021 at 06:30:33
    Re: How to Remove tab spacing...

    Hi @Mick282 ,

    try this

    Achavan_0-1618554472938.png

    output -

    Achavan_1-1618554509439.png

     

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Loading complete