Business Integration Solutions SaaS

About: TEXTTOXMLTRANSLATOR activity

In Business Integration Solutions, use the TEXTTOXMLTRANSLATOR activity to convert a TEXT document into an XML document.

Usage

Use this activity to translate a document in text (or fixed-length) format into a document in XML format.

Concept

A fixed-width text file has a specific format that stores textual information in an organized way. Fixed-width text files are a special case of text files where the format is specified by column widths, pad character, and left/right alignment. Column widths are measured in characters. For example, if the first column always has exactly 10 characters, the second has exactly five, and the third has exactly 12, you have a fixed-width text file.

Each row (paragraph) contains one record of information. Each record can contain several pieces of data (fields), and each data field (column) has a precise number of characters. The data is padded with spaces (or any character you specify) if it does not use all the characters allotted to it. Each piece of data can also be left- or right-justified, meaning padding occurs on either side.

Business Central cannot interpret data stored in text format. If your company receives data in text format, use the TEXTTOXMLTRANSLATOR activity in your import pipeline. This activity converts the incoming data into a structured XML format based on a predefined document.

To use this activity, define a document based on which the incoming data translates. You can also specify a row from which to start data translation.

Text input ➡️ [TEXTTOXMLTRANSLATOR] ➡️ XML output