web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Data Exchange Definiti...

Small and medium business | Business Central, N...

Suggested Answer

Data Exchange Definition - Transformation Rule Not Working

(1) Share

Report

Report

Posted on by WV-27041051-0

Hi all,
We have a bank statement CSV file in this format:

We're trying to use Transformation Rules in the Data Exchange Definition to convert the /--/ string to nothing (blanks).

None of the existing Transformation Rules are removing the /--/ characters.

We've tried:

Remove Non-Alphanumeric characters
Replace
Regular Expression - Replace

You still get this error message, when you attempt to import the CSV file:
The CSV Bank file import is not applying the Transformation Rule and removing the /--/ string:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 100,212 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, this may require some simple customization if the standard can't do it.

Hopefully the information below will give you some tips.

https://yzhums.com/7341/#toc2

Thanks.

ZHU

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,012 Super User 2026 Season 1

#2

YUN ZHU 986 Super User 2026 Season 1

#3

Teagen Boll 659 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans