{"id":42991,"date":"2018-11-22T15:21:29","date_gmt":"2018-11-22T09:51:29","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=42991"},"modified":"2018-11-21T12:24:34","modified_gmt":"2018-11-21T06:54:34","slug":"qlik-sense-string-functions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-string-functions\/","title":{"rendered":"Qlik Sense String Functions – Syntax and Example"},"content":{"rendered":"

1. Objective<\/span><\/h2>\n

Earlier, we have discussed Qlik Sense Formatting Functions<\/strong><\/a>. Today, we will see the Qlik Sense String Functions Tutorial. The Qlik Sense String Functions are applied to the strings or text values used in data load scripts. We use these String Functions of Qlik Sense to manage and handle the string values. Qlik Sense comes with a number of string functions which are important for us to understand.<\/span><\/p>\n

So, let’s start Qlik Sense String Functions.<\/p>\n

\"Qlik<\/a>

Qlik Sense String Functions – Syntax and Example<\/p><\/div>\n

Recommended Reading –<\/strong> Qlik Sense Interpretation Function<\/a><\/strong><\/p>\n

2. Qlik Sense String Functions<\/h2>\n

Following are the Qlik Sense String Functions, let’s discuss them in detail –<\/p>\n

i. Capitalize<\/span><\/h3>\n

The capitalize function returns a string with each word of the string starting with a capital letter. <\/span><\/p>\n

The syntax for Capitalize Qlik Sense String Functions:<\/strong><\/p>\n

Capitalize(text)<\/pre>\n
For instance, <\/span><\/p>\n
Capitalize(‘lesson string functions’)<\/span> returns the string \u2018Lesson String Functions\u2019.<\/span><\/p>\n
ii. Chr<\/span><\/h3>\n
The chr function returns the Unicode character corresponding to the integer you have entered in the expression. <\/span><\/p>\n
The syntax for chr Qlik Sense String Functions:<\/strong><\/p>\n
Chr(int)<\/pre>\n
For instance, in the expression given below, the chr() function will return the alphabet corresponding to the integer entered in the expression following the standard code (ASCII).<\/span><\/p>\n
Chr(65)<\/span> returns the letter \u2018A\u2019 as a string, or,<\/span><\/p>\n
Chr(90)<\/span> returns the letter \u2018Z\u2019 as a string. <\/span><\/p>\n
iii. Evaluate<\/span><\/h3>\n
This function checks an input value in the expression for whether it can be evaluated in some or not. If it involves the evaluation of some kind then this function returns the value after evaluation. It returns the values in dual data format. If there is no evaluation in the expression then NULL is returned.<\/span><\/p>\n
You must read – Qlik Sense Null Functions<\/a><\/strong><\/p>\n
The syntax for\u00a0Evaluate Qlik Sense String Functions :<\/strong><\/p>\n
Evaluate(expression_text)<\/pre>\n
For instance, <\/span><\/p>\n
Evaluate( 5 * 8 )<\/span> will return the value \u201840\u2019. Or,<\/span><\/p>\n
Evalute(600\/10)<\/span> will return the value \u201960\u2019. <\/span><\/p>\n
iv. FindOneOf<\/span><\/h3>\n
The findoneof() function returns the position of the characters attained as search result which it encounters while searching for a set of characters. <\/span><\/p>\n
The syntax for FindOneOf Qlik Sense String Functions:<\/strong><\/p>\n
FindOneOf(text, char_set[, count])<\/pre>\n
Where, <\/span>text<\/span> is the text string in which you want to search the character set.<\/span><\/p>\n
char_set<\/span> is the set of characters which you want to be searched.<\/span><\/p>\n
count<\/span> is for counting the position number or occurrence of a certain character from the character set. <\/span><\/p>\n
For instance, <\/span><\/p>\n
FindOneOf(‘my example text string’, ‘et%s’, 3)<\/span> will return the value ’12’ because the search is for any of the characters: e, t, % or s, and the character “t” is the third occurrence, and is in position 12.<\/span><\/p>\n
v. Hash128<\/span><\/h3>\n
This function returns a 128-bit hash value corresponding to the value or string entered in the expression. The value usually returned is a 22-character long string value which is a combined 128-bit version of all the values that you have entered.<\/span><\/p>\n
Get a deeper knowledge of Qlik Sense Mapping Functions<\/a><\/strong><\/p>\n
The syntax of Qlik Sense Hash128 String Functions:<\/strong><\/p>\n
Hash128(expr{, expression})<\/pre>\n
For instance, the expressions given below, will return a 128-bit hash value combining all the individual strings and store it in the system. <\/span><\/p>\n