Substr - ObjectVision/GeoDMS GitHub Wiki

String functions substr(ing)

1. substr(string_dataitem, startposition, length)
2. substr(string_dataitem, startposition)

1. substr(string_dataitem, startposition, length) results in a substring of string_dataitem with the number of characters of the length argument, starting from the startposition argument.
2. substr(string_dataitem, startposition) results in a substring of string_dataitem with all characters from the startposition argument.

• data item string_dataitem with string value type
• literal or parameter startposition with uint32 value type
• literal or parameter length with uint32 value type

1. substr(string_dataitem, startposition, length) : 5.15
2. substr(string_dataitem, startposition) : 7.142

attribute<string> substrA  (ADomain) := substr(A, 1, 3);
attribute<string> substr2A (ADomain) := substr(A, 1);

ADomain, nr of rows = 5

• left
• right