Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
1 contributor

Users who have contributed to this file

329 lines (196 sloc) 6.1 KB

Table of Contents

DecodeURI

The decodeURI() function decodes a Uniform Resource Identifier (URI) previously created by encodeURI() or by a similar routine.

Parameters

Examples

DecodeURI('my%20test.asp?name=st%C3%A5le&car=saab')  // returns 'my test.asp?name=ståle&car=saab'

Returns string

DecodeURIComponent

The decodeURIComponent() function decodes a Uniform Resource Identifier (URI) component previously created by encodeURIComponent or by a similar routine.

Parameters

Examples

EncodeURIComponent('https%3A%2F%2Fw3schools.com%2Fmy%20test.asp%3Fname%3Dst%C3%A5le%26car%3Dsaab')  // returns 'https://w3schools.com/my test.asp?name=ståle&car=saab'

Returns string

Decrypt

Decrypt a value.

Parameters

  • ciphertext string to decrypt, as generated by the Encrypt() function.
  • passphrase string to decrypt with. This must be the same passphrase that was used in Encrypt().

Examples

Decrypt(EncCreditCard, 'secret phrase')

Returns string unencrypted text.

EncodeURI

Encodes a Uniform Resource Identifier (URI).

Parameters

Examples

EncodeURI('my test.asp?name=ståle&car=saab')  // returns 'my%20test.asp?name=st%C3%A5le&car=saab'

Returns string

EncodeURIComponent

Encodes a Uniform Resource Identifier (URI) component.

Parameters

Examples

EncodeURIComponent('my test.asp?name=ståle&car=saab')  // returns 'my%20test.asp?name=st%C3%A5le&car=saab'

Returns string

Encrypt

Encrypt a value.

Parameters

  • plaintext string to encrypt.
  • passphrase string to encrpyt with.

Examples

Encrypt(CreditCard, 'secret phrase')

Returns string encrypted text.

ExampleAggregation

Sample of Aggregation FunctionType. Sums the value of a field, same as Qlik Sum().

Parameters

Returns number

ExampleScalar

Sample of Scalar FunctionType. Returns true if num1 GT num2, otherwise false

Parameters

Returns number boolean

ExampleTensor

Sample of Tensor FunctionType.

Aggregates column2 values by column1 dim values.

Same as script "LOAD Col1 as Dim, Sum(Col2) as Value FROM .. Group By Col1"

Parameters

  • tablename tabledescription {dim, value} - describing two fields, dim being Dimension, value is field to aggregate. See

Returns table table with two columns, "Dim", "Value"

ExtractHtmlText

Extracts text node contents from an HTML string.

Parameters

Returns string text - The text value, which should be the HTML string minus tag elements.

RegexTest

Tests a string for match with a regular expression.

Parameters

  • stringToTest string The string to test with the regular expression.
  • pattern string The regular expression pattern to use in the test.

Returns number boolean - 0 if false, -1 if true.

Reverse

Reverses the characters in a string.

Parameters

Examples

Reverse('Hello World')  // returns 'dlroW olleH'

Returns string

SortList

Sorts the elements of a string list into alphabetical order. Leading and trailing spaces are removed from the elements.

A string list is a string where the elements are separated by a common delimiter.

Parameters

Examples

SortList('John, Zack, Aaron', ',')  // returns 'Aaron,John,Zack'
SortList('John| Zack| Aaron' '|')  // returns 'Aaron|John|Zack'

Returns string text - The text value, which should be the HTML string minus tag elements.

Space

Replace multiple spaces between words with count spaces.

Parameters

Examples

Space('Sometimes    more than     one', 1)  // returns 'Sometimes more than one'

Returns string

You can’t perform that action at this time.