# TEXT

| Function     | Example call                               | Expected result        |
| ------------ | ------------------------------------------ | ---------------------- |
| CHAR         | CHAR(65)                                   | A                      |
| CLEAN        | CLEAN('Monthly report')                    | Monthly report         |
| CODE         | CODE('A')                                  | 65                     |
| CONCATENATE  | CONCATENATE('Andreas', ' ', 'Hauser')      | Andreas Hauser         |
| EXACT        | EXACT('Word', 'word')                      | FALSE                  |
| FIND         | FIND('M', 'Miriam McGovern', 3)            | 8                      |
| LEFT         | LEFT('Sale Price', 4)                      | Sale                   |
| LEN          | LEN('Phoenix, AZ')                         | 11                     |
| LOWER        | LOWER('E. E. Cummings')                    | e. e. cummings         |
| MID          | MID('Fluid Flow', 7, 20)                   | Flow                   |
| NUMBERVALUE  | NUMBERVALUE('2.500,27', ',', '.')          | 2500.27                |
| PROPER       | PROPER('this is a TITLE')                  | This Is A Title        |
| REGEXEXTRACT | REGEXEXTRACT('Palo Alto', 'Alto')          | Alto                   |
| REGEXMATCH   | REGEXMATCH('Palo Alto', 'Alto')            | TRUE                   |
| REGEXREPLACE | REGEXREPLACE('Sutoiku', 'utoiku', 'TOIC')  | STOIC                  |
| REPLACE      | REPLACE('abcdefghijk', 6, 5, '\*')         | abcde\*k               |
| REPT         | REPT('\*-', 3)                             | \*-\*-\*-              |
| RIGHT        | RIGHT('Sale Price', 5)                     | Price                  |
| ROMAN        | ROMAN(499)                                 | CDXCIX                 |
| SEARCH       | SEARCH('margin', 'Profit Margin')          | 8                      |
| SPLIT        | SPLIT('A,B,C', ',')                        | A,B,C                  |
| SUBSTITUTE   | SUBSTITUTE('Quarter 1, 2011', '1', '2', 3) | Quarter 1, 2012        |
| T            | T('Rainfall')                              | Rainfall               |
| TRIM         | TRIM(' First Quarter Earnings ')           | First Quarter Earnings |
| UNICHAR      | UNICHAR(66)                                | B                      |
| UNICODE      | UNICODE('B')                               | 66                     |
| UPPER        | UPPER('total')                             | TOTAL                  |