Personal tools

Log in

Changes

From All n One's bxp software Wixi

Jump to: navigation, search

MetaData Process Rules

12 bytes added, 17:45, 12 March 2013
no edit summary
* Subtract
* Multiply
* Divide - Divide by 0 is always calculated to 0 for reporting purposes* Modulus - Modulus maths, leaves the remainder* Positive - Always makes a value positive* Numeric - Forces the value to be numeric. Defaults to 0 if string or unrecognised* Boolean - Forces the value to be Boolean. Defaults to false if unrecognised.
= String Functions=* Replace - Replaces one string with another* RemoveNumbers - Removes all numbers from the values* Trim - Removes leading and trailing spaces* TitleCase - Used for tidying up names. Capitalises the first letter of each word.* SentenceCase - Reformats the data into sentence case.* Concat - Combines two strings in the order supplied* Encapsulate - Surround a string with the values provided* Fixed - Extracts a fixed amount from the string* Append - Add to the end of the string* Prepend - Add to the start of the string
==Date | Time Functions== * DateTime - Format the time in Universal Date Time format yyyy-mm-dd hh:mm:ss* Date - yyyy-mm-dd only* Time - hh:mm:ss only* Zulu - Zyyyy-mm-ddThh:mm:ss* ReportTimeToSeconds - Converts report time to a seconds value* TimeToSeconds - For normal dates, convert to a base second time for comparisons* SecondsToReportTime - When using comparison dates, after subtractions, converts to a report time format* Percentage - Divide 1 by 2, output formatted number * 100, limit to 2 decimal places
===Data Cumulative Functions===
* Sum
* Count
Data Transformation Functions==========================Data Transformation Functions ====
* Convert_Title
* Convert_County
7,528
edits