BizTalk Mapper Extensions UtilityPack: Replace Multiple Spaces with a Single Space Functoid for BizTalk Server 2020

  • Sandro Pereira
  • Mar 5, 2025
  • 2 min read

I’m adding some new BizTalk Server Functoids that I have often used in my new BizTalk Server projects over the last few years. Recently, I updated this package with a new functoid, Remove Trailing Zeros Functoid, and today, I’m going to update it with another one, Replace Multiple Spaces with a Single Space Functoid, which is now part of the BizTalk Mapper Extensions UtilityPack project available for BizTalk Server 2020.

Replace Multiple Spaces with a Single Space Functoid

This functoid allows you to replace multiple spaces inside the string with a single space.

  • This functoid requires one input parameter:
    • String to replace multiple spaces with a single space;
    • Examples:
      • Input:"Hello World BizTalk!" – The string ends with .00, so the function returns "Hello World BizTalk!".
Single Space Functoid

Sometimes, people question why I release new BizTalk Server components if BizTalk Server is at the end of its life. My typical answer is: only fools believe that!

📝 One-Minute Brief

The Replace Multiple Spaces functoid from UtilityPack helps normalize string values in BizTalk Server maps by converting multiple spaces into a single space. This post explains how the functoid works, when to use it, and how it improves data quality in mappings.

BizTalk Mapper Extensions Utility Pack

BizTalk Mapper Extensions Utility Pack is a set of libraries with several useful functoids to include in a map, extending BizTalk Mapper capabilities.

BizTalk Mapper Extensions UtilityPack for BizTalk Server 2020

Where can I download it?

You can download the complete Azure Function source code here:

I hope you find this helpful! If you liked the content or found it useful and want to help me write more, you can buy (or help buy) my son a Star Wars Lego set! 

Buy a me coffee
Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

Leave a Reply

Your email address will not be published. Required fields are marked *

The Ultimate Cloud
Management Platform for Azure

Supercharge your Azure Cost Saving

Learn More
Turbo360 Widget

Back to Top