It’s #BCFridayTips for #msdyn365bc consultants.
💡Did you know there’s a simple way to replace blank values using Transformation Rules?
Here’s how:
➡️ Set Transformation Type to Replace by using Regular Expressions
➡️ Set Find Value to ^$
How it works:
➡️ ^ marks the start of a string.
➡️ $ marks the end of a string.
➡️ Together, ^$ identifies an empty string.
Why use it?
✅ Work out of the box. No development needed.
Share to help others ♻️ and follow Teddy Herryanto for more tips! 🚀