This function allows you to select columns with integers, floating point numbers and columns with a date format and convert them to a text column.
Change a column value to an integer
The function allows you to select text columns and convert them to a column of integers. If the record value cannot be converted, it will be deleted
Change a column value to a decimal number
This function allows you to select text columns and convert them to a column of floating point numbers. If the record value cannot be converted, it will be deleted
Operations on columns
Capital letters
‘a’ returns ‘A’
Convert letters to lowercase
‘A’ returns ‘a’
Return the length of the text
The function allows you to select text columns and count the number of characters in a cell
Round a floating point number up
The function rounds numbers up so 10.9876 is 11
Round a floating point number down
The function rounds numbers down so 10.9876 is 10
Round to the specified number of decimal places
If the value is positive, the number is rounded to the specified number of decimal places, (10.9934,2) – returns 10.99, (10.9964,2) – returns 11.00. If the number is negative, the entered value is rounded to the left of the decimal point, (111.0, -2) returns 100.00
Position
Returns the position of the first occurrence of the specified substring in the specified string. If the specified substring is not found, the result is 0. (‘boat’, ‘Sailboat’) – the result is 5. (‘motor’, ‘Sailboat’) – the result is 0.
Search for text string - Returns part of a string value
Search for a text string – returns part of a string value Returns part of a string value is an integer index specifying where the returned characters begin and <length> is the number of characters returned (Sailboat, 5,4) -> boat
Trim
This function allows you to cut a given word from the columns
This function allows you to cut a given word from the columns
Changes the selected string of characters, e.g. “w” to another selected string, e.g. “s”