Untitled

 avatar
unknown
plain_text
2 years ago
529 B
4
Indexable
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
Editor is loading...
Leave a Comment