Blue Prism Certification Exam Practice Solutions Graded A+

Concatenation. Using " & " to join text together either in " " or inside a data item. StartsWith() Function Correct Answer: Function that takes 2 separate values and compares them. I.E StartsWith("Example", "ple") will return FALSE "Exa" will return TRUE. EndsWith() Function Correct Answer: Function that takes 2 separate values and compares them. I.E EndsWith("Example", "ple") will return TRUE "Exa" will return FALSE. Mid() Calculation Correct Answer: Gets text taken from the middle of the text expression. Start point is a numerical value to give the starting position. Length is how many characters from the starting position you would like to include. Left() Function Correct Answer: Gets text taken from the left of a text expression I.E Left("Example", 3) = "Exa" Right() Function Correct Answer: Gets text taken from the Right of a text expression Right("Example", 3) = "ple" Trim Function Correct Answer: Removes blanks and empty spaces in text data item. ToNumber() Correct Answer: Converts text value to a number & " " Correct Answer: Ampersand w/ quotation marks converts a number to a text [Number] & "" ToDate() Function Correct Answer: Converts a value to a date. ToDateTime() Function Correct Answer: Converts a value to a datetime. Default is 12:00:00 ToDays(TimeSpan) Function Correct Answer: Converts a TimeSpan to a whole number of days, rounded down. ToHours(TimeSpan) Function Correct Answer: Converts a timespan to a whole number of hours, rounded down. ToMinutes(TimeSpan) Function Correc