Putting a space in a post code if one hasn't been entered using Power Automate

[Anonymous]

Afternoon

I have a list with a postcode field which over time has had users enter the postcodes with no spaces.

So the postcode have either 3 or 4 characters before where the space should be (e.g. TA1 or TA24) then all postcodes have 3 characters after the space. I need some kind of  condition to determine where to put the space based on the total number of characters in the string (if 6 characters then space would go after 3rd char vs if 7 characters, space would go after 4th character.

Any ideas the best way to achieve this? Thanks in advance.

[skay]

Hi all, 

I have a similar scenario where I need to add the space to the postcode, however the original requirements only cater to 6 or 7 character postcodes, but there are also 5 character postcodes, as an example S1 3HU. 

This works great for 6 or 7 character postcodes but fails where a 5 character postcode is used:

if(equals(length(outputs('Compose')), 6), concat(substring(outputs('Compose'), 0, 3), ' ', substring(outputs('Compose'), 3, 3)), concat(substring(outputs('Compose'), 0, 4), ' ', substring(outputs('Compose'), 4, 3)))

Any help would be massively appreciated! 

[abm]

Hi @skay 

Could you post a new thread for this please? Also post some sample data how you want to format? I will have look.

Thanks