Codeunit 5302 Outlook Synch. Type Conv

Base Application, Microsoft.CRM.Outlook

src/Layers/W1/BaseApp/CRM/Outlook/OutlookSynchTypeConv.Codeunit.al906 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.CRM.Outlook;using System.Reflection;codeunit 5302 "Outlook Synch. Type Conv"{    trigger OnRun()    begin    end;    var#pragma warning disable AA0074#pragma warning disable AA0470        Text001: Label 'The filter expression ''%1'' is invalid.\Please redefine your criteria.';#pragma warning restore AA0470        Text002: Label 'The filter cannot be processed because the expression is too long.\Please redefine your criteria.';#pragma warning disable AA0470        Text003: Label 'The synchronization failed because the %1 field in the %2 table is of an unsupported type. Please contact your system administrator.';#pragma warning restore AA0470#pragma warning restore AA0074        "Field": Record "Field";    local procedure GetOptionsQuantity(OptionString: Text): Integer    var        Counter: Integer;        CommaPosition: Integer;    begin        if StrPos(OptionString, ',') = 0 then            exit(0);        repeat            CommaPosition := StrPos(OptionString, ',');            OptionString := DelStr(OptionString, 1, CommaPosition);            Counter := Counter + 1;        until CommaPosition = 0;        exit(Counter - 1);    end;    procedure GetSubStrByNo(Number: Integer; CommaString: Text) SelectedStr: Text    var        SubStrQuantity: Integer;        Counter: Integer;        CommaPosition: Integer;    begin        if Number <= 0 then            exit;        SubStrQuantity := GetOptionsQuantity(CommaString);        if SubStrQuantity + 1 < Number then            exit;        repeat            Counter := Counter + 1;            CommaPosition := StrPos(CommaString, ',');            if CommaPosition = 0 then                SelectedStr := CommaString            else begin                SelectedStr := CopyStr(CommaString, 1, CommaPosition - 1);                CommaString := DelStr(CommaString, 1, CommaPosition);            end;        until Counter = Number;    end;    procedure EvaluateTextToFieldRef(InputText: Text; var FieldRef: FieldRef; ToValidate: Boolean): Boolean    var        GUIDVar: Guid;        GUIDVar1: Guid;        BigIntVar: BigInteger;        BigIntVar1: BigInteger;        IntVar: Integer;        IntVar1: Integer;        DecimalVar: Decimal;        DecimalVar1: Decimal;        BoolVar: Boolean;        BoolVar1: Boolean;        DateVar: Date;        DateVar1: Date;        TimeVar: Time;        TimeVar1: Time;        DateTimeVar: DateTime;        DateTimeVar1: DateTime;        DurationVar: Duration;        DurationVar1: Duration;        DateFormulaVar: DateFormula;        DateFormulaVar1: DateFormula;        TextVar: Text;        TextVar1: Text;    begin        if FieldRef.Class in [FieldClass::FlowField, FieldClass::FlowFilter] then            exit(true);        case FieldRef.Type of            FieldType::Option:                begin                    if not Evaluate(IntVar, InputText) then                        IntVar := TextToOptionValue(InputText, FieldRef.OptionCaption);                    if IntVar < 0 then                        exit(false);                    if ToValidate then begin                        IntVar1 := FieldRef.Value();                        if IntVar1 <> IntVar then                            FieldRef.Validate(IntVar);                    end else                        FieldRef.Value := IntVar;                end;            FieldType::Integer:                if TextToInteger(InputText, IntVar) then begin                    if ToValidate then begin                        IntVar1 := FieldRef.Value();                        if IntVar1 <> IntVar then                            FieldRef.Validate(IntVar);                    end else                        FieldRef.Value := IntVar;                end else                    exit(false);            FieldType::Decimal:                if TextToDecimal(InputText, DecimalVar) then begin                    if ToValidate then begin                        DecimalVar1 := FieldRef.Value();                        if DecimalVar1 <> DecimalVar then                            FieldRef.Validate(DecimalVar);                    end else                        FieldRef.Value := DecimalVar;                end else                    exit(false);            FieldType::Date:                if TextToDate(InputText, DateVar, true) then begin                    if ToValidate then begin                        DateVar1 := FieldRef.Value();                        if DateVar1 <> DateVar then                            FieldRef.Validate(DateVar);                    end else                        FieldRef.Value := DateVar;                end else                    exit(false);            FieldType::Time:                if TextToTime(InputText, TimeVar, true) then begin                    if ToValidate then begin                        TimeVar1 := FieldRef.Value();                        if TimeVar1 <> TimeVar then                            FieldRef.Validate(TimeVar);                    end else                        FieldRef.Value := TimeVar;                end else                    exit(false);            FieldType::DateTime:                if TextToDateTime(InputText, DateTimeVar) then begin                    if ToValidate then begin                        DateTimeVar1 := FieldRef.Value();                        if DateTimeVar1 <> DateTimeVar then                            FieldRef.Validate(DateTimeVar);                    end else                        FieldRef.Value := DateTimeVar;                end else                    exit(false);            FieldType::Boolean:                if TextToBoolean(InputText, BoolVar) then begin                    if ToValidate then begin                        BoolVar1 := FieldRef.Value();                        if BoolVar1 <> BoolVar then                            FieldRef.Validate(BoolVar);                    end else                        FieldRef.Value := BoolVar;                end else                    exit(false);            FieldType::Duration:                if TextToDuration(InputText, DurationVar) then begin                    if ToValidate then begin                        DurationVar1 := FieldRef.Value();                        if DurationVar1 <> DurationVar then                            FieldRef.Validate(DurationVar);                    end else                        FieldRef.Value := DurationVar;                end else                    exit(false);            FieldType::BigInteger:                if TextToBigInteger(InputText, BigIntVar) then begin                    if ToValidate then begin                        BigIntVar1 := FieldRef.Value();                        if BigIntVar1 <> BigIntVar then                            FieldRef.Validate(BigIntVar);                    end else                        FieldRef.Value := BigIntVar;                end else                    exit(false);            FieldType::GUID:                if TextToGUID(InputText, GUIDVar) then begin                    if ToValidate then begin                        GUIDVar1 := FieldRef.Value();                        if GUIDVar1 <> GUIDVar then                            FieldRef.Validate(GUIDVar);                    end else                        FieldRef.Value := GUIDVar;                end else                    exit(false);            FieldType::Code, FieldType::Text:                if StrLen(InputText) > FieldRef.Length then begin                    if ToValidate then begin                        TextVar := FieldRef.Value();                        TextVar1 := PadStr(InputText, FieldRef.Length);                        if TextVar <> TextVar1 then                            FieldRef.Validate(TextVar1);                    end else                        FieldRef.Value := PadStr(InputText, FieldRef.Length);                end else                    if ToValidate then begin                        TextVar := FieldRef.Value();                        if TextVar <> InputText then                            FieldRef.Validate(InputText);                    end else                        FieldRef.Value := InputText;            FieldType::DateFormula:                if TextToDateFormula(InputText, DateFormulaVar) then begin                    if ToValidate then begin                        DateFormulaVar1 := FieldRef.Value();                        if DateFormulaVar1 <> DateFormulaVar then                            FieldRef.Validate(DateFormulaVar);                    end else                        FieldRef.Value := DateFormulaVar;                end else                    exit(false);            else                exit(false);        end;        exit(true);    end;    procedure TextToOptionValue(InputText: Text; OptionString: Text): Integer    var        IntVar: Integer;        Counter: Integer;    begin        if InputText = '' then            InputText := ' ';        if Evaluate(IntVar, InputText) then begin            if IntVar < 0 then                IntVar := -1;            if GetOptionsQuantity(OptionString) < IntVar then                IntVar := -1;        end else begin            IntVar := -1;            for Counter := 1 to GetOptionsQuantity(OptionString) + 1 do                if UpperCase(GetSubStrByNo(Counter, OptionString)) = UpperCase(InputText) then                    IntVar := Counter - 1;        end;        exit(IntVar);    end;    procedure TextToInteger(InputText: Text; var IntVar: Integer) IsConverted: Boolean    begin        IsConverted := Evaluate(IntVar, InputText);    end;    procedure TextToBigInteger(InputText: Text; var BigIntVar: BigInteger) IsConverted: Boolean    begin        IsConverted := Evaluate(BigIntVar, InputText);    end;    procedure TextToBoolean(InputText: Text; var BoolVar: Boolean) IsConverted: Boolean    begin        IsConverted := Evaluate(BoolVar, InputText);    end;    procedure TextToGUID(InputText: Text; var GUIDVar: Guid) IsConverted: Boolean    begin        IsConverted := Evaluate(GUIDVar, InputText);    end;    procedure TextToDecimal(InputText: Text; var DecVar: Decimal) IsConverted: Boolean    var        PartArray: array[2] of Text;        IntegeralPart: Integer;        FractionalPart: Integer;        Sign: Integer;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeTextToDecimal(InputText, DecVar, IsConverted, IsHandled);        if IsHandled then            exit(IsConverted);        InputText := ConvertStr(InputText, '.', ',');        if StrPos(InputText, ',') = 0 then begin            IsConverted := TextToInteger(InputText, IntegeralPart);            if IsConverted then                DecVar := IntegeralPart;            exit;        end;        PartArray[1] := GetSubStrByNo(1, InputText);        PartArray[2] := GetSubStrByNo(2, InputText);        IsConverted := Evaluate(IntegeralPart, PartArray[1]);        if not IsConverted then            exit;        IsConverted := Evaluate(FractionalPart, PartArray[2]);        if not IsConverted then            exit;        if StrPos(InputText, '-') = 0 then            Sign := 1        else            Sign := -1;        DecVar := (Sign * (Abs(IntegeralPart) + (FractionalPart / Power(10, StrLen(PartArray[2])))));    end;    local procedure TextToDate(InputText: Text; var DateVar: Date; UseLocalTime: Boolean) IsConverted: Boolean    var        Day: Integer;        Month: Integer;        Year: Integer;        DateTimeVar: DateTime;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeTextToDate(InputText, DateVar, UseLocalTime, IsConverted, IsHandled);        if IsHandled then            exit(IsConverted);        InputText := ConvertStr(InputText, ' ', ',');        if StrPos(InputText, ',') = 0 then            exit;        InputText := GetSubStrByNo(1, InputText);        InputText := ConvertStr(InputText, '/', ',');        if StrPos(InputText, ',') = 0 then            exit;        IsConverted := Evaluate(Month, GetSubStrByNo(1, InputText));        if not IsConverted then            exit;        InputText := DelStr(InputText, 1, StrPos(InputText, ','));        if StrPos(InputText, ',') = 0 then begin            IsConverted := false;            exit;        end;        IsConverted := Evaluate(Day, GetSubStrByNo(1, InputText));        if not IsConverted then            exit;        IsConverted := Evaluate(Year, GetSubStrByNo(2, InputText));        if not IsConverted then            exit;        if (Day < 1) and (Day > 31) and (Month < 1) and (Month > 12) then begin            IsConverted := false;            exit;        end;        DateVar := DMY2Date(Day, Month, Year);        if DateVar = 45010101D then            DateVar := 0D        else begin            if UseLocalTime then                DateTimeVar := UTC2LocalDT(CreateDateTime(DateVar, 000000T))            else                DateTimeVar := CreateDateTime(DateVar, 000000T);            DateVar := DT2Date(DateTimeVar);        end;    end;    local procedure TextToTime(InputText: Text; var TimeVar: Time; UseLocalTime: Boolean) IsConverted: Boolean    var        DateTimeVar: DateTime;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeTextToTime(InputText, TimeVar, UseLocalTime, IsConverted, IsHandled);        if IsHandled then            exit(IsConverted);        InputText := ConvertStr(InputText, ' ', ',');        if StrPos(InputText, ',') = 0 then            exit;        IsConverted := Evaluate(TimeVar, GetSubStrByNo(2, InputText));        if not IsConverted then            exit;        if UseLocalTime then            DateTimeVar := UTC2LocalDT(CreateDateTime(Today, TimeVar))        else            DateTimeVar := CreateDateTime(Today, TimeVar);        TimeVar := DT2Time(DateTimeVar);    end;    procedure TextToDateTime(InputText: Text; var DateTimeVar: DateTime) IsConverted: Boolean    var        DateVar: Date;        TimeVar: Time;    begin        IsConverted := TextToDate(InputText, DateVar, false);        if not IsConverted then            exit;        IsConverted := TextToTime(InputText, TimeVar, false);        if not IsConverted then            exit;        if DateVar <> 0D then            DateTimeVar := UTC2LocalDT(CreateDateTime(DateVar, TimeVar))        else            if TimeVar <> 0T then                DateTimeVar := CreateDateTime(Today, TimeVar);    end;    procedure TextToDuration(InputText: Text; var DurationVar: Duration) IsConverted: Boolean    var        Millisec: BigInteger;    begin        if not Evaluate(Millisec, InputText) then            exit;        Millisec := Millisec * 60000;        DurationVar := Millisec;        IsConverted := true;    end;    procedure TextToDateFormula(InputText: Text; var DateFormulaVar: DateFormula) IsConverted: Boolean    begin        IsConverted := Evaluate(DateFormulaVar, InputText);    end;    procedure OptionValueToText(InputInteger: Integer; OptionString: Text) OutputText: Text    begin        if (InputInteger >= 0) and (InputInteger <= GetOptionsQuantity(OptionString)) then            OutputText := SelectStr(InputInteger + 1, OptionString);    end;    procedure FieldOptionValueToText(InputInteger: Integer; OptionRecordId: Integer; OptionFieldId: Integer) OutputText: Text    var        OptionString: Text;    begin        OptionString := GetOptionCaption(OptionRecordId, OptionFieldId);        if (InputInteger >= 0) and (InputInteger <= GetOptionsQuantity(OptionString)) then            OutputText := SelectStr(InputInteger + 1, OptionString);    end;    procedure EvaluateOptionField(FieldRef: FieldRef; var ValueToEvaluate: Text): Boolean    var        IntValue: Integer;    begin        IntValue := TextToOptionValue(ValueToEvaluate, FieldRef.OptionCaption);        if IntValue <> -1 then            ValueToEvaluate := SelectStr(IntValue + 1, FieldRef.OptionCaption);        exit(IntValue <> -1);    end;    procedure EvaluateFilterOptionField(FieldRef: FieldRef; var FilterValueToEvaluate: Text; ReplaceOptionsWithValues: Boolean) Asserted: Boolean    var        AssertedOption: Text;        TempString: Text;        ArrayImpliedOptions: array[20] of Text;        IntValue: Integer;        I: Integer;        SpaceRemovePosStart: Integer;        SpaceRemovePosEnd: Integer;        ImpliedOption: Text;    begin        TempString := FilterValueToEvaluate;        if not ParseFilterExpression(TempString, ArrayImpliedOptions) then            Error(Text001, FilterValueToEvaluate);        TempString := FilterValueToEvaluate;        SpaceRemovePosStart := 1;        for I := 1 to 20 do begin            AssertedOption := '';            ImpliedOption := '';            if ArrayImpliedOptions[I] <> '' then begin                ImpliedOption := ArrayImpliedOptions[I];                if Evaluate(IntValue, ImpliedOption) then begin                    AssertedOption := OptionValueToText(IntValue, FieldRef.OptionCaption);                    Asserted := AssertedOption <> '';                end else begin                    IntValue := TextToOptionValue(ImpliedOption, FieldRef.OptionCaption);                    if IntValue <> -1 then                        AssertedOption := SelectStr(IntValue + 1, FieldRef.OptionCaption);                    Asserted := IntValue <> -1;                end;                if not Asserted then                    exit;                if ReplaceOptionsWithValues then                    AssertedOption := Format(IntValue);                if (StrPos(AssertedOption, '(') <> 0) or (StrPos(AssertedOption, ')') <> 0) or (AssertedOption = ' ') then                    AssertedOption := StrSubstNo('''%1''', AssertedOption);                SpaceRemovePosEnd := StrPos(TempString, ImpliedOption);                TempString := RemoveSpaceChars(TempString, SpaceRemovePosStart, SpaceRemovePosEnd);                if (StrLen(TempString) + StrLen(AssertedOption) - StrLen(ImpliedOption)) > MaxStrLen(TempString) then                    Error(Text002);                SpaceRemovePosStart := StrPos(TempString, ImpliedOption) + StrLen(AssertedOption);                TempString := ReplaceText(TempString, ImpliedOption, AssertedOption, true);            end;        end;        TempString := RemoveSpaceChars(TempString, SpaceRemovePosStart, StrLen(TempString));        FilterValueToEvaluate := TempString;    end;    local procedure ParseFilterExpression(var FilterExpression: Text; var ArrayTokens: array[20] of Text): Boolean    var        TempStr: Text;        ReservedFilterChars: Text;        I: Integer;        "Count": Integer;    begin        if FilterExpression = '' then            FilterExpression := ' ';        FilterExpression := ConvertStr(FilterExpression, '&|', ',,');        FilterExpression := ReplaceText(FilterExpression, '..', ',', false);        if FilterExpression[StrLen(FilterExpression)] = ',' then            exit(false);        TempStr := FilterExpression;        Count := 1;        while StrPos(TempStr, ',') > 0 do begin            TempStr := DelStr(TempStr, StrPos(TempStr, ','), 1);            Count := Count + 1;        end;        if Count > 20 then            exit(false);        ReservedFilterChars := '&|<>=()';        FilterExpression := DelChr(FilterExpression, '=', ReservedFilterChars);        FilterExpression := DelChr(FilterExpression, '<>', ' ');        if FilterExpression = '' then            exit(false);        for I := 1 to Count do            ArrayTokens[I] := DelChr(GetSubStrByNo(I, FilterExpression), '<>', ' ');        exit(true);    end;    local procedure ReplaceText(Text: Text; FromText: Text; ToText: Text; OnlyOnce: Boolean): Text    var        I: Integer;    begin        repeat            I := StrPos(Text, FromText);            if I > 0 then begin                Text := DelStr(Text, I, StrLen(FromText));                Text := InsStr(Text, ToText, I);            end;        until (I = 0) or OnlyOnce;        exit(Text);    end;    local procedure RemoveSpaceChars(Text: Text; StartPos: Integer; EndPos: Integer) OutText: Text    var        SpaceRemovedString: Text;    begin        OutText := Text;        if (StrLen(Text) > EndPos) and (EndPos > StartPos) then begin            SpaceRemovedString := CopyStr(Text, StartPos, EndPos - StartPos);            OutText := ReplaceText(Text, SpaceRemovedString, DelChr(SpaceRemovedString, '=', ' '), true);        end;    end;    procedure TruncateString(var InputString: Text; NewLength: Integer)    begin        if StrLen(InputString) > NewLength then            InputString := PadStr(InputString, NewLength);    end;    procedure SetTimeFormat(InTime: Time) OutTime: Text    begin        OutTime := ConvertStr(Format(InTime, 0, '<Hours24,2>:<Minutes,2>:<Seconds,2>'), ' ', '0');    end;    procedure SetDateFormat(InDate: Date) OutDate: Text    begin        OutDate := Format(InDate, 0, '<Month,2>/<Day,2>/<Year4>');    end;    procedure SetDateTimeFormat(InDateTime: DateTime) OutDateTime: Text    begin        if InDateTime = 0DT then            OutDateTime := SetDateFormat(45010101D) + ' ' + SetTimeFormat(000000T)        else            OutDateTime := SetDateFormat(DT2Date(InDateTime)) + ' ' + SetTimeFormat(DT2Time(InDateTime));    end;    procedure SetDecimalFormat(InDecimal: Decimal) OutDecimal: Text    begin        OutDecimal := Format(InDecimal, 0, '<Sign>') + Format(InDecimal, 0, '<Integer>');        if CopyStr(Format(InDecimal, 0, '<Decimals>'), 2) <> '' then            OutDecimal := OutDecimal + '.' + CopyStr(Format(InDecimal, 0, '<Decimals>'), 2)        else            OutDecimal := OutDecimal + '.0';    end;    procedure SetBoolFormat(InBoolean: Boolean) OutBoolean: Text    begin        if InBoolean then            OutBoolean := '1'        else            OutBoolean := '0';    end;    [Scope('OnPrem')]    procedure PrepareFieldValueForXML(FldRef: FieldRef) OutText: Text    var        RecID: RecordID;        Date: Date;        Time: Time;        DateTime: DateTime;        BigInt: BigInteger;        Decimal: Decimal;        Bool: Boolean;    begin        if FldRef.Class = FieldClass::FlowField then            FldRef.CalcField();        case FldRef.Type of            FieldType::Option:                OutText := Format(FldRef);            FieldType::Text, FieldType::Code:                OutText := Format(FldRef.Value);            FieldType::Date:                begin                    Evaluate(Date, Format(FldRef.Value));                    DateTime := CreateDateTime(Date, 0T);                    Date := DT2Date(LocalDT2UTC(DateTime));                    OutText := SetDateFormat(Date);                end;            FieldType::Time:                begin                    Evaluate(Time, Format(FldRef.Value));                    DateTime := CreateDateTime(Today, Time);                    Time := DT2Time(LocalDT2UTC(DateTime));                    OutText := SetTimeFormat(Time);                end;            FieldType::DateTime:                begin                    Evaluate(DateTime, Format(FldRef.Value));                    OutText := SetDateTimeFormat(LocalDT2UTC(DateTime));                end;            FieldType::Integer, FieldType::BigInteger:                OutText := Format(FldRef.Value);            FieldType::Duration:                begin                    BigInt := FldRef.Value();                    // Use round to avoid conversion errors due to the conversion from decimal to long.                    BigInt := Round(BigInt / 60000, 1);                    OutText := Format(BigInt);                end;            FieldType::Decimal:                begin                    Evaluate(Decimal, Format(FldRef.Value));                    OutText := SetDecimalFormat(Decimal);                end;            FieldType::DateFormula:                OutText := Format(FldRef.Value);            FieldType::Boolean:                begin                    Evaluate(Bool, Format(FldRef.Value));                    OutText := SetBoolFormat(Bool);                end;            FieldType::GUID:                OutText := Format(FldRef.Value);            else begin                RecID := FldRef.Record().RecordId;                Field.Get(RecID.TableNo, FldRef.Number);                Error(Text003, Field."Field Caption", FldRef.Record().Caption);            end;        end;    end;    [Scope('OnPrem')]    procedure SetValueFormat(FormattedValue: Text; FldRef: FieldRef) OutText: Text    var        RecID: RecordID;        Date: Date;        Time: Time;        DateTime: DateTime;        BigInt: BigInteger;        Decimal: Decimal;        Bool: Boolean;        DurationVar: Duration;    begin        case FldRef.Type of            FieldType::Text, FieldType::Code, FieldType::Option, FieldType::DateFormula, FieldType::GUID:                OutText := FormattedValue;            FieldType::Date:                begin                    Evaluate(Date, FormattedValue, 9);                    if Date <> 0D then                        OutText := SetDateTimeFormat(CreateDateTime(Date, 000000T));                end;            FieldType::Time:                begin                    Evaluate(Time, FormattedValue, 9);                    OutText := SetDateTimeFormat(CreateDateTime(45010101D, Time));                end;            FieldType::DateTime:                begin                    Evaluate(DateTime, FormattedValue, 9);                    OutText := SetDateTimeFormat(DateTime);                end;            FieldType::Integer, FieldType::BigInteger:                OutText := FormattedValue;            FieldType::Decimal:                begin                    Evaluate(Decimal, FormattedValue, 9);                    OutText := SetDecimalFormat(Decimal);                end;            FieldType::Boolean:                begin                    Evaluate(Bool, FormattedValue, 9);                    OutText := SetBoolFormat(Bool);                end;            FieldType::Duration:                begin                    Evaluate(DurationVar, FormattedValue, 9);                    BigInt := DurationVar / 60000;                    OutText := Format(BigInt);                end;            else begin                RecID := FldRef.Record().RecordId;                Field.Get(RecID.TableNo, FldRef.Number);                Error(Text003, FldRef.Caption, FldRef.Record().Caption);            end;        end;    end;    procedure HandleFilterChars(InputText: Text; MaxLength: Integer): Text    var        Pos: Integer;        Char: Char;        QuotesNeeded: Boolean;    begin        if (StrLen(InputText) + 2) > MaxLength then            exit(InputText);        Pos := 1;        repeat            Char := InputText[Pos];            if Char in ['@', '(', ')', '<', '>', '&', '|', '='] then                QuotesNeeded := true;            Pos := Pos + 1;        until (Pos = MaxLength) or QuotesNeeded;        if QuotesNeeded then            exit(StrSubstNo('"%1"', InputText));        exit(InputText);    end;    procedure ReplaceFilterChars(InputString: Text) Result: Text    begin        Result := ConvertStr(InputString, '@()<>&|="''', '??????????');        if Result = '' then            Result := '''''';        exit(Result);    end;    procedure LocalDT2UTC(LocalDT: DateTime) UTC: DateTime    begin        if LocalDT <> 0DT then            UTC := ParseUTCString(Format(LocalDT, 0, 9))        else            UTC := 0DT;    end;    procedure UTC2LocalDT(UTC: DateTime) LocalDT: DateTime    var        UTCDifference: Duration;    begin        if UTC <> 0DT then begin            UTCDifference := UTC - LocalDT2UTC(UTC);            LocalDT := UTC + UTCDifference;        end else            LocalDT := 0DT;    end;    procedure UTCString2LocalDT(UTCString: Text) ResultDT: DateTime    var        UTC: DateTime;    begin        UTC := ParseUTCString(UTCString);        ResultDT := UTC2LocalDT(UTC);    end;    local procedure ParseUTCString(UTCString: Text) ResultDT: DateTime    var        Time: Time;        Year: Integer;        Month: Integer;        Day: Integer;        Hour: Integer;        Minute: Integer;        Sec: Integer;        Millisec: Integer;        PosDot: Integer;        PosZ: Integer;    begin        if UTCString = '' then            exit(0DT);        Evaluate(Year, CopyStr(UTCString, 1, 4));        Evaluate(Month, CopyStr(UTCString, 6, 2));        Evaluate(Day, CopyStr(UTCString, 9, 2));        Evaluate(Hour, CopyStr(UTCString, 12, 2));        Evaluate(Minute, CopyStr(UTCString, 15, 2));        Evaluate(Sec, CopyStr(UTCString, 18, 2));        PosDot := StrPos(UTCString, '.');        PosZ := StrPos(UTCString, 'Z');        if PosDot > 0 then            Evaluate(Millisec, CopyStr(UTCString, PosDot + 1, PosZ - PosDot - 1));        Evaluate(Time, StrSubstNo('%1:%2:%3.%4', Hour, Minute, Sec, Millisec));        ResultDT := CreateDateTime(DMY2Date(Day, Month, Year), Time);    end;    local procedure GetOptionCaption(TableId: Integer; FieldId: Integer) OptionCaption: Text    var        OptionRecordRef: RecordRef;        OptionFieldRef: FieldRef;    begin        OptionRecordRef.Open(TableId);        OptionFieldRef := OptionRecordRef.Field(FieldId);        OptionCaption := OptionFieldRef.OptionCaption;        OptionRecordRef.Close();    end;    procedure RunningUTC(): Boolean    var        DateTimeNow: DateTime;        EvalUTCTime: Time;        EvalTime: Time;        EvalDateTime: DateTime;        UTCHour: Text;        calculatedHour: Text;        UTCText: Text;        hourNumber: Integer;        UTChourNumber: Integer;    begin        DateTimeNow := CurrentDateTime;        // Documented format 9 is: 2003-04-05T03:35:55.553Z        // We only want the Time, so we need to get rid of Date and the ending Z        UTCText := Format(DateTimeNow, 0, 9);        UTCText := CopyStr(UTCText, StrPos(UTCText, 'T') + 1);        UTCText := DelChr(UTCText, '=', 'Z');        // Get only the current hour        Evaluate(EvalUTCTime, UTCText);        UTCHour := Format(EvalUTCTime);        UTCHour := CopyStr(UTCHour, 1, StrPos(UTCHour, ':') - 1);        Evaluate(UTChourNumber, UTCHour);        // Documented format 0 is: 05-04-03 4.35 (But this changes with settings)        // Get the Time only        Evaluate(EvalDateTime, Format(DateTimeNow, 0, 0));        EvalTime := DT2Time(EvalDateTime);        calculatedHour := Format(EvalTime);        calculatedHour := CopyStr(calculatedHour, 1, StrPos(calculatedHour, ':') - 1);        Evaluate(hourNumber, calculatedHour);        exit(hourNumber = UTChourNumber);    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeTextToDate(InputText: Text; var DateVar: Date; UseLocalTime: Boolean; var IsConverted: Boolean; var IsHandled: Boolean);    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeTextToDecimal(InputText: Text; var DecVar: Decimal; var IsConverted: Boolean; var IsHandled: Boolean);    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeTextToTime(InputText: Text; var TimeVar: Time; var UseLocalTime: Boolean; var IsConverted: Boolean; var IsHandled: Boolean);    begin    end;}