I tried to implement bubble sort in BICMD by phoenetic string comparison turned out not to be supported
But for my use case a method to group a 2D array of string by first key would do fine
/* ----------------------------------------------------------------
Peter Lykkegaard, 25 Oct 2025
-----------------------------
Name: groupByArray
Description
This code processes a 2D array "pvData$[][]" by grouping rows based on the value in the first column.
It avoids reprocessing rows by marking them as "found" in "lvProcessedRows$[]".
The grouped rows are stored in "lvGroupedData$[][]", preserving all column data.
The algorithm uses nested loops to compare and group rows with matching keys.
Parameters
pvData$[][] - 2D array which should be grouped
Output
$[][] - 2D array grouped by keyword
-------------------------------------------------------------- */
local
lvTotalRows%, // Total number of rows in pvData$
lvColumnIndex%, // Index for iterating through columns
lvNewRowIndex%, // Index for inserting into lvGroupedData$
lvKeyIndex%, // Index for keyword for grouping
lvTotalColumns%, // Total number of columns in pvData$
lvCurrentRow%, // Current row being processed
lvCurrentKey$, // Key value from the first column of the current row
lvCheckRow%, // Row index used to check for matching keys
lvProcessedRows$[], // Array to track which rows have been processed
lvGroupedData$[][], // Output array to store grouped rows
lvFound$; // Marker string to indicate a row has been processed
copy 0 to lvKeyIndex%;
copy 0 to lvCurrentRow%;
copy 0 to lvNewRowIndex%;
copy "found" to lvFound$;
// Number of rows
copy getSize(pvData$) to lvTotalRows%;
// Depth / number of columns
copy getSize(pvData$[1]) to lvTotalColumns%;
// Outer loop: iterate through the array
for lvCurrentRow% = 0 to lvTotalRows% - 1
if (lvProcessedRows$[lvCurrentRow%] &!= lvFound$)
copy pvData$[lvCurrentRow%][lvKeyIndex%] to lvCurrentKey$;
// Inner loop: check all rows from current to end for matching keys
for lvCheckRow% = lvCurrentRow% to lvTotalRows% - 1
if (pvData$[lvCheckRow%][lvKeyIndex%] &= lvCurrentKey$)
traceln("lvCurrentKey: " & lvCurrentKey$);
for lvColumnIndex% = 0 TO lvTotalColumns% - 1
copy pvData$[lvCheckRow%][lvColumnIndex%] to lvGroupedData$[lvNewRowIndex%][lvColumnIndex%];
next
// Mark the row as processed and increment the index
// to examine the next row for grouping
copy lvFound$ to lvProcessedRows$[lvCheckRow%];
copy lvNewRowIndex% + 1 to lvNewRowIndex%;
endif
next
endif
next
// return array grouped by first given key
exitProc(lvGroupedData$);
Easily converted to NET 9 C# 12 using CoPilot / ChatGPT5, use what data content you'd prefer and run some iterations in a Console App to check program flow
Fluent API or Fluent Interfaces
https://www.primaryobjects.com/2011/02/07/fluent-interfaces-in-c-net-with-expression-builder-method-chaining-and-rpg-games/
Fluent XML document validation
Fluent Interface
An interface designed in a way that actions are chained together gives a fluent, readable and natural style of logic
https://en.wikipedia.org/wiki/Fluent_interface
- It improves code readability and flow, like writing sentences
- It is commonly used in query builders, configuration settings, and ORMs (like Entity Framework).
In this article you will have a POC (Proof of Concept) which uses a fluent interface for the steps needed to fully validate an XML document
A fluent interface fits perfectly with the step you need to go though in a specific ordering when you validate XML data
Interfaces we are going to use
- Create Document
- Create prepares the document for validation
- Check syntax
- First check document for syntax errors
- Check structure
- Next check the document for structural integrity, eg do schema validation
- Check content
- Basic validation is done we can check the document for the business requirements
- Transform document
- Or we are ready to style and transform the document to a readable presentation by using eg a stylesheet
- Result
- Return the validation result
Main class to stich it all together
- XMLValidator
- Inherits
- Document
- ValidateSyntax
- ValidateStructure
- Validated
- CheckContent
- TransformContent
- ValidationResult
The resulting work flow
- Fulfilment
- Validation occurs in strict order or chain defined by the returned interface in the methods called
- Response is added to StringBuilder by each step
- Validation result is returned to user and thus the chain is terminated
POC of FluentValidator
All interfaces
Steps needed for the document object to be prober validated
// Interfaces used for building the fluent validator
namespace FluentValidator.Interface
{
/// <summary>
/// Prepare document for validation
/// </summary>
public interface IDocument
{
public IValidateSyntax Create();
}
/// <summary>
/// RuUn a syntax check on the document
/// </summary>
public interface IValidateSyntax
{
public IValidateStructure CheckSyntax();
}
/// <summary>
/// Validate the structure of the document using a schema
/// </summary>
public interface IValidateStructure
{
public IValidated CheckStructure();
}
/// <summary>
/// Document is structural and semantic valid
/// </summary>
public interface IValidated
{
public IValidationResult CheckContent();
public IValidationResult TransformContent();
}
/// <summary>
/// Return validation result
/// </summary>
public interface IValidationResult
{
public string GetMessage();
}
}
The concrete class implementation using the interfaces we have created
using System.Text;
using FluentValidator.Interface;
namespace FluentValidator.Validator
{
/// <summary>
/// Concrete implementation of the fluent validator
/// </summary>
/// <seealso cref="FluentValidator.Interface.IValidateSyntax" />
/// <seealso cref="FluentValidator.Interface.IValidateStructure" />
/// <seealso cref="FluentValidator.Interface.IValidated" />
/// <seealso cref="FluentValidator.Interface.IValidationResult" />
/// <seealso cref="FluentValidator.Interface.IDocument" />
public class ValidateXML : IValidateSyntax, IValidateStructure, IValidated, IValidationResult, IDocument
{
private StringBuilder message = new StringBuilder();
/// <summary>
/// Creates the instance.
/// </summary>
/// <returns></returns>
public IValidateSyntax Create()
{
return new ValidateXML();
}
/// <summary>
/// Checks the syntax.
/// </summary>
/// <returns>IValidateStructure</returns>
public IValidateStructure CheckSyntax()
{
message.Append("Syntax validated\r\n");
return this;
}
/// <summary>
/// Checks the structure.
/// </summary>
/// <returns>IValidated</returns>
public IValidated CheckStructure()
{
message.Append("Structure validated\r\n");
return this;
}
/// <summary>
/// Checks the content.
/// </summary>
/// <returns>IValidationResult</returns>
public IValidationResult CheckContent()
{
message.Append("Content validated\r\n");
return this;
}
/// <summary>
/// Transforms the content.
/// </summary>
/// <returns>IValidationResult</returns>
public IValidationResult TransformContent()
{
message.Append("Stylesheet applied\r\n");
return this;
}
/// <summary>
/// Gets the message.
/// </summary>
/// <returns>string</returns>
public string GetMessage()
{
return message.ToString();
}
}
}
POC program to run
using FluentValidator.Validator;
namespace FluentValidator
{
internal class Program
{
static void Main(string[] args)
{
ValidateXML validate = new ValidateXML();
Console.WriteLine("Validate XML file:");
Console.WriteLine("------------------");
Console.WriteLine(
validate.Create()
.CheckSyntax()
.CheckStructure()
.CheckContent()
.GetMessage()
);
Console.WriteLine("");
Console.WriteLine("Validate and transform XML file:");
Console.WriteLine("--------------------------------");
Console.WriteLine(
validate.Create()
.CheckSyntax()
.CheckStructure()
.TransformContent()
.GetMessage()
);
Console.ReadKey();
}
}
}
Console output from the program
Validate XML file:
------------------
Syntax validated
Structure validated
Content validated
Validate and transform XML file:
--------------------------------
Syntax validated
Structure validated
Stylesheet applied
Try the example at Fiddle
https://dotnetfiddle.net/gqNieE
For mappings created in the Business Integration Converter (BIC) at times you need local or global procedures following the DRY principles in coding (Don't repeat yourself)
Maybe you need to enhance the BIC script by adding some inline Java code like shown in eg the unescapeHTML procedure found on these pages
It can be parameters in procedure signature or local variables, in the unescapeHTML procedure we can find this code
// Procedure parameter used in java code
String source = _StrVar_PSOURCE.getString();
You can find a lot of examples of this style of Java code in your build folders, in <source>\<project>\build\test\com\seeburger\jucon\mapping you can examine the Java files from your recent build
An example
// Java code example assigning an IDOC numer to a numeric variable
_NumVar_IDOC_NUMBER.setNum(stdin.getField("THIS:DOCNUM"));
Another small example which uses Java variables described is the getUUID method
You can find some examples on this site: Methods using inline Java
An utility to add leading zeros up to given length to a numeric string
Please note Alphanumeric string will be left untouched
A procedure to use in Seeburger BIC Mapping Designer
It will extend your library for string handling
/* -----------------------------
Peter Lykkegaard, 22 mar 2019
-----------------------------
Method
zeroFill
Parameters
value$: String to prefix with zeros
Num%: Number of characters, length of string after prefixzing
Returns
$
Description
If the parameter value is a numeric value and
the length of the string does not exceed length of the value
*/
if (isNumeric(value$) && len(value$) < num%)
copy lfill(value$, "0", num%) to value$;
endif
exitProc(value$);
Split text on right most space before limit is reached
Use to split text on several lines in receiving document, eg edifact LIN-IMD-C273 has several 7008 text element
// -----------------------------
// Peter Lykkegaard, 22 mar 2019
// -----------------------------
// Split long note on right most space before limit is reached
// TODO! Check parameters if they are of valid type/content
//
// Name: splitNoteBySpace
// Description: Method to split a given string by latest space before length limit
// Parameters
// input$, alphanumerical / String which needs to be split
// max$, alphanumerical / Max characters on each line
// Output, alphanumeric / array / Array of strings to return
local lvOutput$[];
#importJavaStart
import java.util.regex.Matcher;
import java.util.regex.Pattern;
#importJavaEnd
#javastart
String input = _StrVar_PINPUT.getString();
int max = (int)_NumVar_PMAX.getNum();
int len = input.length();
String regex = "(.{1," + max + "})(?:\\s|$)";
Pattern pattern = Pattern.compile(regex, Pattern.MULTILINE);
Matcher matcher = pattern.matcher(input);
_StrVar_LVOUTPUT.getJuVar(0, 2).setString(input);
if (len > max)
{
int idx = 0; // Entries in output
while (matcher.find()) {
for (int i = 1; i <= matcher.groupCount(); i++) {
_StrVar_LVOUTPUT.getJuVar(idx, 2).setString(matcher.group(i).toString());
}
idx++;
}
}
#javaEnd
exitProc(lvOutput$);