Apptigent PowerTools LITE (Community Edition) is a FREE suite of essential utilities for enterprise workflow, forms and cloud applications. Manipulate text, modify collections, format dates and times, convert currency, perform advanced mathematical calculations, shorten URL's, encode strings, and more. PowerTools is the ultimate power user toolkit - FREE!
Status: Preview |
Tier: Premium |
Version: 2020.3.14 |
Name |
Summary |
Name |
Summary |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Summary: Collections - Add to collection
Description: Add an item to a collection
Syntax:
ApptigentPowerToolsLITE.addToCollection ([Optional]inputCollectionModify collectionModify)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
collectionModify |
|
|
False |
Returns:
Summary: Collections - Remove from collection
Description: Remove an item from a collection
Syntax:
ApptigentPowerToolsLITE.removeFromCollection ([Optional]inputCollectionModify collectionModify)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
collectionModify |
|
|
False |
Returns:
Summary: Collections - Filter collection
Description: Filter a collection of strings by keyword
Syntax:
ApptigentPowerToolsLITE.filterCollection ([Optional]inputCollectionFilter collectionFilter)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
collectionFilter |
|
|
False |
Returns:
Summary: Collections - Sort collection
Description: Sort a collection of strings
Syntax:
ApptigentPowerToolsLITE.sortCollection ([Optional]inputCollectionSort collectionSort)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
collectionSort |
|
|
False |
Returns:
Summary: Collections - Count collection
Description: Count a collection of items
Syntax:
ApptigentPowerToolsLITE.countCollection ([Optional]inputCollectionCount collectionCount)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
collectionCount |
|
|
False |
Returns:
Type:outputNumber
Summary: Collections - Split collection
Description: Split a collection of items by matching value or index
Syntax:
ApptigentPowerToolsLITE.splitCollection ([Optional]inputCollectionSplit collectionSplit)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
collectionSplit |
|
|
False |
Returns:
Summary: Collections - Replace values in collection
Description: Replace whole or partial strings in a collection
Syntax:
ApptigentPowerToolsLITE.replaceValuesInCollection ([Optional]inputCollectionReplace collectionReplace)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
collectionReplace |
|
|
False |
Returns:
Summary: Collections - Contains string
Description: Determine if any items in a collection contain a specific string
Syntax:
ApptigentPowerToolsLITE.collectionContainsString ([Optional]inputCollectionSearch collectionSearch)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
collectionSearch |
|
|
False |
Returns:
Summary: Collections - Starts with string
Description: Determine if any items in a collection start with a specific string
Syntax:
ApptigentPowerToolsLITE.collectionStartsWithString ([Optional]inputCollectionSearch collectionSearch)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
collectionSearch |
|
|
False |
Returns:
Summary: Collections - Ends with string
Description: Determine if any items in a collection end with a specific string
Syntax:
ApptigentPowerToolsLITE.collectionEndsWithString ([Optional]inputCollectionSearch collectionSearch)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
collectionSearch |
|
|
False |
Returns:
Summary: Collections - Contains number
Description: Determine if a collection contains a specific number
Syntax:
ApptigentPowerToolsLITE.collectionContainsNumber ([Optional]inputCollectionSearchNumeric collectionSearch)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
collectionSearch |
|
|
False |
Returns:
Summary: DateTime - DateTime difference
Description: Calculate the difference between two dates
Syntax:
ApptigentPowerToolsLITE.dateTimeDifference ([Optional]inputDateTimeDifference dateTimeDifference)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
dateTimeDifference |
|
|
False |
Returns:
Type:outputDateDifference
Summary: DateTime - Format date and time
Description: Create a date/time string in a specific format
Syntax:
ApptigentPowerToolsLITE.formatDateTime ([Optional]inputDateTimeFormat dateTimeFormat)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
dateTimeFormat |
|
|
False |
Returns:
Type:outputString
Summary: DateTime - Get world time
Description: Convert date and time from one time zone to another
Syntax:
ApptigentPowerToolsLITE.worldTime ([Optional]inputDateTimeConversion dateTimeConversion)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
dateTimeConversion |
|
|
False |
Returns:
Type:outputString
Summary: Math - Calculate average
Description: Calculate the average of two or more numbers
Syntax:
ApptigentPowerToolsLITE.calculateAverage ([Optional]inputCalculateSeries calculateSeries)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
calculateSeries |
|
|
False |
Returns:
Type:outputNumber
Summary: Math - Calculate median
Description: Calculate the median of two or more numbers
Syntax:
ApptigentPowerToolsLITE.calculateMedian ([Optional]inputCalculateSeries calculateSeries)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
calculateSeries |
|
|
False |
Returns:
Type:outputNumber
Summary: Math - Calculate min or max
Description: Calculate the minimum or maximum value in a sequence of numbers
Syntax:
ApptigentPowerToolsLITE.calculateMinMax ([Optional]inputCalculateMinMax calculateSeries)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
calculateSeries |
|
|
False |
Returns:
Type:outputNumber
Summary: Math - Calculate sum
Description: Calculate the sum of two or more numbers
Syntax:
ApptigentPowerToolsLITE.calculateSum ([Optional]inputCalculateSeries calculateSeries)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
calculateSeries |
|
|
False |
Returns:
Type:outputNumber
Summary: Math - Calculate power
Description: Raise number to a specified power
Syntax:
ApptigentPowerToolsLITE.calculatePower ([Optional]inputCalculatePower calculatePower)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
calculatePower |
|
|
False |
Returns:
Type:outputNumber
Summary: Math - Calculate variance
Description: Calculate the statistical variance of two or more numbers
Syntax:
ApptigentPowerToolsLITE.calculateVariance ([Optional]inputCalculateSeries calculateSeries)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
calculateSeries |
|
|
False |
Returns:
Type:outputNumber
Summary: Math - Random number
Description: Generate a random number within a specified range
Syntax:
ApptigentPowerToolsLITE.randomNumber ([Optional]inputNumberRange numberRange)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
numberRange |
|
|
False |
Returns:
Type:outputNumber
Summary: Math - Round number
Description: Round a numeric value up or down
Syntax:
ApptigentPowerToolsLITE.roundNumber ([Optional]inputCalculateNumber calculateNumber)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
calculateNumber |
|
|
False |
Returns:
Type:outputNumber
Summary: Math - Calculate standard deviation
Description: Calculate the standard deviation of two or more numbers
Syntax:
ApptigentPowerToolsLITE.standardDeviation ([Optional]inputCalculateSeries calculateSeries)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
calculateSeries |
|
|
False |
Returns:
Type:outputNumber
Summary: Text - Compare strings
Description: Perform a comparison of two strings
Syntax:
ApptigentPowerToolsLITE.compareStrings ([Optional]inputStringComparison stringComparison)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
stringComparison |
|
|
False |
Returns:
Type:outputString
Summary: Text - Contains string
Description: Determine if a string contains another string
Syntax:
ApptigentPowerToolsLITE.containsString ([Optional]inputStringContains stringContains)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
stringContains |
|
|
False |
Returns:
Type:outputString
Summary: Text - Convert case
Description: Convert string to upper, lower or title case
Syntax:
ApptigentPowerToolsLITE.convertCase ([Optional]inputCaseConversion caseConversion)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
caseConversion |
|
|
False |
Returns:
Type:outputString
Summary: Text - Decode string
Description: Decode a string encoded with Base64 encoding
Syntax:
ApptigentPowerToolsLITE.decodeString ([Optional]decodeStringParameterStringInput stringInput)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
stringInput |
decodeStringParameterStringInput
|
|
False |
Returns:
Type:outputString
Summary: Text - Encode string
Description: Encode a string using Base64 encoding
Syntax:
ApptigentPowerToolsLITE.encodeString ([Optional]inputString stringInput)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
stringInput |
|
|
False |
Returns:
Type:outputString
Summary: Text - Generate GUID
Description: Generate a globally unique identifier
Syntax:
ApptigentPowerToolsLITE.generateGuid ([Optional]inputGenerateUniqueID generateUniqueID)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
generateUniqueID |
|
|
False |
Returns:
Type:outputString
Summary: Text - Join strings
Description: Join a collection of strings
Syntax:
ApptigentPowerToolsLITE.joinStrings ([Optional]inputJoinStrings joinStrings)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
joinStrings |
|
|
False |
Returns:
Type:outputString
Summary: Text - Redact string
Description: Redact a strng containing sensitive content
Syntax:
ApptigentPowerToolsLITE.redactString ([Optional]inputRedactString redactString)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
redactString |
|
|
False |
Returns:
Type:outputString
Summary: Text - Replace string
Description: Replace one value with another in a string
Syntax:
ApptigentPowerToolsLITE.replaceString ([Optional]inputReplaceString replaceString)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
replaceString |
|
|
False |
Returns:
Type:outputString
Summary: Text - Split string
Description: Split a string based upon one or more characters
Syntax:
ApptigentPowerToolsLITE.splitString ([Optional]inputSplitString splitString)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
splitString |
|
|
False |
Returns:
Type:outputStringArray
Summary: Text - Trim string
Description: Trim leading or trailing whitespace from a string
Syntax:
ApptigentPowerToolsLITE.trimString ([Optional]inputTrimString trimString)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
trimString |
|
|
False |
Returns:
Type:outputString
Summary: Text - Decode URL
Description: Decode an encoded URL
Syntax:
ApptigentPowerToolsLITE.urlDecode ([Optional]urlDecodeParameterStringInput stringInput)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
stringInput |
|
|
False |
Returns:
Type:outputString
Summary: Text - Encode URL
Description: Generate an encoded string from a complex hyperlink
Syntax:
ApptigentPowerToolsLITE.urlEncode ([Optional]inputString stringInput)
Parameters:
Name |
Type |
Summary |
Required |
Related Action |
stringInput |
|
|
False |
Returns:
Type:outputString
Summary:
Description:
Properties:
Name |
Type |
Summary |
source |
string Source |
Encoded string variable or text value |
Summary:
Description:
Properties:
Name |
Type |
Summary |
input |
array of (number) Values |
Colllection of values to calculate |
type |
string Min or Max |
Minimum or Maximum Values: [Minimum, Maximum] |
Summary:
Description:
Properties:
Name |
Type |
Summary |
input |
number Value |
Numeric value to calculate |
decimals |
number Decimal Places |
Round to number of decimal places |
Summary:
Description:
Properties:
Name |
Type |
Summary |
input |
number Number |
Number to raise |
power |
number Power |
Power |
decimals |
number Decimal Places |
Round to number of decimal places |
Summary:
Description:
Properties:
Name |
Type |
Summary |
input |
array of (number) Values |
Colllection of values to calculate |
decimals |
number Decimal Places |
Round to number of decimal places |
Summary:
Description:
Properties:
Name |
Type |
Summary |
input |
string Value |
String containing the text to convert |
alphacase |
string Case |
Case of conversion result Values: [Upper, Lower, Title] |
Summary:
Description:
Properties:
Name |
Type |
Summary |
input |
array of (string) Collection |
Collection of items to count |
Summary:
Description:
Properties:
Name |
Type |
Summary |
input |
array of (string) Collection |
Collection of strings to filter |
match |
string Match |
Match type Values: [Any, All, None] |
keywords |
string Keywords |
Keywords (separate multiple values with commas) |
Summary:
Description:
Properties:
Name |
Type |
Summary |
input |
array of (string) Collection |
Collection of values or objects to modify |
item |
string Item |
Item (for multiple items, leave blank and use Items) |
items |
array of (string) Items |
Items (Collection, for a single item leave blank and use Item) |
index |
string Index |
Index position for operation (leave blank to specify end of collection) |
Summary:
Description:
Properties:
Name |
Type |
Summary |
input |
array of (string) Collection |
Collection of strings |
match |
string Match value |
Match value |
replacement |
string Replacement value |
Replacement value |
ignoreCase |
string Ignore case |
Ignore case Values: [True, False] |
Summary:
Description:
Properties:
Name |
Type |
Summary |
input |
array of (string) Values |
Collection of strings to search |
match |
string Text |
Text to match |
trim |
string Trim |
Trim white space from comparison string Values: [True, False] |
ignorecase |
string Ignore Case |
Ignore case when performing comparison Values: [True, False] |
Summary:
Description:
Properties:
Name |
Type |
Summary |
input |
array of (number) Values |
Collection of strings to search |
match |
number Number |
Number to match |
type |
string Number Type |
Type of number - integer or decimal Values: [Integer, Decimal] |
Summary:
Description:
Properties:
Name |
Type |
Summary |
input |
array of (string) Collection |
Collection of strings to sort |
order |
string Order |
Sort order Values: [Ascending, Descending] |
Summary:
Description:
Properties:
Name |
Type |
Summary |
input |
array of (string) Collection |
Collection of items to split |
match |
string Match Value |
String to match (explicit, case-insensitive, leave empty to use Index) |
index |
string Index |
Index location to split (leave empty to use Match value) |
Summary:
Description:
Properties:
Name |
Type |
Summary |
input |
string Value |
Source date and time |
source |
string Source Time Zone |
Values: [GMT Standard Time - (GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London, Greenwich Standard Time - (GMT) Monrovia, Reykjavik, W. Europe Standard Time - (GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna, Central Europe Standard Time - (GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague, Central European Standard Time - (GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb, W. Central Africa Standard Time - (GMT+01:00) West Central Africa, GTB Standard Time - (GMT+02:00) Athens, Bucharest, Istanbul, Middle East Standard Time - (GMT+02:00) Beirut, Egypt Standard Time - (GMT+02:00) Cairo, South Africa Standard Time - (GMT+02:00) Harare, Pretoria, FLE Standard Time - (GMT+02:00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius, Israel Standard Time - (GMT+02:00) Jerusalem, E. Europe Standard Time - (GMT+02:00) Minsk, Namibia Standard Time - (GMT+02:00) Windhoek, Arabic Standard Time - (GMT+03:00) Baghdad, Arab Standard Time - (GMT+03:00) Kuwait, Riyadh, Russian Standard Time - (GMT+03:00) Moscow, St. Petersburg, Volgograd, E. Africa Standard Time - (GMT+03:00) Nairobi, Georgian Standard Time - (GMT+03:00) Tbilisi, Iran Standard Time - (GMT+03:30) Tehran, Arabian Standard Time - (GMT+04:00) Abu Dhabi, Muscat, Azerbaijan Standard Time - (GMT+04:00) Baku, Mauritius Standard Time - (GMT+04:00) Port Louis, Caucasus Standard Time - (GMT+04:00) Yerevan, Afghanistan Standard Time - (GMT+04:30) Kabul, Ekaterinburg Standard Time - (GMT+05:00) Ekaterinburg, Pakistan Standard Time - (GMT+05:00) Islamabad, Karachi, West Asia Standard Time - (GMT+05:00) Tashkent, India Standard Time - (GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi, Sri Lanka Standard Time - (GMT+05:30) Sri Jayawardenepura, Nepal Standard Time - (GMT+05:45) Kathmandu, N. Central Asia Standard Time - (GMT+06:00) Almaty, Novosibirsk, Central Asia Standard Time - (GMT+06:00) Astana, Dhaka, Myanmar Standard Time - (GMT+06:30) Yangon (Rangoon), SE Asia Standard Time - (GMT+07:00) Bangkok, Hanoi, Jakarta, North Asia Standard Time - (GMT+07:00) Krasnoyarsk, China Standard Time - (GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi, North Asia East Standard Time - (GMT+08:00) Irkutsk, Ulaan Bataar, Singapore Standard Time - (GMT+08:00) Kuala Lumpur, Singapore, W. Australia Standard Time - (GMT+08:00) Perth, Taipei Standard Time - (GMT+08:00) Taipei, Tokyo Standard Time - (GMT+09:00) Osaka, Sapporo, Tokyo, Korea Standard Time - (GMT+09:00) Seoul, Yakutsk Standard Time - (GMT+09:00) Yakutsk, Cen. Australia Standard Time - (GMT+09:30) Adelaide, AUS Central Standard Time - (GMT+09:30) Darwin, E. Australia Standard Time - (GMT+10:00) Brisbane, AUS Eastern Standard Time - (GMT+10:00) Canberra, Melbourne, Sydney, West Pacific Standard Time - (GMT+10:00) Guam, Port Moresby, Tasmania Standard Time - (GMT+10:00) Hobart, Vladivostok Standard Time - (GMT+10:00) Vladivostok, Central Pacific Standard Time - (GMT+11:00) Magadan, Solomon Is., New Caledonia, New Zealand Standard Time - (GMT+12:00) Auckland, Wellington, Fiji Standard Time - (GMT+12:00) Fiji, Kamchatka, Marshall Is., Tonga Standard Time - (GMT+13:00) Nuku'alofa, Azores Standard Time - (GMT-01:00) Azores, Cape Verde Standard Time - (GMT-01:00) Cape Verde Is., Mid-Atlantic Standard Time - (GMT-02:00) Mid-Atlantic, E. South America Standard Time - (GMT-03:00) Brasilia, Argentina Standard Time - (GMT-03:00) Buenos Aires, SA Eastern Standard Time - (GMT-03:00) Georgetown, Greenland Standard Time - (GMT-03:00) Greenland, Montevideo Standard Time - (GMT-03:00) Montevideo, Newfoundland Standard Time - (GMT-03:30) Newfoundland, Atlantic Standard Time - (GMT-04:00) Atlantic Time (Canada), SA Western Standard Time - (GMT-04:00) La Paz, Central Brazilian Standard Time - (GMT-04:00) Manaus, Pacific SA Standard Time - (GMT-04:00) Santiago, Venezuela Standard Time - (GMT-04:30) Caracas, SA Pacific Standard Time - (GMT-05:00) Bogota, Lima, Quito, Rio Branco, Eastern Standard Time - (GMT-05:00) Eastern Time (US & Canada), US Eastern Standard Time - (GMT-05:00) Indiana (East), Central America Standard Time - (GMT-06:00) Central America, Central Standard Time - (GMT-06:00) Central Time (US & Canada), Central Standard Time (Mexico) - (GMT-06:00) Guadalajara, Mexico City, Monterrey, Canada Central Standard Time - (GMT-06:00) Saskatchewan, US Mountain Standard Time - (GMT-07:00) Arizona, Mountain Standard Time (Mexico) - (GMT-07:00) Chihuahua, La Paz, Mazatlan, Mountain Standard Time - (GMT-07:00) Mountain Time (US & Canada), Pacific Standard Time - (GMT-08:00) Pacific Time (US & Canada), Pacific Standard Time (Mexico) - (GMT-08:00) Tijuana, Baja California, Alaskan Standard Time - (GMT-09:00) Alaska, Hawaiian Standard Time - (GMT-10:00) Hawaii, Samoa Standard Time - (GMT-11:00) Midway Island, Samoa, Dateline Standard Time - (GMT-12:00) International Date Line West] |
target |
string Target Time Zone |
Values: [GMT Standard Time - (GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London, Greenwich Standard Time - (GMT) Monrovia, Reykjavik, W. Europe Standard Time - (GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna, Central Europe Standard Time - (GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague, Central European Standard Time - (GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb, W. Central Africa Standard Time - (GMT+01:00) West Central Africa, GTB Standard Time - (GMT+02:00) Athens, Bucharest, Istanbul, Middle East Standard Time - (GMT+02:00) Beirut, Egypt Standard Time - (GMT+02:00) Cairo, South Africa Standard Time - (GMT+02:00) Harare, Pretoria, FLE Standard Time - (GMT+02:00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius, Israel Standard Time - (GMT+02:00) Jerusalem, E. Europe Standard Time - (GMT+02:00) Minsk, Namibia Standard Time - (GMT+02:00) Windhoek, Arabic Standard Time - (GMT+03:00) Baghdad, Arab Standard Time - (GMT+03:00) Kuwait, Riyadh, Russian Standard Time - (GMT+03:00) Moscow, St. Petersburg, Volgograd, E. Africa Standard Time - (GMT+03:00) Nairobi, Georgian Standard Time - (GMT+03:00) Tbilisi, Iran Standard Time - (GMT+03:30) Tehran, Arabian Standard Time - (GMT+04:00) Abu Dhabi, Muscat, Azerbaijan Standard Time - (GMT+04:00) Baku, Mauritius Standard Time - (GMT+04:00) Port Louis, Caucasus Standard Time - (GMT+04:00) Yerevan, Afghanistan Standard Time - (GMT+04:30) Kabul, Ekaterinburg Standard Time - (GMT+05:00) Ekaterinburg, Pakistan Standard Time - (GMT+05:00) Islamabad, Karachi, West Asia Standard Time - (GMT+05:00) Tashkent, India Standard Time - (GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi, Sri Lanka Standard Time - (GMT+05:30) Sri Jayawardenepura, Nepal Standard Time - (GMT+05:45) Kathmandu, N. Central Asia Standard Time - (GMT+06:00) Almaty, Novosibirsk, Central Asia Standard Time - (GMT+06:00) Astana, Dhaka, Myanmar Standard Time - (GMT+06:30) Yangon (Rangoon), SE Asia Standard Time - (GMT+07:00) Bangkok, Hanoi, Jakarta, North Asia Standard Time - (GMT+07:00) Krasnoyarsk, China Standard Time - (GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi, North Asia East Standard Time - (GMT+08:00) Irkutsk, Ulaan Bataar, Singapore Standard Time - (GMT+08:00) Kuala Lumpur, Singapore, W. Australia Standard Time - (GMT+08:00) Perth, Taipei Standard Time - (GMT+08:00) Taipei, Tokyo Standard Time - (GMT+09:00) Osaka, Sapporo, Tokyo, Korea Standard Time - (GMT+09:00) Seoul, Yakutsk Standard Time - (GMT+09:00) Yakutsk, Cen. Australia Standard Time - (GMT+09:30) Adelaide, AUS Central Standard Time - (GMT+09:30) Darwin, E. Australia Standard Time - (GMT+10:00) Brisbane, AUS Eastern Standard Time - (GMT+10:00) Canberra, Melbourne, Sydney, West Pacific Standard Time - (GMT+10:00) Guam, Port Moresby, Tasmania Standard Time - (GMT+10:00) Hobart, Vladivostok Standard Time - (GMT+10:00) Vladivostok, Central Pacific Standard Time - (GMT+11:00) Magadan, Solomon Is., New Caledonia, New Zealand Standard Time - (GMT+12:00) Auckland, Wellington, Fiji Standard Time - (GMT+12:00) Fiji, Kamchatka, Marshall Is., Tonga Standard Time - (GMT+13:00) Nuku'alofa, Azores Standard Time - (GMT-01:00) Azores, Cape Verde Standard Time - (GMT-01:00) Cape Verde Is., Mid-Atlantic Standard Time - (GMT-02:00) Mid-Atlantic, E. South America Standard Time - (GMT-03:00) Brasilia, Argentina Standard Time - (GMT-03:00) Buenos Aires, SA Eastern Standard Time - (GMT-03:00) Georgetown, Greenland Standard Time - (GMT-03:00) Greenland, Montevideo Standard Time - (GMT-03:00) Montevideo, Newfoundland Standard Time - (GMT-03:30) Newfoundland, Atlantic Standard Time - (GMT-04:00) Atlantic Time (Canada), SA Western Standard Time - (GMT-04:00) La Paz, Central Brazilian Standard Time - (GMT-04:00) Manaus, Pacific SA Standard Time - (GMT-04:00) Santiago, Venezuela Standard Time - (GMT-04:30) Caracas, SA Pacific Standard Time - (GMT-05:00) Bogota, Lima, Quito, Rio Branco, Eastern Standard Time - (GMT-05:00) Eastern Time (US & Canada), US Eastern Standard Time - (GMT-05:00) Indiana (East), Central America Standard Time - (GMT-06:00) Central America, Central Standard Time - (GMT-06:00) Central Time (US & Canada), Central Standard Time (Mexico) - (GMT-06:00) Guadalajara, Mexico City, Monterrey, Canada Central Standard Time - (GMT-06:00) Saskatchewan, US Mountain Standard Time - (GMT-07:00) Arizona, Mountain Standard Time (Mexico) - (GMT-07:00) Chihuahua, La Paz, Mazatlan, Mountain Standard Time - (GMT-07:00) Mountain Time (US & Canada), Pacific Standard Time - (GMT-08:00) Pacific Time (US & Canada), Pacific Standard Time (Mexico) - (GMT-08:00) Tijuana, Baja California, Alaskan Standard Time - (GMT-09:00) Alaska, Hawaiian Standard Time - (GMT-10:00) Hawaii, Samoa Standard Time - (GMT-11:00) Midway Island, Samoa, Dateline Standard Time - (GMT-12:00) International Date Line West] |
format |
string Format |
Display format (defaults to 'yyyy-MM-dd HH:mm:ss') |
Summary:
Description:
Properties:
Name |
Type |
Summary |
dateTime1 |
string First date/time value |
First date/time value |
dateTime2 |
string Second date/time value |
Second date/time value |
Summary:
Description:
Properties:
Name |
Type |
Summary |
input |
string Value |
Source date and time |
culture |
string Culture |
Language culture Values: [en-US, af-ZA, ar-AE, ar-BH, ar-DZ, ar-EG, ar-IQ, ar-JO, ar-KW, ar-LB, ar-LY, ar-MA, ar-OM, ar-QA, ar-SA, ar-SY, ar-TN, ar-YE, az-AZ, be-BY, bg-BG, bs-BA, ca-ES, cs-CZ, cy-GB, da-DK, de-AT, de-CH, de-DE, de-LI, de-LU, el-GR, en-AU, en-BZ, en-CA, en-CB, en-GB, en-IE, en-JM, en-NZ, en-PH, en-TT, en-ZA, en-ZW, es-AR, es-BO, es-CL, es-CO, es-CR, es-DO, es-EC, es-ES, es-GT, es-HN, es-MX, es-NI, es-PA, es-PE, es-PR, es-PY, es-SV, es-UY, es-VE, et-EE, eu-ES, fa-IR, fi-FI, fo-FO, fr-BE, fr-CA, fr-CH, fr-FR, fr-LU, fr-MC, gl-ES, gu-IN, he-IL, hi-IN, hr-BA, hr-HR, hu-HU, hy-AM, id-ID, is-IS, it-CH, it-IT, ja-JP, ka-GE, kk-KZ, kn-IN, ko-KR, ky-KG, lt-LT, lv-LV, mi-NZ, mn-MN, mr-IN, ms-BN, ms-MY, mt-MT, nl-BE, nl-NL, nn-NO, ns-ZA, pa-IN, pl-PL, ps-AR, pt-BR, pt-PT, ro-RO, ru-RU, sa-IN, sk-SK, sl-SI, sq-AL, sr-BA, sr-SP, sv-FI, sv-SE, sw-KE, ta-IN, te-IN, th-TH, tl-PH, tn-ZA, tr-TR, uk-UA, ur-PK, uz-UZ, vi-VN, zh-CN, zh-HK, zh-MO, zh-SG, zh-TW, zu-ZA] |
format |
string Format |
Output format |
Summary:
Description:
Properties:
Name |
Type |
Summary |
uppercase |
string Uppercase |
All uppercase alpha characters Values: [True, False] |
Summary:
Description:
Properties:
Name |
Type |
Summary |
input |
array of (string) Values |
Collection of strings to be joined |
separator |
string Separator |
Separator character |
lower |
string Lowercase |
Convert strings in collection to lowercase Values: [True, False] |
trim |
string Trim |
Trim strings in collection Values: [True, False] |
Summary:
Description:
Properties:
Name |
Type |
Summary |
start |
number Start |
Start of range |
end |
number End |
End of range |
Summary:
Description:
Properties:
Name |
Type |
Summary |
value |
string Value |
Individual string to redact |
source |
string Source String |
String containing the complete text |
values |
array of (string) -OR- Values |
Collection of strings to redact |
Summary:
Description:
Properties:
Name |
Type |
Summary |
source |
string Source |
String containing the text to be replaced |
value |
string Value |
Text to replace |
replacement |
string Replacement |
Replacement text |
Summary:
Description:
Properties:
Name |
Type |
Summary |
input |
string Value |
Text to split |
characters |
string Character(s) |
One or more characters that will be used to split the text |
Summary:
Description:
Properties:
Name |
Type |
Summary |
source |
string Source |
String variable or text value |
Summary:
Description:
Properties:
Name |
Type |
Summary |
input |
string Source |
Original string |
compare |
string Target |
Comparison string |
lower |
string Lowercase |
Convert strings to lowercase before comparison Values: [True, False] |
trim |
string Trim |
Trim strings before comparison Values: [True, False] |
Summary:
Description:
Properties:
Name |
Type |
Summary |
find |
string Value |
Text to match |
input |
string Target |
Text to search |
lower |
string Lowercase |
Convert strings to lowercase Values: [True, False] |
Summary:
Description:
Properties:
Name |
Type |
Summary |
source |
string Source |
String containing the text to be trimmed |
type |
string Type |
Type of white space to remove Values: [Start, End, Both] |
Summary:
Description:
Properties:
Name |
Type |
Summary |
status |
boolean Success |
Success |
item |
number First Match |
First matching value |
items |
array of (number) All Matches |
All matching values |
Summary:
Description:
Properties:
Name |
Type |
Summary |
result |
array of (string) Modified collection result |
Modified collection result |
Summary:
Description:
Properties:
Name |
Type |
Summary |
status |
boolean Success |
Success |
item |
string First Value |
First Value |
items |
array of (string) All Values |
All Values |
Summary:
Description:
Properties:
Name |
Type |
Summary |
years |
number Years |
Years |
months |
number Months |
Months |
days |
number Days |
Days |
hours |
number Hours |
Hours |
minutes |
number Minutes |
Minutes |
milliseconds |
number Milliseconds |
Milliseconds |
totalYears |
number(double) Total Years |
Total Years |
totalMonths |
number(double) Total Months |
Total Months |
totalDays |
number(double) Total Days |
Total Days |
totalHours |
number(double) Total Hours |
Total Hours |
totalMinutes |
number(double) Total Minutes |
Total Minutes |
totalSeconds |
number(double) Total Seconds |
Total Seconds |
totalMilliseconds |
number(double) Total Milliseconds |
Total Milliseconds |
ticks |
number Ticks |
Ticks |
Summary:
Description:
Properties:
Name |
Type |
Summary |
result1 |
array of (string) First collection result |
First collection result |
result2 |
array of (string) Second collection result |
Second collection result |
Summary:
Description:
Properties:
Name |
Type |
Summary |
result |
number Result |
Result |
Summary:
Description:
Properties:
Name |
Type |
Summary |
result |
string Result |
Result |
Summary:
Description:
Properties:
Name |
Type |
Summary |
data |
array of (string) data |
data |
Summary:
Description:
Properties:
Name |
Type |
Summary |
source |
string Source |
Encoded string variable or text value |