Converter_descriptions

AddOneConverter: Returns source value + 1 (if source value is number, else returns blank).

AdjustDoubleStringValue: Rounds a source value to 6 decimal places.

ConcentrationCodeDescConverter: Locates the “Code” in the ConcentrationCode list corresponding to the source value and returns the “Description” value.

ConcentrationConverter: If SampleCondition equal “OK” do nothing, else return “NSR.”

ConcentrationUnitConverter: Using source value (first value), returns second value from the dictionary:

    { "uM", "umol/L" },
    { "fM", "fmol/L" },
    { "M", "mol/L" },
    { "mM", "mmol/L" },
    { "pM", "pmol/L" },
    { "nM", "nmol/L" }

Example: If source value = “uM”, converter returns “umol/L.”

DaysToDaysHoursMinutes: Converts from days to days:hours:minutes (DD:HH:MM).

DaysToWeekConverter: Converts from days to week.

DoseTimeToDayConverter: Converts source value (if not blank) to:

minutes if “Time_Units” = “MIN” in this row

hours if “Time_Units” = “HR” or “H” in this row

days if “Time_Units” = “DAY” or “D” in this row

DoseToDayConverter: If source value contains “D” (or “d”), removes “D” and returns the result, if it is a number. Else returns DBNull (blank).

DosingDoseTimeConverter: If source value is a string, returns “0.” Else returns the source value number.

DoubleStringValueConverter: Rounds a source value to 15 decimal places.

ExtractDay: Converts Period and Day string value to the Day value only (numeric).

Expression: (\d+)

ExtractGroupID: Returns only digitals, “,” and “-” without characters and spaces.

Example: If source value = “G1,2-3”, returns “1,2-3”

ExtractPeriod: Converts Period and Day string value to the Period value only (numeric), else returns blank.

Expression: “(?<=^PERIOD\\s)(\\d+)”

Example: If source value = “PERIOD 23”, returns "23"

ExtractPeriodC: Converts Period and Day string value to the Period value, else returns blank.

Expression: “(?=^PERIOD\\s\\d+)^PERIOD\\s\\d+”

Example: If source value = “PERIOD 23”, returns “PERIOD 23”

HoursToDaysHoursMinutes: Converts from hours to days:hours:minutes (DD:HH:MM).

HoursToHoursMinutes: Converts from hours to hours:minutes (HH:MM).

IsoDurationToDays: Converts ISO time representations to a duration (time and unit) day.

IsoDurationToHours: Converts ISO time representations to a duration (time and unit) hours.

PlusOne: Returns source value + 1 (if source value is a number) or will try to convert from string to a number. Else returns null.

RemoveTauForDayOne: If “AnalysisDay” = “1” in source row, returns NaN, else returns the source value.

SampleConditionConverter: If source value does not equal “OK” (case insensitive), returns “NSR”, else returns the source value.

TimeToNominalTimeConverter: Converts source value (if not blank) to:

minutes if “Time_Units” = “MIN” in this row

hours if “Time_Units” = “HR" or “H” in this row

days if “Time_Units” = “DAY" or “D” in this row

TimeUnitConverter: Always returns “h”.

ToUpper: Returns the string converted to uppercase.

UniqueAnalyteConverter: If source column has only one unique value, returns this unique value, else returns the source value. Can be used if some values in the column are blank and a unique value must be set.

UseUnitFromSourceColumn: Returns the unit from the source column.