IBM Support

Document extraction map is not correctly splitting documents for JD Edwards data (SCI62982) *|* -AB3CB58877498CC785257918

Question & Answer


Question

Document extraction map is not correctly splitting documents for JD Edwards data (SCI62982) *|* -AB3CB58877498CC78525791800433802- *|*

Answer

Technote (troubleshooting)


Problem(Abstract)

Document extraction map is not correctly splitting documents for JD Edwards data (SCI62982)

Symptom

Map for the Document Extraction Service is not properly splitting the input file.?
Document extraction only splits the first document. then appends subsequent splits onto first split.


Cause

The extended rule did not properly account for the quotes around the data fields for JD Edwards data

Resolving the problem

Modified the extended rule to account for the quoted data.? To validate when to split the documents the extended rule looks at the left-most two characters which equate to "1.? It then looks at the right-most character within that selection which is 1.?



string[1024] buffer;
string[1] match;
integer match_len;

// set these next two variables as desired
match = "1"; // header tag
match_len = 1; // the length of the tag

// read the block we're on and write it
readblock(buffer);
writeblock(buffer);

// keep reading and writing records until the end of the document
while readblock(buffer) do
begin
? if right(left(buffer 2)match_len) = match | buffer = "" then
? begin
??? unreadblock();
??? break;
? end
? writeblock(buffer);
end

Historical Number

PRI32578

Product Alias/Synonym

Fact


Gentran Integration Suite All Releases
Sterling Integrator All Releases

Document Extraction Service
Map Editor
JD Edwards data

Individual data fields are quoted
SCI62982

[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SS73G6","label":"Sterling Total Payments for Financial Services"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
12 October 2021

UID

ibm10767835