Format

Small formatting adjustments can make a huge difference in your data. Using Boltic format text transformation types such as Uppercase, Lowercase, and Trim, you can quickly enhance the appearance of your queried data. Changing default formats, including its case, and removing both leading and trailing spaces from texts, will make the dataset cleaner.

Let's say we run the following transformations on a text value which is " x Yz ", you can see the value in the result column here.

Transformation Type	Description	Result
To Uppercase	Converts any lowercase letters in the string to uppercase.	" X YZ "
To Lowercase	Converts any uppercase letters in the string to lowercase.	" x yz "
Trim	Strips extra spaces from text	"xyz"