---
id: post/thatnavguy-com/https-thatnavguy-com-blog-2025-bc-friday-tips-27-replace-blank-values-using-transformation-rules--bc0a2627b6
type: post
title: "BC Friday Tips #27 Replace Blank Values using Transformation Rules"
summary: Transformation Rules can replace blank values in Business Central using regular expressions. Set the transformation type to "Replace" and use the pattern ^$ to match empty strings without requiring any development.
tier: community
language: en
tags:
  - transformation rules
  - data import
  - regular expressions
  - blank values
system: integration
review:
  state: reviewed
  by: opus
  at: "2026-10-08T02:01:26.325Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-post: 1
  input_hash: 82c967a05a1f7de032e1ace17fdbe47e094d8b4fa4f3b84edb944b9c0ec70aaf
evidence:
  - kind: blog
    url: https://thatnavguy.com/blog/2025/bc-friday-tips-27-replace-blank-values-using-transformation-rules/
    title: "BC Friday Tips #27 Replace Blank Values using Transformation Rules"
    date: "2025-04-11"
    commit: null
    t: null
    quote: null
  - kind: blog
    url: https://thatnavguy.com/blog/2025/bc-friday-tips-27-replace-blank-values-using-transformation-rules/
    title: "BC Friday Tips #27 Replace Blank Values using Transformation Rules"
    date: "2025-04-11"
    commit: null
    t: null
    quote: Set Transformation Type to Replace by using Regular Expressions
  - kind: blog
    url: https://thatnavguy.com/blog/2025/bc-friday-tips-27-replace-blank-values-using-transformation-rules/
    title: "BC Friday Tips #27 Replace Blank Values using Transformation Rules"
    date: "2025-04-11"
    commit: null
    t: null
    quote: Together, ^$ identifies an empty string
  - kind: blog
    url: https://thatnavguy.com/blog/2025/bc-friday-tips-27-replace-blank-values-using-transformation-rules/
    title: "BC Friday Tips #27 Replace Blank Values using Transformation Rules"
    date: "2025-04-11"
    commit: null
    t: null
    quote: Work out of the box. No development needed.
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
post_id: https://thatnavguy.com/blog/2025/bc-friday-tips-27-replace-blank-values-using-transformation-rules/
source_id: thatnavguy-com
source_name: That NAV Guy
url: https://thatnavguy.com/blog/2025/bc-friday-tips-27-replace-blank-values-using-transformation-rules/
published_at: "2025-04-11T00:00:00.000Z"
author: Teddy Herryanto
full_text: false
words: 88
quotes:
  - text: Set Transformation Type to Replace by using Regular Expressions
    why_it_matters: This is the first step to configure blank value replacement in Business Central
  - text: Together, ^$ identifies an empty string
    why_it_matters: Understanding this regex pattern is key to implementing the blank value replacement
  - text: Work out of the box. No development needed.
    why_it_matters: Shows this feature requires no AL code or custom development, making it accessible to all users
code_objects_mentioned: []
systems:
  - integration
versions_mentioned: []
preview:
  embeddable: true
  frame_url: null
  image: https://thatnavguy.com/og/2025/bc-friday-tips-27-replace-blank-values-using-transformation-rules.png
  image_alt: null
  image_w: null
  image_h: null
  site_name: null
  favicon: https://thatnavguy.com/favicon.svg
  probed_at: "2026-10-07T11:51:44.627Z"
---

# BC Friday Tips #27 Replace Blank Values using Transformation Rules

[Read the post](https://thatnavguy.com/blog/2025/bc-friday-tips-27-replace-blank-values-using-transformation-rules/) · That NAV Guy (Teddy Herryanto, MVP) · 2025-04-11 · 88 words · tier community · reviewed (checked by Opus)

> Transformation Rules can replace blank values in Business Central using regular expressions. Set the transformation type to "Replace" and use the pattern ^$ to match empty strings without requiring any development.

## Key points

- Use regular expressions with Transformation Rules to identify and replace empty values
- The pattern ^$ matches start and end of string to identify blank entries
- No custom development is needed; this works out of the box

## Quotes

- "Set Transformation Type to Replace by using Regular Expressions" (This is the first step to configure blank value replacement in Business Central)
- "Together, ^$ identifies an empty string" (Understanding this regex pattern is key to implementing the blank value replacement)
- "Work out of the box. No development needed." (Shows this feature requires no AL code or custom development, making it accessible to all users)

## Context

- Features: Transformation Rules, Regular Expressions

Source: That NAV Guy, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.