List of Available Functions

General Functionality

• A triple will not be generated if the subject or object is provided will a NULL value.

• Strings passed into functions may be sourced from

  • References (The entire value of a field in the source document)

  • Templates (A string that includes values of fields in the source document, as well as manually specified strings)

  • Outputs from other Functions (Functions may therefore be nested)

Prefixes

In order to make use of the below functions, you must include the following prefixes in your mapping files:

@prefix fnml: <http://semweb.mmlab.be/ns/fnml#> .
@prefix fno: <https://w3id.org/function/ontology#> .
@prefix grel: <http://users.ugent.be/~bjdmeest/function/grel.ttl#> .

Custom Graph.Build Functions

ifEqual

• Description: If a value equals and expected value, return if else that

• Required Parameters:

  • Input - Input text

  • String1 - Value to be equal to

  • String2 - If equal return this value

  • String3 - If not equal return this value

• Returns: String3 if input equals String1, otherwise return String2

toPascalCase

• Description: Returns as value as PascalCase

• Required Parameters:

  • Input - Input text

• Returns: Input as PascalCase

toCamelCase

• Description: Returns as value as camelCase

• Required Parameters:

  • Input - Input text

• Returns: Input as camelCase

toKebabCase

• Description: Returns as value as kebab-case

• Required Parameters:

  • Input - Input text

• Returns: Input as kebab-case

toScreamingSnakeCase

• Description: Returns as value as SCREAMING_SNAKE_CASE

• Required Parameters:

  • Input - Input text

• Returns: Input as SCREAMING_SNAKE_CASE

toSnakeCase

• Description: Returns as value as snake_case

• Required Parameters:

  • Input - Input text

• Returns: Input as snake_case

unixEpochConverter

• Description: Reads a long representing unix time to xsd:date

• Required Parameters:

  • Input - Input text

  • String1 - days, seconds, milliseconds (default)

• Returns: a unix time conversion

existsThen

• Description: Takes an input value and if it is not null, return the output value

• Required Parameters:

  • Input - Input text

  • String1 - value to return when not null

• Returns: String1 when not null, otherwise null

removeEqualValues

• Description: Returns NULL if Input is equal to any of the values in String1

• Use Case: Don’t generate a triple if the value in the source data is ‘None’ or N/A

• Required Parameters:

  • Input - Input text

  • String1 - Delimited list of values

• Returns: Input or NULL

findAndReplace

• Description: Find part or all of the first input value from a list of regex, provided by the second input of comma separated values, and replace with its respective value from the third input of comma separated values

• Use Case: Remove undesirable values from within field data.

• Expects:

  • Input - Input text

  • String1 - Regex find values

  • String2 - Regex replace values

• Returns: Input, where matched values from String1 are replaced with corresponding values from String2

removeAllDoubleQuotes

• Description: Returns the input with all double quotes removed

• Use Case: Remove unnecessary double quotation marks from within field data.

• Expects:

  • Input- Input text

• Returns: Input with all double quotation marks have been removed.

translateToISODate

• Description: Allows valid xsd:date values to be generated from non ISO standard date formats.

• Use Case: The source data provides a date, but it’s not in xsd:date format.

• Expects:

  • YearString - Delimited list containing

    • Input - Input text

    • StartPosition - Which position to start from, relative to the beginning on the Input text

    • CharacterCount - Number of characters after the StartPosition to extract

    • Prefix -2 digit prefix to add to extracted 2 character date, to make a 4 character date.

  • MonthString - Delimited list containing

    • Input - Input text

    • StartPosition - Which position to start from, relative to the beginning on the Input text

    • CharacterCount - Number of characters after the StartPosition to extract

  • DayString - Delimited list containing

    • Input - Input text

    • StartPosition - Which position to start from, relative to the beginning on the Input text

    • CharacterCount - Number of characters after the StartPosition to extract

• Returns: Date in the format YYYY-MM-DD

extractCharactersFromEnd

• Description: Extract a configurable number of characters from within a provided string, relative to the end of the string.

• Use Case: You only want the last 5 characters from a provided string.

• Expects:

  • Input - Input text

  • String1 - Which position to start from, relative to the end on the Input text (0 being the last character)

  • String2 - Number of characters prior to the position in String1 to extract

• Returns: A slice of characters from the input text or NULL

extractCharactersFromStart

• Description: Extract a configurable number of characters from within a provided string, relative to the beginning of the string.

• Use Case: You only want the first 5 characters from a provided string.

• Expects:

  • Input - Input text

  • String1 - Which position to start from, relative to the beginning of the Input text (0 being the first character)

  • String2 - Number of characters after the position in String1 to extract

• Returns: A slice of characters from the input text or NULL

retrieveValueFromDelimitedList

• Description: Extracts a specified value from a provided delimited list.

