What Cake Boss Uses For Water

Using functions Create text books

In this post I will explain about the use of text functions: FIND, LEFT, RIGHT, LONG. Applying for the extraction of words from a string separated by some character. In this case spaces.

FIND (texto_a_buscar; cadena_donde_buscar)
use this feature is simple, find a string or character within another string, and takes you to the place where is located the search text string within the cuestón.

LEFT (numero_entero; cadena_de_texto)
Returns a string consisting of characters that is to the left of the place indicated by numero_entero. RIGHT applies similarly, but in reverse.

LENGTH (cadena_de_texto)
Returns the number of characters in a string of text includes blank spaces may be before or after the string.

In the example below, download here, you can see the implementation of these functions to extract the words from a string separated by spaces.