Untitled
unknown
plain_text
2 years ago
529 B
5
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