• Use Case:

• Expects:

  • Input - Input delimited list

  • String1 - Value used as the delimiter

  • String2 - Which element from the delimited list to return

• Returns: An element extract from the Input list, or NULL

toUpperCase

• Description: Converts a provided string to UPPERCASE

• Use Case:

• Expects:

  • Input

• Returns: Input, in UPPERCASE

toLowerCase

• Description: Converts a provided string to lowercase

• Use Case:

• Expects:

  • Input

• Returns: Input, in lowercase

concat

• Description: Combines 2 provided strings, into 1 string

• Use Case:

• Expects:

  • Input1

  • Input2

• Returns: Input1Input2

random

• Description: Returns a randomly generated UUID

• Use Case:

• Expects: None

• Returns: A randomly generated UUID

toUpperCaseURL

• Description: Ensures that a provided string is a URL, and converts it to one if it isn’t (Prepends HTTP:// where necessary),

• Use Case:

• Expects:

  • Input

• Returns: Input1 in UPPERCASE converted to a URL

More Built-in Functions

DBpedia Spotlight annotate

Returns the DBpedia URLs of the detected entities in the input text

Function IRI: http://example.com/idlab/function/dbpediaSpotlight

Label	IRI
input string	http://example.com/idlab/function/str
endpoint url string	http://example.com/idlab/function/endpoint

Read local file as string

Returns the content of a local file as string

Function IRI: http://example.com/idlab/function/readFile

Label	IRI
input path	http://example.com/idlab/function/path

True condition

Returns the value if the given boolean is true, else null

Function IRI: http://example.com/idlab/function/trueCondition

Label	IRI
boolean encoded as string	http://example.com/idlab/function/strBoolean
input string	http://example.com/idlab/function/str

and

and

Function IRI: http://users.ugent.be/~bjdmeest/function/grel.ttl#boolean_and

Label	IRI
b	http://users.ugent.be/~bjdmeest/function/grel.ttl#param_rep_b

chomp

chomp

Function IRI: http://users.ugent.be/~bjdmeest/function/grel.ttl#string_chomp

Label	IRI
input value	http://users.ugent.be/~bjdmeest/function/grel.ttl#valueParameter
sep	http://users.ugent.be/~bjdmeest/function/grel.ttl#p_string_sep

contains

contains

Function IRI: http://users.ugent.be/~bjdmeest/function/grel.ttl#string_contains

Label	IRI
input value	http://users.ugent.be/~bjdmeest/function/grel.ttl#valueParameter
sub	http://users.ugent.be/~bjdmeest/function/grel.ttl#string_sub

decide

Returns a given value if input is equal to another given value

Function IRI: http://example.com/idlab/function/decide

Label	IRI
input string	http://example.com/idlab/function/str
expected input string	http://example.com/idlab/function/expectedStr
result string	http://example.com/idlab/function/result

endsWith

endsWith

Function IRI: http://users.ugent.be/~bjdmeest/function/grel.ttl#string_endsWith

Label	IRI
input value	http://users.ugent.be/~bjdmeest/function/grel.ttl#valueParameter
sub	http://users.ugent.be/~bjdmeest/function/grel.ttl#string_sub

equal

Returns true if strings are equal.

Function IRI: http://example.com/idlab/function/equal

Label	IRI
input value	http://users.ugent.be/~bjdmeest/function/grel.ttl#valueParameter
input value 2	http://users.ugent.be/~bjdmeest/function/grel.ttl#valueParameter2

escape

Escapes a string, with a mode parameter.

Function IRI: http://users.ugent.be/~bjdmeest/function/grel.ttl#escape

Label	IRI
input value	http://users.ugent.be/~bjdmeest/function/grel.ttl#valueParameter
mode value	http://users.ugent.be/~bjdmeest/function/grel.ttl#modeParameter

getMIMEType

Returns the MIME Type of a filename

Function IRI: http://example.com/idlab/function/getMIMEType

Label	IRI
input string	http://example.com/idlab/function/str

if

if

Function IRI: http://users.ugent.be/~bjdmeest/function/grel.ttl#controls_if

Label	IRI
b	http://users.ugent.be/~bjdmeest/function/grel.ttl#bool_b
eTrue	http://users.ugent.be/~bjdmeest/function/grel.ttl#any_true
eFalse	http://users.ugent.be/~bjdmeest/function/grel.ttl#any_false

inRange

Returns whether a value is in range

Function IRI: http://example.com/idlab/function/inRange

Label	IRI
test	http://example.com/idlab/function/p_test
from	http://example.com/idlab/function/p_from
to	http://example.com/idlab/function/p_to

indexOf

indexOf

Function IRI: http://users.ugent.be/~bjdmeest/function/grel.ttl#string_indexOf

Label	IRI
input value	http://users.ugent.be/~bjdmeest/function/grel.ttl#valueParameter
sub	http://users.ugent.be/~bjdmeest/function/grel.ttl#string_sub

join

join

Function IRI: http://users.ugent.be/~bjdmeest/function/grel.ttl#array_join

Label	IRI
a	http://users.ugent.be/~bjdmeest/function/grel.ttl#p_array_a
sep	http://users.ugent.be/~bjdmeest/function/grel.ttl#p_string_sep

length

length

Function IRI: http://users.ugent.be/~bjdmeest/function/grel.ttl#string_length

Label	IRI
input value	http://users.ugent.be/~bjdmeest/function/grel.ttl#valueParameter

listContainsElement

Returns true if the string is found in the list

Function IRI: http://example.com/idlab/function/listContainsElement

Label	IRI
list	http://example.com/idlab/function/list
input string	http://example.com/idlab/function/str

mqlKeyUnquote

mqlKeyUnquote

Function IRI: http://users.ugent.be/~bjdmeest/function/grel.ttl#string_mqlKeyUnquote

Label	IRI
key	http://users.ugent.be/~bjdmeest/function/grel.ttl#p_key

not

not

Function IRI: http://users.ugent.be/~bjdmeest/function/grel.ttl#boolean_not

Label	IRI
b	http://users.ugent.be/~bjdmeest/function/grel.ttl#bool_b

not equal

Returns true if strings are not equal.

Function IRI: http://example.com/idlab/function/notEqual

Label	IRI
input value	http://users.ugent.be/~bjdmeest/function/grel.ttl#valueParameter
input value 2	http://users.ugent.be/~bjdmeest/function/grel.ttl#valueParameter2

or

or

Function IRI: http://users.ugent.be/~bjdmeest/function/grel.ttl#boolean_or

Label	IRI
b	http://users.ugent.be/~bjdmeest/function/grel.ttl#param_rep_b

random

Returns a random uuid.

Function IRI: http://example.com/idlab/function/random

This function does not take any arguments.

split

split

Function IRI: http://users.ugent.be/~bjdmeest/function/grel.ttl#string_split

Label	IRI
input value	http://users.ugent.be/~bjdmeest/function/grel.ttl#valueParameter
sep	http://users.ugent.be/~bjdmeest/function/grel.ttl#p_string_sep

startsWith

startsWith

Function IRI: http://users.ugent.be/~bjdmeest/function/grel.ttl#string_startsWith

Label	IRI
input value	http://users.ugent.be/~bjdmeest/function/grel.ttl#valueParameter
sub	http://users.ugent.be/~bjdmeest/function/grel.ttl#string_sub

stringContainsOtherString

Returns true if a string is found in a delimited string.

Function IRI: http://example.com/idlab/function/stringContainsOtherString

Label	IRI
input string	http://example.com/idlab/function/str
other input string	http://example.com/idlab/function/otherStr
delimiter	http://example.com/idlab/function/delimiter

substring

substring

Function IRI: http://users.ugent.be/~bjdmeest/function/grel.ttl#string_substring

Label	IRI
input value	http://users.ugent.be/~bjdmeest/function/grel.ttl#valueParameter
from	http://users.ugent.be/~bjdmeest/function/grel.ttl#param_int_i_from
to	http://users.ugent.be/~bjdmeest/function/grel.ttl#param_int_i_opt_to

toLowercase

Returns the input with all letters in lower case.

Function IRI: http://users.ugent.be/~bjdmeest/function/grel.ttl#toLowerCase

Label	IRI
input value	http://users.ugent.be/~bjdmeest/function/grel.ttl#valueParameter

toUppercase

Returns the input with all letters in upper case.

Function IRI: http://users.ugent.be/~bjdmeest/function/grel.ttl#toUpperCase

Label	IRI

Label	IRI
input value	http://users.ugent.be/~bjdmeest/function/grel.ttl#valueParameter

toTitlecase

toTitlecase

Function IRI: http://users.ugent.be/~bjdmeest/function/grel.ttl#string_toTitlecase

Label	IRI
input value	http://users.ugent.be/~bjdmeest/function/grel.ttl#valueParameter

toUpperCaseURL

Returns an uppercase, valid url.

Function IRI: http://example.com/idlab/function/toUpperCaseURL

Label	IRI
input string	http://example.com/idlab/function/str

trim

trim

Function IRI: http://users.ugent.be/~bjdmeest/function/grel.ttl#string_trim

Label	IRI
input value	http://users.ugent.be/~bjdmeest/function/grel.ttl#valueParameter

xor

xor

Function IRI: http://users.ugent.be/~bjdmeest/function/grel.ttl#boolean_xor

Label	IRI
b	http://users.ugent.be/~bjdmeest/function/grel.ttl#param_rep_b