Untitled

mail@pastecode.io avatar
unknown
plain_text
6 months ago
529 B
2
Indexable
Never
local stringvar description := {YourTable.COD21Z_Description};
local stringvar withPrev := "";
local stringvar withoutPrev := "";

local datevar extractionDate := {YourTable.COD21Z_Extraction_Date}; // Assuming this is your extraction date field

if InStr(description, "Prev.") > 0 and {YourTable.COD21Z_batchdate} < extractionDate then
    withPrev := Replace(description, "Prev.", "") + Chr(10);
    withoutPrev := "Prev." + Replace(description, "Prev.", "", 1, 1);
else
    withoutPrev := description;

withoutPrev + withPrev
Leave a Comment