12 min read
The Hidden Challenge of Delimited Files: When the Delimiter Is Also Part of the Data (Part 4) – T...
Sandro Pereira
Aug 27, 2026
In the previous articles of this series, I explained why flat file parsers in BizTalk Server and Logic Apps struggle when business data contains the same
15 min read
The Hidden Challenge of Delimited Files: When the Delimiter Is Also Part of the Data (Part 3) – T...
Sandro Pereira
Aug 26, 2026
In the previous articles, we explored a common flat file parsing challenge: business data contains the same character used as the field delimiter When this
10 min read
The Hidden Challenge of Delimited Files: When the Delimiter Is Also Part of the Data (Part 2) ...
Sandro Pereira
Aug 25, 2026
In this second blog post, I will explain the traditional way developers create a flat-file schema and present the main issue that occurs in delimited files
5 min read
The Hidden Challenge of Delimited Files: When the Delimiter Is Also Part of the Data (Part 1)
Sandro Pereira
Aug 24, 2026
Delimited files such as CSV, comma-separated (,), pipe-separated (|), semicolon-separated (;), or tab-delimited files remain one of the most common
6 min read
Logic Apps: How to process CSV files
Sandro Pereira
Jul 28, 2023
One of the most ancient and common standards for message representation is using text files (Flat Files), such as CSV (Comma Separated Values) or TXT, many of
14 min read
BizTalk Server: What are Flat Files?
Sandro Pereira
Jul 26, 2023
Transformations are among the most common components of integration processes They act as essential translators, decoupling systems, and enabling
14 min read
BizTalk Server: Teach me something new about Flat Files (or not) – Delimited Flat File Schema Opt...
Sandro Pereira
Oct 23, 2015
We ended the last post asking: Do you think the Schema is entirely correct Does it handle all files according to the expected results Or do we need to tune
10 min read
BizTalk Server: Teach me something new about Flat Files (or not) – Files Delimited by Symbols
Sandro Pereira
Oct 14, 2015
This post is intended to consolidate some basic principles about the Flat File Schema Wizard First of all, BizTalk Flat File Schema Wizard is a template
